| From: | Robert Creager <Robert_Creager(at)LogicalChaos(dot)org> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: db growing out of proportion |
| Date: | 2003-05-31 03:21:01 |
| Message-ID: | 20030530212101.37cef86f.Robert_Creager@LogicalChaos.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-performance |
On Fri, 30 May 2003 09:11:39 -0400
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> said something like:
>
> Also note that no amount of vacuuming will save you if the FSM is not
> large enough to keep track of all the free space. The default FSM
> settings, like all the other default settings in Postgres, are set up
> for a small installation. You'd probably need to raise them by at least
> a factor of 10 for this installation.
>
Tom,
Thanks for the hint. I just upped my shared_buffers to 8192, fsm_relations to 10000, fsm_pages to 100000, sort_mem to 64000, and an UPDATE which was taking over 2 hours dropped down to 1 to 2 minutes!
Nice...
Thanks,
Rob
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-05-31 04:11:26 | Re: db growing out of proportion |
| Previous Message | Tomas Szepe | 2003-05-30 23:08:21 | Re: db growing out of proportion |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Creager | 2003-05-31 03:28:46 | Re: Enabling and Disabling Sequencial Scan |
| Previous Message | Bruce Momjian | 2003-05-31 02:31:38 | Re: [PERFORM] Yet Another (Simple) Case of Index not used |