From: | "Meskes, Michael" <meskes(at)topsystem(dot)de> |
---|---|
To: | Michael Meskes <meskes(at)topsystem(dot)de>, "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu> |
Cc: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>, PostgreSQL Hacker <pgsql-hackers(at)postgresql(dot)org> |
Subject: | RE: [HACKERS] Profile of current backend |
Date: | 1998-02-08 10:16:17 |
Message-ID: | 11720CEF3853D011AC0C00A024B7A9E110A134@EINSTEIN |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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(at)topsystem(dot)de | Europark A2, Adenauerstr. 20
meskes(at)debian(dot)org | 52146 Wuerselen
Go SF49ers! Use Debian GNU/Linux! | Tel: (+49) 2405/4670-44
> ----------
> From: Thomas G. Lockhart[SMTP:lockhart(at)alumni(dot)caltech(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Meskes, Michael | 1998-02-08 10:16:18 | RE: [HACKERS] Profile of current backend |
Previous Message | Bruce Momjian | 1998-02-07 21:51:41 | [QUESTIONS] 6.3 question (fwd) |