| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Jeffrey W(dot) Baker" <jwb(at)saturn5(dot)com> |
| Cc: | Jan Wieck <janwieck(at)yahoo(dot)com>, John Gray <jgray(at)azuli(dot)co(dot)uk>, Postgres general mailing list <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: pg_toast table growth out of control |
| Date: | 2002-03-12 02:23:54 |
| Message-ID: | 16383.1015899834@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Jeffrey W. Baker" <jwb(at)saturn5(dot)com> writes:
>> How big is the freespace map anyway, could this be an example
>> for that this table needs to be vacuumed even more often than
>> once per hour, Tom?
> I don't know how to tell.
I think what Jan was suggesting was increasing the default freespace
map size parameters (see postgresql.conf) to see if that makes any
difference. I'm not sure if it will, but it'd be worth trying.
Note you will need a postmaster restart after editing postgresql.conf.
These are the relevant items:
#max_fsm_relations = 100 # min 10, fsm is free space map
#max_fsm_pages = 10000 # min 1000, fsm is free space map
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Snow | 2002-03-12 04:44:09 | Can a field be a primary key as well as a foreign key? |
| Previous Message | Tom Lane | 2002-03-12 02:15:54 | Re: fmgr_info: function 0: cache lookup failed |