Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ZPAnG-0007Kf-JR for pgsql-performance@arkaria.postgresql.org; Tue, 11 Aug 2015 14:44:46 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1ZPAnG-0008QQ-1o for pgsql-performance@arkaria.postgresql.org; Tue, 11 Aug 2015 14:44:46 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1ZPAld-0006Se-PP for pgsql-performance@postgresql.org; Tue, 11 Aug 2015 14:43:05 +0000 Received: from mail-vk0-x22f.google.com ([2607:f8b0:400c:c05::22f]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1ZPAlV-000498-4g for pgsql-performance@postgresql.org; Tue, 11 Aug 2015 14:43:05 +0000 Received: by vkbc123 with SMTP id c123so22651893vkb.0 for ; Tue, 11 Aug 2015 07:42:55 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc:content-type; bh=1mktlVc5vJedoxt85Z9bqq77/Z/wtnkiLkGx6qGjrEk=; b=j+7GW1sgQVfDJorJmJa574GY3/XXll/QAlsVp/r+Q85SiPGiB6+GS9tqLl8sGhlcug cpq8xsSXIOC4KKMyJxOwWxMKraRus7XTudUy1D6NZtZK0SxK4a8/IFOXmG8qMd4iYWJ0 cofSXDMfQkttb31c8t7vYSvnrnHARp7y24qYFr39tnp3JhEHmneSxdyCdm1g+lip+p5i DbFMkELU8s30Qfj4Hp+EO2959Sde6g4/ErAwyDwGbPmn7OGM/l5btCTJcmPItje7mIzr 2FXR9GWYHqaELVNLtM5T1BnDdwQ7Ua54JCy5tAA4CZbAezgCYqgaWgbeBDbThgvCsXG4 ai0g== X-Received: by 10.52.119.133 with SMTP id ku5mr32262618vdb.16.1439304174927; Tue, 11 Aug 2015 07:42:54 -0700 (PDT) MIME-Version: 1.0 Received: by 10.31.193.135 with HTTP; Tue, 11 Aug 2015 07:42:15 -0700 (PDT) In-Reply-To: References: From: Maxim Boguk Date: Wed, 12 Aug 2015 00:42:15 +1000 Message-ID: Subject: Re: Query Plan Performance on Partitioned Table To: Rural Hunter Cc: "pgsql-performance@postgresql.org" Content-Type: multipart/alternative; boundary=047d7bf0d09e120596051d0a1e44 X-Pg-Spam-Score: -2.7 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org --047d7bf0d09e120596051d0a1e44 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Check constraints: > "article_729_cid_check" CHECK (cid =3D 729) > Used partition schema looks very simple and straightforward, and should have no issues with 80 partitions. Are you sure that you have only 80 partitions but not (lets say) 800? Are every other partition of the article table use the same general idea of partition check (cid=3Dsomething)? Maxim Boguk Senior Postgresql DBA http://www.postgresql-consulting.ru/ Phone RU: +7 910 405 4718 Phone AU: +61 45 218 5678 LinkedIn: http://www.linkedin.com/pub/maksym-boguk/80/b99/b1b Skype: maxim.boguk Jabber: maxim.boguk@gmail.com =D0=9C=D0=BE=D0=B9=D0=9A=D1=80=D1=83=D0=B3: http://mboguk.moikrug.ru/ "People problems are solved with people. If people cannot solve the problem, try technology. People will then wish they'd listened at the first stage." --047d7bf0d09e120596051d0a1e44 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable


Check constraints:
=C2=A0=C2=A0=C2=A0 "article_729_cid_= check" CHECK (cid =3D 729)


Used partition schema looks very simple and st= raightforward, and should have no issues with 80 partitions.
Are you sur= e that you have only 80 partitions but not (lets say) 800?
Are every other partition of the article table use the same general id= ea of partition check (cid=3Dsomething)?

=C2=A0
Maxim Boguk
Senior Postgresql DBA=
htt= p://www.postgresql-consulting.ru/

Phone RU: +7 910 405 4718
P= hone AU: +61 45 218 5678

LinkedIn: http://www.linkedin.com/pu= b/maksym-boguk/80/b99/b1b
Skype: maxim.boguk
Jabber: maxim.boguk@gmail.com=D0=9C=D0=BE=D0=B9=D0=9A=D1=80=D1=83=D0=B3: http://mboguk.moikrug.ru/

"People= problems are solved with people.
If people cannot solve the problem, t= ry technology.
People will then wish they'd listened at the first s= tage."

--047d7bf0d09e120596051d0a1e44--