Received: from localhost (uranus.hub.org [200.46.204.60]) by postgresql.org (Postfix) with ESMTP id 54C119F9B32 for ; Wed, 15 Nov 2006 16:13:39 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.60]) (amavisd-new, port 10024) with ESMTP id 65244-07 for ; Wed, 15 Nov 2006 16:13:38 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.autorevenue.com (ip-208.178.167.106.gblx.net [208.178.167.106]) by postgresql.org (Postfix) with ESMTP id 3A13D9F946B for ; Wed, 15 Nov 2006 16:13:37 -0400 (AST) Received: from D1RPQZB1 ([192.168.1.181]) (authenticated) by mail.autorevenue.com (8.11.6/8.11.6) with ESMTP id kAFKDbc05547 for ; Wed, 15 Nov 2006 15:13:37 -0500 From: "Mark Steben" To: Subject: Question on partitioning Date: Wed, 15 Nov 2006 15:13:28 -0500 Message-ID: <001201c708f2$839a8c00$b501a8c0@D1RPQZB1> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0013_01C708C8.9AC48400" X-Mailer: Microsoft Office Outlook 11 Thread-Index: AccCqcHaI3PfJ+Y0QnKYwm679EOHcwGRokAw X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2757 In-Reply-To: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/157 X-Sequence-Number: 23684 This is a multi-part message in MIME format. ------=_NextPart_000_0013_01C708C8.9AC48400 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi, the new guy is back with another question. Regarding partitioning - I set up a testing table - parent table and 4 partitioning children's tables inheriting the Attributes of the parent. I inserted 1800 rows in all - 450 equitably in each partition. The CHECK constraints work great. The PART_ID column, defined as SMALLINT, Is the partitioning column. When I query for PART_ID'S I know to be in the first partition only, the EXPLAIN says that The query plan says that it does a sequential table scan on the first partition, which is fine because I do SELECT *. However it also Does index scans on partitions 2, 3, and 4 which I did not expect since I limited the range in my WHERE clause to rows in partition 1. Do I need to load more data? Any help would be appreciated. I did set my CONSTRAINT_EXCLUSION to ON. Thank you, Mark Steben _____ From: Mark Steben [mailto:msteben@autorevenue.com] Sent: Tuesday, November 07, 2006 3:18 PM To: 'pgsql-admin@postgresql.org' Subject: Question I am very new to PostgreSQL. Is it appropriate to pose questions to this email list? I am trying to come up with a query that will list the names of the database indexes that Have been chosen as clustering indexes. I know I can get the INDEXRELID from PG.INDEX But have yet to figure out how to get the index name from there. Any help would be appreciated. And, if this is not an appropriate forum to ask questions please tell me. Thank you, Mark Steben AutoRevenue ------=_NextPart_000_0013_01C708C8.9AC48400 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi, the new guy is back with = another question.

 

Regarding partitioning – I = set up a testing table – parent table and 4 partitioning children’s = tables inheriting the

Attributes of the parent.  I = inserted 1800 rows in all – 450 equitably in each partition. The CHECK = constraints work great.

  The PART_ID column, defined = as SMALLINT, Is the partitioning column.  =

When I query for PART_ID’S I = know to be in the first partition only, the EXPLAIN says = that

The query plan says that it does a sequential table scan on the first partition, which is fine because I do = SELECT *.  However it also

Does index scans on partitions 2, = 3, and 4 which I did not expect since I limited the range in my WHERE clause to = rows in partition 1.

Do I need to load more data?  = Any help would be appreciated.  I did set my CONSTRAINT_EXCLUSION to = ON.

 

Thank  = you,

Mark = Steben

 


From: Mark = Steben [mailto:msteben@autorevenue.com]
Sent: Tuesday, November = 07, 2006 3:18 PM
To: = 'pgsql-admin@postgresql.org'
Subject: = Question

 

I am very new to PostgreSQL.  Is it appropriate = to pose questions to this email list?

 

I am trying to come up with a query that will list = the names of the database indexes = that

Have been chosen as clustering indexes.  I know = I can get the INDEXRELID from PG.INDEX

But have yet to figure out how to get the index name = from there.  Any help would be appreciated.

And, if this is not an appropriate forum to ask = questions please tell me.

 

Thank you,

Mark Steben

 

AutoRevenue

------=_NextPart_000_0013_01C708C8.9AC48400--