Re: [PERFORM] Manual vacs 5x faster than autovacs?

2009-11-16 Thread Wayne Beaver
Quoting Scott Marlowe : On Mon, Nov 16, 2009 at 9:13 AM, Wayne Beaver wrote: Quoting Scott Marlowe : On Thu, Nov 12, 2009 at 9:58 AM, Wayne Beaver wrote: Quoting Scott Marlowe : On Thu, Nov 12, 2009 at 9:14 AM, Wayne Beaver wrote: I'd seen autovacs running for hours and ha

Re: [PERFORM] Manual vacs 5x faster than autovacs?

2009-11-16 Thread Wayne Beaver
Quoting Scott Marlowe : On Thu, Nov 12, 2009 at 9:58 AM, Wayne Beaver wrote: Quoting Scott Marlowe : On Thu, Nov 12, 2009 at 9:14 AM, Wayne Beaver wrote: I'd seen autovacs running for hours and had mis-attributed this to growing query times on those tables - my thought was

Re: [PERFORM] Manual vacs 5x faster than autovacs?

2009-11-12 Thread Wayne Beaver
Quoting Scott Marlowe : On Thu, Nov 12, 2009 at 9:14 AM, Wayne Beaver wrote: I'd seen autovacs running for hours and had mis-attributed this to growing query times on those tables  - my thought was that "shrinking" the tables "more quickly" could make them "more-

Re: [PERFORM] Manual vacs 5x faster than autovacs?

2009-11-12 Thread Wayne Beaver
em resources? I would think that a full speed manual vacuum would be a lot worse. Wayne Beaver writes: Running Pg 8.3RC2, Linux server, w/8GB RAM, OpenSuSE 10.2 OS (yes, I know that's old). I have seen *really* long-running autovacs eating up system resources. While the below is not an

[PERFORM] Manual vacs 5x faster than autovacs?

2009-11-12 Thread Wayne Beaver
Hi All, Running Pg 8.3RC2, Linux server, w/8GB RAM, OpenSuSE 10.2 OS (yes, I know that's old). I have seen *really* long-running autovacs eating up system resources. While the below is not an example of *really* long, it shows how I killed an autovac which had been running for more than 1