X-Original-To: pgsql-general-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 06CFE9FA4A8 for ; Mon, 12 Jun 2006 19:34:58 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 41124-01 for ; Mon, 12 Jun 2006 19:34:46 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from mail.gmx.net (mail.gmx.de [213.165.64.20]) by postgresql.org (Postfix) with SMTP id 2238A9FA10A for ; Mon, 12 Jun 2006 19:34:47 -0300 (ADT) Received: (qmail invoked by alias); 12 Jun 2006 22:34:45 -0000 Received: from dslb-084-057-013-058.pools.arcor-ip.net (EHLO ltmku) [84.57.13.58] by mail.gmx.net (mp038) with SMTP; 13 Jun 2006 00:34:45 +0200 X-Authenticated: #23352258 From: "Milen Kulev" To: Subject: Re: Partitioning... Date: Tue, 13 Jun 2006 00:34:44 +0200 Message-ID: <007a01c68e70$6710e680$0a00a8c0@trivadis.com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.6626 Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 In-Reply-To: <13199.1150150666@sss.pgh.pa.us> X-Y-GMX-Trusted: 0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/473 X-Sequence-Number: 96845 BTW , I can not see the planner to prune/isolate the right table/partion ? (constraint_exclusion=on, Version= 8.1.3 on RHEL4) postgres=# explain analyze select count(id1) from part_all where id1 =12 ; QUERY PLAN --------------------------------------------------------------------------------------------------- Aggregate (cost=5951.74..5951.75 rows=1 width=4) (actual time=111.687..111.688 rows=1 loops=1) -> Append (cost=164.60..5463.19 rows=39084 width=49) (actual time=4.764..91.488 rows=13203 loops=1) -> Bitmap Heap Scan on part_id1_0_10 (cost=164.60..3577.60 rows=25600 width=49) (actual time=0.123..0.123 rows=0 loops=1) Recheck Cond: (id1 = 12) -> Bitmap Index Scan on idx_part_id1_0_10 (cost=0.00..164.60 rows=25600 width=0) (actual time=0.119..0.119 rows=0 loops=1) Index Cond: (id1 = 12) -> Bitmap Heap Scan on part_id1_11_20 (cost=88.19..1494.74 rows=13484 width=49) (actual time=4.635..55.140 rows=13203 loops=1) Recheck Cond: (id1 = 12) -> Bitmap Index Scan on idx_part_id1_11_20 (cost=0.00..88.19 rows=13484 width=0) (actual time=4.067..4.067 rows=13205 loops=1) Index Cond: (id1 = 12) Total runtime: 111.812 ms (11 rows) Time: 114.779 ms Regards. Milen -----Original Message----- From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Tom Lane Sent: Tuesday, June 13, 2006 12:18 AM To: Milen Kulev Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Partitioning... "Milen Kulev" writes: > But When I issue: > insert into part(id1, id2, filler) > select > round( (random()*20)::bigint,0) as id1, <---!!! Note that both partitions should be populated! > round( (random()*20)::bigint,0) as id2, > 'TTTTTTTTTTTESTTTTTZZZZZZZZZZZZZZZZZZZ' > from generate_series(0,100000); > ERROR: new row for relation "part_id1_0_10" violates check > constraint "part_id1_0_10_id1_check" Don't use random() in your test case. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly