CLUSTER = slower vacuum?

From: "Phoenix Kiula" <phoenix(dot)kiula(at)gmail(dot)com>
To: "Postgres General" <pgsql-general(at)postgresql(dot)org>
Subject: CLUSTER = slower vacuum?
Date: 2007-09-26 15:20:00
Message-ID: e373d31e0709260820w76355039scd906740ff926511@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

After I clustered the primary key index of a table with about 300,000
rows, my vacuum/analyze on that table is taking too long ... over 15
mins when originally it was 15 seconds! Nothing else has been changed
with this table. Is clustering not good for vacuums?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2007-09-26 15:21:26 Re: PG_DUMP not working
Previous Message Raymond O'Donnell 2007-09-26 15:06:18 Dumping from older version