Horton
Menu

Re: pg_autovacuum is nice ... but ...

Justin Clift <justin@postgresql.org>

View thread
From: Justin Clift <justin@postgresql.org>
To: "Marc G. Fournier" <scrappy@postgresql.org>
Cc: pgsql-www@postgresql.org
Date: 2004-11-03T22:29:46Z
Lists: pgsql-hackers 
Marc G. Fournier wrote:
<snip>
> Do a vacuum full analyze on the two databases being called, and load 
> time went from 2.4sec to .46sec:

Hmmmm, is there any chance your Free Space Map settings aren't high enough?

Regards and best wishes,

Justin Clift