Vladimir Yavoskiy <vovka@xxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
