[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-performance
Subject:    Re: [PERFORM] query partitioned table is very slow
From:       Tom Lane <tgl () sss ! pgh ! pa ! us>
Date:       2015-10-16 23:02:08
Message-ID: 4321.1445036528 () sss ! pgh ! pa ! us
[Download RAW message or body]

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


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
[prev in list] [next in list] [prev in thread] [next in thread]