polydbms / pg_sheet_fdw

MIT License
2 stars 0 forks source link

investigate performance differences between ogr and pg_sheet and also between different orders of tpch query executions. #15

Open Hyrikan opened 3 months ago

Hyrikan commented 3 months ago
Hyrikan commented 3 months ago

first fix the last error with reading sheets > 800 000 lines producing a double free in Postgresql.

Hyrikan commented 2 months ago

created all tpch queries for sheet and ogr

Hyrikan commented 2 months ago

investigate strange bad performance of ogr on some queries.

For that test intersecting ogr and sheet table of orders.

Why does ogr read ~700 000 rows of ogr_sf0001_orders?

use explain analyzer: https://explain.dalibo.com