Обсуждение: CLUSTER = slower vacuum?

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?

Phoenix Kiula escribió:
> 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?

No.  Something else must be happening.  Maybe examine the output of
vacuum verbose to see where the time is going?

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.