Re: PostgreSQL clustering VS MySQL clustering

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
Cc: marty(at)outputservices(dot)com, herve(at)elma(dot)fr, pgsql-performance(at)postgresql(dot)org
Subject: Re: PostgreSQL clustering VS MySQL clustering
Date: 2005-01-22 18:41:24
Message-ID: 20050122184124.GA21889@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Sat, Jan 22, 2005 at 12:13:00 +0900,
Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp> wrote:
>
> 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".

You are probably vacuuming too often. You want to wait until a significant
fraction of a large table is dead tuples before doing a vacuum. If you are
scanning a large table and only marking a few tuples as deleted, you aren't
getting much bang for your buck.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Chris Travers 2005-01-22 18:41:52 Re: [PERFORM] DWH on Postgresql
Previous Message Greg Stark 2005-01-22 17:20:53 Re: PostgreSQL clustering VS MySQL clustering