Re: [PERFORM] query partitioned table is very slow

2015-10-16 Thread Tom Lane
Vladimir Yavoskiy writes: > I have about 900 partitioned tables with 67 millons rows. > And I found that my query takes too much time! That's about 100X partitions too many for that amount of rows. Partitions are a good thing in small doses, otherwise planning time will kill you.

[PERFORM] query partitioned table is very slow

2015-10-16 Thread Vladimir Yavoskiy
I have about 900 partitioned tables with 67 millons rows. And I found that my query takes too much time! -- explain ( ANALYZE,VERBOSE,BUFFERS ) select report_id from cars."all" WHERE report_datetime = '2015-10-1