| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Seth Robertson <pgsql-performance(at)sysd(dot)com> |
| Cc: | <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Postgres 7.3.1 poor insert/update/search performance |
| Date: | 2003-01-21 21:46:17 |
| Message-ID: | 20030121134242.Q84028-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Tue, 21 Jan 2003, Seth Robertson wrote:
> The postgresql.conf file is default (my sysadmin nuked all of my
> changes when he upgraded to 7.3.1--grr) and there are some shared
> memory configs: kernel.sem = 250 32000 100 128, kernel.shmmax =
> 2147483648, kernel.shmmni = 100, kernel.shmmax = 134217728 The
> WAL is not seperated (but see below).
You almost certainly want to raise shared_buffers from the default (64?)
to say 1k-10k. I'm not sure how much that'll help but it should help
some.
> A "vacuum analyze" is performed between the write phase and the read
> phase. However, for your analysis pleasure, here are the results
> of a full verbose analyze and some explain results (both before and after).
BTW: what does explain analyze (rather than plain explain) show?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Seth Robertson | 2003-01-21 22:07:13 | Re: Postgres 7.3.1 poor insert/update/search performance |
| Previous Message | Seth Robertson | 2003-01-21 21:20:49 | Postgres 7.3.1 poor insert/update/search performance esp WRT Oracle |