Rick Gigger <[EMAIL PROTECTED]> writes:
2) I didn't touch the Vacuum delay, background writer or autovacuum
settings because I wasn't familiar enough with them. Are the default
values very restricting?
By default, autovacuum isn't even turned on --- you have to enable it
and also stats_row_level if you want to use autovac. I don't have
enough experience with it to say whether the other settings are
adequate.
Yes, I realized this not long after I started things up, so I will
have to wait till a time when I can restart postgres to try it out.
For now I have come up with something that I think will work fine.
Vacuum seems to be about a million times faster now due to a number
of factors. I am going to keep a close eye on the sessions table
making sure that it can't start getting bloated again and I think
I'll be ok. It's a saturday though so we'll really see how it holds
up on monday.
3) Several times there were backends running that were just bringing
down the system. Is there a way to signal a single backend to die
without restarting the whole db server?
SIGINT (ie query cancel) is safe enough. If that doesn't work
within a
few seconds, try SIGTERM (there is controversy over how safe that is,
but people do use it).
Thanks again!
Rick
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster