| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Ulrich Wisser <ulrich(dot)wisser(at)relevanttraffic(dot)se> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Need for speed |
| Date: | 2005-08-17 14:52:48 |
| Message-ID: | 18975.1124290368@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Ulrich Wisser <ulrich(dot)wisser(at)relevanttraffic(dot)se> writes:
> My machine has 2GB memory, please find postgresql.conf below.
> max_fsm_pages = 50000 # min max_fsm_relations*16, 6 bytes each
FWIW, that index I've been groveling through in connection with your
other problem contains an astonishingly large amount of dead space ---
almost 50%. I suspect that you need a much larger max_fsm_pages
setting, and possibly more-frequent vacuuming, in order to keep a lid
on the amount of wasted space.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John A Meinel | 2005-08-17 15:18:35 | Re: [PERFORM] Data Selection Slow From VB 6.0 |
| Previous Message | Dave Cramer | 2005-08-17 12:59:30 | Re: [PERFORM] Performance problem using V3 protocol in jdbc driver |