From: | Edmund Mergl <E(dot)Mergl(at)bawue(dot)de> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | PostgreSQL Hackers Mailinglist <pgsql-hackers(at)postgreSQL(dot)org> |
Subject: | Re: [HACKERS] strange behavior of UPDATE |
Date: | 1999-05-22 04:39:25 |
Message-ID: | 374634FD.86C9C25@bawue.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Tom Lane wrote:
>
> Edmund Mergl <E(dot)Mergl(at)bawue(dot)de> writes:
> > When loading 100.000 rows into the table
> > everything works ok. Selects and updates
> > are reasonable fast. But when loading
> > 1.000.000 rows the select statements still
> > work, but a simple update statement
> > shows this strange behavior.
>
> Can you provide a script or something to reproduce this behavior?
>
> There are a number of people using Postgres with large databases
> and not reporting any such problem, so I think there has to be some
> special triggering condition; it's not just a matter of things
> breaking at a million rows. Before digging into it, I'd like to
> eliminate variables like whether I have the right test case.
>
> regards, tom lane
the original benchmark can be found at
ftp://ftp.heise.de/pub/ix/benches/sqlb-21.tar
for a stripped-down version see the attachment.
For loading the database and running the first
and second part (selects and updates) just do
the following:
createdb test
./make_wnt 1000000 pgsql >make.out 2>&1 &
This needs about 700 MB of diskspace.
On a PII-400 it takes about 40 minutes to
load the database, 20 minutes to create the indeces
and 20 minutes to run the first part of the
benchmark (make_sqs). For running the benchmark
in 20 minutes (without swapping) one needs 384 MB RAM.
The second part (make_nqs) contains update
statements which can not be performed properly
using PostgreSQL.
For testing it is sufficient to initialize the
database and then to perform a query like
update bench set k500k = k500k + 1 where k100 = 30
Edmund
--
Edmund Mergl mailto:E(dot)Mergl(at)bawue(dot)de
Im Haldenhau 9 http://www.bawue.de/~mergl
70565 Stuttgart fon: +49 711 747503
Germany
Attachment | Content-Type | Size |
---|---|---|
sqlbench.tgz | application/octet-stream | 6.1 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1999-05-22 05:07:42 | fix for SELECT 1; SELECT 2 fails when sent not via psql, semicolon problem |
Previous Message | Bruce Momjian | 1999-05-22 04:10:32 | DEFAULT '' fixed |