pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Mark Steben <msteben@autorevenue.com>
To: pgsql-admin@postgresql.org
Subject: Question on partitioning
Date: Wed, 15 Nov 2006 15:13:28 -0500
Message-ID: <001201c708f2$839a8c00$b501a8c0@D1RPQZB1> (raw)

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

view thread (6+ messages)  latest in thread

Message-ID: <001201c708f2$839a8c00$b501a8c0@D1RPQZB1>
Permalink:  ../001201c708f2$839a8c00$b501a8c0@D1RPQZB1/
Also on:    postgresql.org/message-id/001201c708f2$839a8c00$b501a8c0@D1RPQZB1

 · 

reply

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: msteben@autorevenue.com
  Subject: Re: Question on partitioning
  In-Reply-To: <001201c708f2$839a8c00$b501a8c0@D1RPQZB1>
  References: <001201c708f2$839a8c00$b501a8c0@D1RPQZB1>

* 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