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

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 remo

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 probl

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 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

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

[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 -