From: Tom Lane <tgl@sss.pgh.pa.us>
To: Vladimir Yavoskiy <vovka@krevedko.su>
Cc: pgsql-performance@postgresql.org
Subject: Re: query partitioned table is very slow
Date: Fri, 16 Oct 2015 19:02:08 -0400
Message-ID: <4321.1445036528@sss.pgh.pa.us> (raw)
In-Reply-To: <5621740E.3010002@krevedko.su>
References: <5621740E.3010002@krevedko.su>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, vovka@krevedko.su
Subject: Re: query partitioned table is very slow
In-Reply-To: <4321.1445036528@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox