Re: query partitioned table is very slow - Mailing list pgsql-performance

From Tom Lane
Subject Re: query partitioned table is very slow
Date
Msg-id 4321.1445036528@sss.pgh.pa.us
Whole thread Raw
In response to query partitioned table is very slow  (Vladimir Yavoskiy <vovka@krevedko.su>)
List pgsql-performance
Vladimir Yavoskiy <vovka@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


pgsql-performance by date:

Previous
From: Vladimir Yavoskiy
Date:
Subject: query partitioned table is very slow
Next
From: Jonathan Rogers
Date:
Subject: Re: SELECT slows down on sixth execution