Thread

RE: [HACKERS] Profile of current backend

Michael Meskes <meskes@topsystem.de> — 1998-02-08T10:16:17Z

50 sounds okay and sufficient.

But I do not get that much. I get about 50 of my transactions (2updates
+ 1insert + some selects) per minute!

I do not select the big table before inserting And yes, I do use
indices. But for one key there are only two different values in the big
table.

Also, please take note that I'm still using 6.2.1 for this test. I will
switch to 6.3. as soon as the ODBC driver is working again.

Michael
--
Dr. Michael Meskes, Projekt-Manager    | topystem Systemhaus GmbH
meskes@topsystem.de                    | Europark A2, Adenauerstr. 20
meskes@debian.org                      | 52146 Wuerselen
Go SF49ers! Use Debian GNU/Linux!      | Tel: (+49) 2405/4670-44

> ----------
> From: 	Thomas G. Lockhart[SMTP:lockhart@alumni.caltech.edu]
> Sent: 	Freitag, 6. Februar 1998 16:09
> To: 	Michael Meskes
> Cc: 	Bruce Momjian; PostgreSQL Hacker
> Subject: 	Re: [HACKERS] Profile of current backend
> 
> I (and others) had done some benchmarking on simple inserts (6 months
> ago?) and
> had concluded that the speed was similar to other commercial systems
> (I was
> comparing against Ingres). I recall getting ~50TPS.
> 
> This was all before Bruce did his work on startup and runtime speeds.
> You
> really think your performance is that far off? You are doing selects
> on the big
> table before inserting? Do you have indices set up?? Our results were
> for
> inserts on a heap table, which has the least overhead...
> 
>                                                               - Tom
>