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

From: Justin Clift <justin(at)postgresql(dot)org>
To: "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>
Cc: pgsql-www(at)postgresql(dot)org
Subject: Re: pg_autovacuum is nice ... but ...
Date: 2004-11-03 22:29:46
Message-ID: 41895BDA.1090903@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-www

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Joshua D. Drake 2004-11-03 22:36:34 Re: pg_autovacuum is nice ... but ...
Previous Message Bruce Momjian 2004-11-03 22:20:34 Re: tablespaces for temporary files

Browse pgsql-www by date

  From Date Subject
Next Message Joshua D. Drake 2004-11-03 22:36:34 Re: pg_autovacuum is nice ... but ...
Previous Message Dave Page 2004-11-03 22:18:35 Re: Inadequate hosting for www.postgresql.org