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?