pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Mischa Sandberg <ischamay.andbergsay@activestateway.com>
To: pgsql-performance@postgresql.org
Subject: Re: Equivalent praxis to CLUSTERED INDEX?
Date: Fri, 27 Aug 2004 18:26:39 GMT
Message-ID: <z1LXc.66099$X12.19104@edtnps84> (raw)
In-Reply-To: <200408271748.i7RHmfJ15766@candle.pha.pa.us>
References: <118B3D82-F850-11D8-8B8C-000A95C4BD7A@sf.net>
	<200408271748.i7RHmfJ15766@candle.pha.pa.us>

I think you've probably fingered the kicker of why PG doesn't have this 
kind of clustering already. Hence perhaps the need for other approaches
to the issue (the disk-IO efficiency of reading groups of rows related 
by a common key) that other DB's (with in-place update) address with
synchronous clustering ('heap rebalancing' ?).

Bruce Momjian wrote:
> Adi Alurkar wrote:
> 
>>IIRC it it to reduce the "overflow" of data or what oracle calls  
>>chained rows. i.e if a table has variable length columns and 10 rows  
>>get inserted into a datapage, if this datapage is full and one of the  
>>variable length field gets updated the row will now "overflow" into  
>>another datapage, but if the datapage is created with an appropriate  
>>amount of free space the updated row will be stored in one single  
>>datapage.
> 
> 
> Agreed.  What I am wondering is with our system where every update gets
> a new row, how would this help us?  I know we try to keep an update on
> the same row as the original, but is there any significant performance
> benefit to doing that which would offset the compaction advantage?
> 



view thread (41+ messages)  latest in thread

Message-ID: <z1LXc.66099$X12.19104@edtnps84>
Permalink:  ../z1LXc.66099$X12.19104@edtnps84/
Also on:    postgresql.org/message-id/z1LXc.66099$X12.19104@edtnps84

 · 

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 using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: ischamay.andbergsay@activestateway.com
  Subject: Re: Equivalent praxis to CLUSTERED INDEX?
  In-Reply-To: <z1LXc.66099$X12.19104@edtnps84>

* 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