Re: [HACKERS] Working happily on 8.1 (Was: panic on 7.3)

2006-01-21 Thread Tom Lane
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 aft

Re: [HACKERS] Working happily on 8.1 (Was: panic on 7.3)

2006-01-21 Thread Rick Gigger
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_lev

Re: [HACKERS] Working happily on 8.1 (Was: panic on 7.3)

2006-01-21 Thread Tom Lane
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_

[HACKERS] Working happily on 8.1 (Was: panic on 7.3)

2006-01-21 Thread Rick Gigger
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 questions