Re: [HACKERS] Turn off vacuum in pgbench?

2007-09-28 Thread Bruce Momjian
Tom Lane wrote: Tatsuo Ishii [EMAIL PROTECTED] writes: Now that PostgreSQL 8.3 enables autovacuum by default, I think pgbench should stop issuing vacuum in pgbench -i since an ordinary vacuum will take very long time under autovacuum running. If there's no objection, I will remove vacuum

Re: [HACKERS] Turn off vacuum in pgbench?

2007-09-28 Thread Tom Lane
Bruce Momjian [EMAIL PROTECTED] writes: Tom Lane wrote: I'd be inclined to leave it there, simply because you'll be changing the conditions of the benchmark if you take it out. I have not noticed any particular problems with it... I wonder if autovacuum itself is going to add more

[HACKERS] Turn off vacuum in pgbench?

2007-09-25 Thread Tatsuo Ishii
Hi, Now that PostgreSQL 8.3 enables autovacuum by default, I think pgbench should stop issuing vacuum in pgbench -i since an ordinary vacuum will take very long time under autovacuum running. If there's no objection, I will remove vacuum from pgbench. -- Tatsuo Ishii SRA OSS, Inc. Japan

Re: [HACKERS] Turn off vacuum in pgbench?

2007-09-25 Thread Tom Lane
Tatsuo Ishii [EMAIL PROTECTED] writes: Now that PostgreSQL 8.3 enables autovacuum by default, I think pgbench should stop issuing vacuum in pgbench -i since an ordinary vacuum will take very long time under autovacuum running. If there's no objection, I will remove vacuum from pgbench. I'd be

Re: [HACKERS] Turn off vacuum in pgbench?

2007-09-25 Thread Pavan Deolasee
On 9/25/07, Tom Lane [EMAIL PROTECTED] wrote: I'd be inclined to leave it there, simply because you'll be changing the conditions of the benchmark if you take it out. I have not noticed any particular problems with it... The only problem I faced is while executing custom scripts using

Re: [HACKERS] Turn off vacuum in pgbench?

2007-09-25 Thread Greg Smith
On Tue, 25 Sep 2007, Tatsuo Ishii wrote: Now that PostgreSQL 8.3 enables autovacuum by default, I think pgbench should stop issuing vacuum in pgbench -i since an ordinary vacuum will take very long time under autovacuum running. If there's no objection, I will remove vacuum from pgbench. Just

Re: [HACKERS] Turn off vacuum in pgbench?

2007-09-25 Thread Simon Riggs
On Tue, 2007-09-25 at 22:16 +0530, Pavan Deolasee wrote: The only problem I faced is while executing custom scripts using pgbench. You either need to do the initialization (pgbench -i) or run with -n option (no vacuum). But I don't have any strong preference here. Yes, I had that problem