| From: | Neil Conway <neilc(at)samurai(dot)com> |
|---|---|
| To: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
| Cc: | Kevin Old <kold(at)carolina(dot)rr(dot)com>, pgsql <pgsql-general(at)postgresql(dot)org>, pgadmin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: [GENERAL] my.cnf to postgresql.conf Conversion |
| Date: | 2002-11-01 01:54:12 |
| Message-ID: | 87lm4e5a2j.fsf@mailbox.samurai.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
"scott.marlowe" <scott(dot)marlowe(at)ihs(dot)com> writes:
> sort_mem (bigger isn't always better here. This is the amount of memory
> EACH sort operation will grab when it runs, and it seems to be that it
> will grab all of it whether it needs it or not, so be careful not to crank
> this up.
That's not correct -- sort_mem specifies the point at which a sort
operation will start to swap data to disk (i.e. the memory is not
consumed regardless). See the entry on SORT_MEM here for more info:
http://developer.postgresql.org/docs/postgres/runtime-config.html
Another parameter you might want to tweak is wal_buffers.
Cheers,
Neil
--
Neil Conway <neilc(at)samurai(dot)com> || PGP Key ID: DB3C29FC
| From | Date | Subject | |
|---|---|---|---|
| Next Message | saurabh garg | 2002-11-01 05:33:14 | hi-problem in creating database & user in postgresql |
| Previous Message | Eric L. Blevins | 2002-11-01 01:01:49 | Re: Signal 11 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2002-11-01 08:23:29 | Re: Cursors: getting the number of tuples; moving backwards |
| Previous Message | Joseph Shraibman | 2002-11-01 00:57:58 | explain math question |