While this little bug was a menace to me at a bad time my biggest
problem was that I didn't have a good enough vacuum strategy and my
reasonable sized database became the size of the world. At that
point it couldn't be vacuumed without jamming up the whole server.
So I have some
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
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
Rick Gigger [EMAIL PROTECTED] writes:
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
