From: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
---|---|
To: | "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org> |
Cc: | Justin Clift <justin(at)postgresql(dot)org>, pgsql-www(at)postgresql(dot)org |
Subject: | Re: pg_autovacuum is nice ... but ... |
Date: | 2004-11-04 03:32:36 |
Message-ID: | 200411032232.36141.xzilla@users.sourceforge.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-www |
On Wednesday 03 November 2004 20:50, Marc G. Fournier wrote:
> On Thu, 4 Nov 2004, Justin Clift wrote:
> > Marc G. Fournier wrote:
> >> 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 :(
> >
Those numbers don't look right, but I'd say increase your max_fsm_pages to
25000 and your max_fsm_relations to 1250. Don't forget to HUP.
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2004-11-04 03:57:41 | Re: plans for bitmap indexes? |
Previous Message | Tom Lane | 2004-11-04 03:18:33 | Re: Edit query buffer |
From | Date | Subject | |
---|---|---|---|
Next Message | Marc G. Fournier | 2004-11-04 03:43:24 | Re: Inadequate hosting for www.postgresql.org |
Previous Message | Mitch Pirtle | 2004-11-04 02:53:26 | Re: Inadequate hosting for www.postgresql.org |