[GENERAL] pgbench not setting scale size correctly?

2008-03-14 Thread Enrico Sirola
Hello, I'm trying to perform some benchmarks using pgbench. I'm using the following rpm package: postgresql-contrib-8.3.0-2PGDG.rhel5 for x86_64, downloaded from the pgsql yum repository for centos5/amd64. When I init the pgbench database, the scale factor seems to work, however when

Re: [GENERAL] pgbench not setting scale size correctly?

2008-03-14 Thread Pavan Deolasee
On Fri, Mar 14, 2008 at 2:34 PM, Enrico Sirola [EMAIL PROTECTED] wrote: as you see, the reported scaling factor is 1, but I specified -s 1000, which seems strange... I'm going to recompile it from the sources now. Didn't I get anything or there is a bug somewhere? You must have

Re: [GENERAL] pgbench not setting scale size correctly?

2008-03-14 Thread Tom Lane
Pavan Deolasee [EMAIL PROTECTED] writes: On Fri, Mar 14, 2008 at 2:34 PM, Enrico Sirola [EMAIL PROTECTED] wrote: as you see, the reported scaling factor is 1, but I specified -s 1000, You must have initialized pgbench with scale 1. Yeah, -s is only meaningful when given with -i. Maybe

Re: [GENERAL] pgbench not setting scale size correctly?

2008-03-14 Thread Greg Smith
On Fri, 14 Mar 2008, Tom Lane wrote: Pavan Deolasee [EMAIL PROTECTED] writes: You must have initialized pgbench with scale 1. Yeah, -s is only meaningful when given with -i. Maybe someday we ought to fix pgbench to complain if you try to set it at other times. You have to pass -s in to

Re: [GENERAL] pgbench not setting scale size correctly?

2008-03-14 Thread Tom Lane
Greg Smith [EMAIL PROTECTED] writes: On Fri, 14 Mar 2008, Tom Lane wrote: Yeah, -s is only meaningful when given with -i. Maybe someday we ought to fix pgbench to complain if you try to set it at other times. You have to pass -s in to the actual run if you're specifying your own custom

Re: [GENERAL] pgbench not setting scale size correctly?

2008-03-14 Thread Justin
Tom Lane wrote: Greg Smith [EMAIL PROTECTED] writes: On Fri, 14 Mar 2008, Tom Lane wrote: Yeah, -s is only meaningful when given with -i. Maybe someday we ought to fix pgbench to complain if you try to set it at other times. You have to pass -s in to the actual run if

Re: [GENERAL] pgbench not setting scale size correctly?

2008-03-14 Thread Tom Lane
Justin [EMAIL PROTECTED] writes: I was wondering why the -s would not rescale the data? That would involve re-initializing the table contents. If that's what you want, use -i. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To

Re: [GENERAL] pgbench not setting scale size correctly?

2008-03-14 Thread Greg Smith
On Fri, 14 Mar 2008, Justin wrote: I was wondering why the -s would not rescale the data? First, you don't know how to rescale the data if someone is passing in a custom script. More importantly, people don't expect the benchmark tool to change things in tables unless specifically

Re: [GENERAL] pgbench not setting scale size correctly?

2008-03-14 Thread Justin
Tom Lane wrote: Justin [EMAIL PROTECTED] writes: I was wondering why the -s would not rescale the data? That would involve re-initializing the table contents. If that's what you want, use -i. regards, tom lane thanks

Re: [GENERAL] pgbench not setting scale size correctly?

2008-03-14 Thread Justin
Greg Smith wrote: On Fri, 14 Mar 2008, Justin wrote: I was wondering why the -s would not rescale the data? First, you don't know how to rescale the data if someone is passing in a custom script. More importantly, people don't expect the benchmark tool to change things in tables unless