"Mark Cave-Ayland" <[EMAIL PROTECTED]> writes:
> OK I'm just about finished for the day now. If you email the details of
> exactly which tests/parameters you would like me to run, I'll try and run
> them tomorrow morning when I have a few spare minutes.
I've posted another version of the buffer re
Tom Lane wrote:
I don't feel this is quite ready to commit, but here it is if anyone
would like to try some performance testing. Using "pgbench -s 10"
on a single-CPU machine, I find this code a little slower than CVS tip
at shared_buffers = 1000, but noticeably faster (~10% speedup) at
1 buff
Setting java.lang.String values with the setObject method in version 8 of the
pgsql-jdbc driver (postgresql-8.0-310.jdbc3.jar) does not work as with version
7 (pg74.215.jdbc3.jar) of the driver. Example:
Create a prepared statement with sql "select localtimestamp - time ?". Call
setObject(1, ja
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]
> Sent: 16 February 2005 17:28
> To: Mark Cave-Ayland
> Cc: pgsql-patches@postgresql.org
> Subject: Re: [PATCHES] WIP: bufmgr rewrite per recent discussions
(cut)
> What do you mean by "pause" exactly? pgbench doesn't emi
"Mark Cave-Ayland" <[EMAIL PROTECTED]> writes:
> Reducing bgwriter_maxpages definitely seems to have helped with the larger
> values for shared_buffers. However, during the test I was still seeing large
> pauses that occurred at a rate that seemed inversely proportional to the
> number of shared bu
Hi Tom,
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]
> Sent: 16 February 2005 15:01
> To: Mark Cave-Ayland
> Cc: pgsql-patches@postgresql.org
> Subject: Re: [PATCHES] WIP: bufmgr rewrite per recent discussions
>
>
> "Mark Cave-Ayland" <[EMAIL PROTECTED]> writes:
> > I
"Mark Cave-Ayland" <[EMAIL PROTECTED]> writes:
> I compiled and tested your patch on a dual Opteron server with 12GB RAM
> running FC3. Here are the results I get with pgbench with a scale-factor of
> 10 over an average of 6 runs.
Thanks for posting these results. What -c and -t settings were you
Hi Tom,
I compiled and tested your patch on a dual Opteron server with 12GB RAM
running FC3. Here are the results I get with pgbench with a scale-factor of
10 over an average of 6 runs. All other postgresql.conf options were left at
their default values.
CVS tip results
---
Shared b
