On Wed, Jan 23, 2008 at 07:29:16PM +0100, Thomas Lozza wrote:
> hi
>
> We have an installation of Postgres 8.1.2 (32bit on Solaris 9) with a DB
> size of about 250GB on disk. The DB is subject to fair amount of
> inserts, deletes and updates per day.
>
> Running VACUUM VERBOSE tells me that I sh
On Jan 27, 2008 5:01 PM, Thomas Lozza <[EMAIL PROTECTED]> wrote:
> Thanks for the advice.
> I used the default settings before, thought though that vacuum was a bit
> aggressive, ie, using too many resources. Now its taking very long. So
> will have to find reasonable settings in between I guess.
>
, 2008 10:48
To: Thomas Lozza
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Vacuum and FSM page size
On Jan 23, 2008 12:29 PM, Thomas Lozza <[EMAIL PROTECTED]>
wrote:
> Auto vacuum is enabled. Here are the settings:
>
> autovacuum = true
> autova
On Jan 23, 2008 12:29 PM, Thomas Lozza <[EMAIL PROTECTED]> wrote:
> Auto vacuum is enabled. Here are the settings:
>
> autovacuum = true
> autovacuum_naptime = 900
> autovacuum_vacuum_threshold = 2000
> autovacuum_analyze_threshold = 1000
> autovacuum_vacuum_scale_factor = 0.25
> autovacuum_analyze
Vivek Khera <[EMAIL PROTECTED]> writes:
> On Jan 23, 2008, at 1:29 PM, Thomas Lozza wrote:
>> We have an installation of Postgres 8.1.2 (32bit on Solaris 9) with
>> ...
> it sounds to me like your autovacuum is not running frequently enough.
Yeah. The default autovac settings in 8.1 are extrem
On Jan 23, 2008, at 1:29 PM, Thomas Lozza wrote:
We have an installation of Postgres 8.1.2 (32bit on Solaris 9) with
a DB
size of about 250GB on disk. The DB is subject to fair amount of
inserts, deletes and updates per day.
Running VACUUM VERBOSE tells me that I should allocate around 20M
hi
We have an installation of Postgres 8.1.2 (32bit on Solaris 9) with a DB
size of about 250GB on disk. The DB is subject to fair amount of
inserts, deletes and updates per day.
Running VACUUM VERBOSE tells me that I should allocate around 20M pages
to FSM (max_fsm_pages)! This looks like a rea
