pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Partitioning in 8.1
3+ messages / 2 participants
[nested] [flat]

* Partitioning in 8.1
@ 2005-11-10 16:34 Chris Hoover <revoohc@gmail.com>
  2005-11-10 16:54 ` Re: Partitioning in 8.1 Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 3+ messages in thread

From: Chris Hoover @ 2005-11-10 16:34 UTC (permalink / raw)
  To: pgsql-admin

Does anyone have a link to documents that describe the new partitioning that
is available in 8.1 (I look at the 8.1 docs but did not see any, but I may
be blind :) )?

I'd like to experiment with it and see if it can help with our data needs.

For those interested:

I need to be able to have a live oltp table partitioned based upon a key
field or even better key fields. I really need it to be able to handle all
oltp operations. Can the new partition system handle that (i.e. one
partitioned table with insert, update, delete, and select statments thrown
at it)?

thanks,

Chris

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Partitioning in 8.1
  2005-11-10 16:34 Partitioning in 8.1 Chris Hoover <revoohc@gmail.com>
@ 2005-11-10 16:54 ` Tom Lane <tgl@sss.pgh.pa.us>
  2005-11-10 17:26   ` Re: Partitioning in 8.1 Chris Hoover <revoohc@gmail.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Tom Lane @ 2005-11-10 16:54 UTC (permalink / raw)
  To: Chris Hoover <revoohc@gmail.com>; +Cc: pgsql-admin

Chris Hoover <revoohc@gmail.com> writes:
> Does anyone have a link to documents that describe the new partitioning that
> is available in 8.1 (I look at the 8.1 docs but did not see any, but I may
> be blind :) )?

http://www.postgresql.org/docs/8.1/static/ddl-partitioning.html

It's not really a new feature in terms of there being any new syntax,
it's just that there's more optimizer support for a certain way of
doing things.

I'm not sure that this really belongs in the DDL chapter ... seems like
Performance Tips might have been a more appropriate heading to put it
under.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Partitioning in 8.1
  2005-11-10 16:34 Partitioning in 8.1 Chris Hoover <revoohc@gmail.com>
  2005-11-10 16:54 ` Re: Partitioning in 8.1 Tom Lane <tgl@sss.pgh.pa.us>
@ 2005-11-10 17:26   ` Chris Hoover <revoohc@gmail.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Chris Hoover @ 2005-11-10 17:26 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin

On 11/10/05, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> Chris Hoover <revoohc@gmail.com> writes:
> > Does anyone have a link to documents that describe the new partitioning
> that
> > is available in 8.1 (I look at the 8.1 docs but did not see any, but I
> may
> > be blind :) )?
>
> http://www.postgresql.org/docs/8.1/static/ddl-partitioning.html
>
> It's not really a new feature in terms of there being any new syntax,
> it's just that there's more optimizer support for a certain way of
> doing things.
>
> I'm not sure that this really belongs in the DDL chapter ... seems like
> Performance Tips might have been a more appropriate heading to put it
> under.
>
> regards, tom lane
>
Thanks for the link. When I originally tried to find it on Tues/Wed the
search did not seem to work with 8.1 and I did not see in looking through
the index.

Chris

^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2005-11-10 17:26 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-11-10 16:34 Partitioning in 8.1 Chris Hoover <revoohc@gmail.com>
2005-11-10 16:54 ` Tom Lane <tgl@sss.pgh.pa.us>
2005-11-10 17:26   ` Chris Hoover <revoohc@gmail.com>

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