[ADMIN] v7.1b4 bad performance

[Schmidt, Peter]

Title: v7.1b4 bad performance





Has anyone run pgbench with the latest beta?


I'm seeing ~50 tps with 7.1b4 versus ~100 tps with v7.02 & 7.03 running postgres on FreeBSD v4.0.  I'm vacuuming before and after each test run and using -F with postmaster.  Originally I thought I had a debug build but what I'm seeing are debug msgs from vacuum.  JDBC interface is much slower...

Thanks.
Peter
[EMAIL PROTECTED]

RE: [ADMIN] v7.1b4 bad performance

[Michael Ansley]

Title: RE: [ADMIN] v7.1b4 bad performance





With -B 256 -F I'm getting around 70 tps, and I haven't got wonderful hardware: dual 450Mhz PII, 40GB SCSI drive, 320MB RAM, RH Linux 7.0.  I presume that these benchmarks are not adjusted statistically to compensate for hardware or anything like that.

pgbench -t 100 -c 5


With


pgbench -t 100 -c 10


I'm getting up to 85 tps, same server settings as above.



MikeA





-Original Message-
From: Schmidt, Peter [mailto:[EMAIL PROTECTED]]
Sent: 12 February 2001 23:53
To: '[EMAIL PROTECTED]'
Subject: [ADMIN] v7.1b4 bad performance



Has anyone run pgbench with the latest beta? 
I'm seeing ~50 tps with 7.1b4 versus ~100 tps with v7.02 & 7.03 running postgres on FreeBSD v4.0.  I'm vacuuming before and after each test run and using -F with postmaster.  Originally I thought I had a debug build but what I'm seeing are debug msgs from vacuum.  JDBC interface is much slower...

Thanks. 
Peter 
[EMAIL PROTECTED] 




**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
Nick West - Global Infrastructure Manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**

[ADMIN] Re: gmake

[Justin Clift]

Hi Orland,

gmake = GNU make

ftp://ftp.gnu.org/pub/gnu/make/

OR you can get a pre-compiled Solaris package (proper pkg format and
everything) from

www.sunfreeware.com

:-)

Regards and best wishes,

+ Justin Clift



> "Orland A. Cajilig" wrote:
> 
> Good Day!
> I'm going to install postrgesql in our sever SUN ultra10 "Solaris
> 2.6 "
> unfortunately I wasn't able to continue my installation since I can't
> find gmake.
> will you please give me some address where I can download "gmake". I
> already tried
> ftp://ftp.gnu.org. but I wasn't able to find it!
> 
> Thanks
> 
> Orland A. Cajilig
> Software Engineer
> Prime Global Solution Inc.
> Makati City, Philippines