Vladimir Yavoskiy <[email protected]> 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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
