| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | Joseph Shraibman <joseph(at)xtenit(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: max_fsm_pages question |
| Date: | 2003-07-15 22:09:54 |
| Message-ID: | 200307151509.54994.josh@agliodbs.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Joe,
> Regarding the document at
> http://www.varlena.com/GeneralBits/Tidbits/perf.html#maxfsmp
>
> In section 3.3 you say max_fsm_pages should be set to the number of pages
> that vacuum reports. Does that apply to table pages only or both table and
> index pages? Because I'm finding my index pages are a lot more than the
> table pages.
Depends on which version you're using. As of 7.4 (now in beta), both ... this
is a major feature for 7.4, which should reduce the need to REINDEX
significantly.
For 7.3.3 and earlier, table pages only.
--
Josh Berkus
Aglio Database Solutions
San Francisco
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Albert Cervera Areny | 2003-07-16 14:15:01 | Bad performance using ODBC |
| Previous Message | Vivek Khera | 2003-07-15 18:04:54 | Re: Tunning FreeeBSD and PostgreSQL |