Vladimir Yavoskiy <vo...@krevedko.su> 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.
regards, tom lane
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
