| From: | Andres Freund <andres(at)anarazel(dot)de> |
|---|---|
| To: | Divakar Singh <dpsmails(at)yahoo(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Insert performance with composite index |
| Date: | 2010-11-01 14:34:17 |
| Message-ID: | 201011011534.17550.andres@anarazel.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Monday 01 November 2010 15:28:19 Divakar Singh wrote:
> Do you mean these parameters have been removed starting 9.X?
> As I see on
> http://www.network-theory.co.uk/docs/postgresql/vol3/BackgroundWriter.html
> ,these parameters were added starting from 8.0 right?
No, I mean setting to 0 is a bit of a strange value in many situations.
And you have comments like:
#max_fsm_pages = 20000 # min max_fsm_relations*16, 6 bytes each
#max_fsm_relations = 1000 # min 100, ~70 bytes each
Which reference config options which do not exist anymore. And you have
shared_buffers = 81920
Which indicates that you started from 8.1/8.2 or so...
Andres
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Yaocl | 2010-11-02 02:50:22 | A query become very slow after upgrade from 8.1.10 to 8.4.5 |
| Previous Message | Divakar Singh | 2010-11-01 14:28:19 | Re: Insert performance with composite index |