ARTEAGA Jose wrote:
> Also worth mentioning is that I just this week found out about a very,
> very important parameter "shared buffers". Ever since the original
> person setup our PG (individual no longer with us) this DB had been
> running without any major glitches, albeit slow. All this time the
> shared buffers were running at default of "64" (8192 block size). Once I
> have got this back up and running I have since set this to 1600 shared
> buffers (~125MB). I've since noticed a dramatic performance improvement,
> I hope that I've striked gold. But cannot claim victory yet it's only
> been up for 2 days.
If you think increasing shared buffers in 7.0 improves things, you
should see what upgrading to 8.2.4 will do.
Seriously, you'll freak at the increase in speed.
7.0 = handcar: http://www.handcar.net/
8.2 = TGV: http://en.wikipedia.org/wiki/TGV
(p.s. please upgrade before 7.0 eats your data...)
