Re: query partitioned table is very slow

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Vladimir Yavoskiy <vovka(at)krevedko(dot)su>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: query partitioned table is very slow
Date: 2015-10-16 23:02:08
Message-ID: 4321.1445036528@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Vladimir Yavoskiy <vovka(at)krevedko(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jonathan Rogers 2015-10-17 02:14:37 Re: SELECT slows down on sixth execution
Previous Message Vladimir Yavoskiy 2015-10-16 22:02:54 query partitioned table is very slow