Skip site navigation (1) Skip section navigation (2)

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-04 01:15:38
Message-ID: 418982BA.60208@postgresql.org (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-www
Marc G. Fournier wrote:
<snip>
> I posted once asking about that, but got no responses :)
> 
> Here is a vacuum verbose on gborg's database:
> 
> INFO:  free space map: 1000 relations, 7454 pages stored; 23072 total 
> pages needed
> DETAIL:  Allocated FSM size: 1000 relations + 20000 pages = 178 kB 
> shared memory.
> and this is portal:
> 
> INFO:  free space map: 1000 relations, 7425 pages stored; 23024 total 
> pages needed
> DETAIL:  Allocated FSM size: 1000 relations + 20000 pages = 178 kB 
> shared memory.
> 
> so, you tell me ... should I increase them?  I haven't been able to find 
> any docs that talk about this :(

Hmmmm, what are the fsm settings for that postgresql.conf?

:)

Regards and best wishes,

Justin Clift


> ----
> Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
> Email: scrappy(at)hub(dot)org           Yahoo!: yscrappy              ICQ: 7615664


In response to

Responses

pgsql-www by date

Next:From: Justin CliftDate: 2004-11-04 01:22:01
Subject: Re: Inadequate hosting for www.postgresql.org
Previous:From: Marc G. FournierDate: 2004-11-04 01:01:33
Subject: Re: Inadequate hosting for www.postgresql.org

pgsql-hackers by date

Next:From: Tom LaneDate: 2004-11-04 01:40:01
Subject: Re: [HACKERS] Possible make_oidjoins_check Security Issue
Previous:From: Hicham G. ElmonguiDate: 2004-11-04 00:50:25
Subject: modifying a TupleTableSlot

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group