Re: PostgreSQL clustering VS MySQL clustering - Mailing list pgsql-performance

From Tom Lane
Subject Re: PostgreSQL clustering VS MySQL clustering
Date
Msg-id 25335.1106428223@sss.pgh.pa.us
Whole thread Raw
In response to Re: PostgreSQL clustering VS MySQL clustering  (Tatsuo Ishii <t-ishii@sra.co.jp>)
Responses Re: PostgreSQL clustering VS MySQL clustering  (Simon Riggs <simon@2ndquadrant.com>)
Re: PostgreSQL clustering VS MySQL clustering  (Tatsuo Ishii <t-ishii@sra.co.jp>)
List pgsql-performance
Tatsuo Ishii <t-ishii@sra.co.jp> writes:
> Probably VACUUM works well for small to medium size tables, but not
> for huge ones. I'm considering about to implement "on the spot
> salvaging dead tuples".

That's impossible on its face, except for the special case where the
same transaction inserts and deletes a tuple.  In all other cases, the
transaction deleting a tuple cannot know whether it will commit.

            regards, tom lane

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: inheritance performance
Next
From: Tom Lane
Date:
Subject: Re: Odd number of rows expected