Re: Urgent: Tuning strategies?

On Tue, 25 Jun 2002, Markus Wollny wrote:

> There's an UPS connected to the server,

Which can also fail, and which does not protect against, e.g., a
kernel panic.

> backups are performed each day,

Well, even given the data loss, how long is it going to take you
to do a restore from those backups, compared to just letting the
database clean things up and continue on? Or do you not care about
downtime, either?

> I don't see much point in not setting fsync to false for faster updates.
> And community-data's not that valuable to us, we can without doubt risk
> loosing one day's updates.

fsync or not makes little speed difference if your log has its own disk.

> Ah, that might be one big issue - I often noticed several backends
> growing far beyond 200MB size, which got me worried...

Right. Also, for your queries doing sorts, check out the query stats
("set show_query_stats yes"; results go to the error log) and see if
they're swapping. If they are, that's killing your performance.

cjs
--
Curt Sampson  <cjs@cynic.net>   +81 90 7737 2974   http://www.netbsd.org
    Don't you know, in this new Dark Age, we're all light.  --XTC