Re: [PERFORM] Scalability in postgres

2009-05-30 Thread Greg Smith
On Fri, 29 May 2009, Scott Carey wrote: There are operations/IT people won't touch Ubuntu etc with a ten foot pole yet for production. The only thing I was suggesting is that because 2.6.28 is the latest Ubuntu kernel, that means it's gotten a lot more exposure and testing than, say, other o

Re: [PERFORM] autovacuum hung?

2009-05-30 Thread Tom Lane
Brian Cox writes: > autovacuum has been running on 2 tables for > 5 hours. There tables are > not huge (see below). For the past ~1 hour, I've shut off all other > activity on this database. The other table being vacuumed has more rows > (1897810). Anyone have any ideas about why this is taking