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 19:50:12 GMT
Message-ID: <UfMXc.66117$X12.27750@edtnps84> (raw)
In-Reply-To: <87acwgml26.fsf@stark.xeocode.com>
References: <200408271748.i7RHmfJ15766@candle.pha.pa.us>
	<87acwgml26.fsf@stark.xeocode.com>

This discussion is starting to sound like the split in HEAP memory 
management evolution, into garbage-collecting (e.g. Java) and 
non-garbage-collecting (e.g. C++).

Reclamation by GC's these days has become seriously sophisticated.
CLUSTER resembles the first generation of GC's, which were 
single-big-pass hold-everything-else threads.

Perhaps the latest in incremental GC algorithms would be worth scouting, 
for the next step in PG page management.

Greg Stark wrote:

> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> 
>>but is there any significant performance benefit to doing that which would
>>offset the compaction advantage?
> 
> Just as a side comment. Setting PCTFREE 0 PCTUSED 100 on tables that have no
> updates on them has an astonishingly big effect on speed. So the penalty for
> leaving some space free really is substantial.
> 
> I think the other poster is right. Oracle really needs pctfree because of the
> way it handles updates. Postgres doesn't really need as much because it
> doesn't try to squeeze the new tuple in the space the old one took up. If it
> doesn't fit on the page the worst that happens is it has to store it on some
> other page, whereas oracle has to do its strange row chaining thing.



view thread (41+ messages)  latest in thread

Message-ID: <UfMXc.66117$X12.27750@edtnps84>
Permalink:  ../UfMXc.66117$X12.27750@edtnps84/
Also on:    postgresql.org/message-id/UfMXc.66117$X12.27750@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: <UfMXc.66117$X12.27750@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