From: Radovan Antloga <radovan.antloga@siol.net>
To: pgsql-performance@postgresql.org
Subject: Performance decrease
Date: Thu, 20 Apr 2006 17:20:56 +0200
Message-ID: <011b01c6648e$067ee170$1e4ba8c0@AR6> (raw)
I'm new to PG and I'm testing default PG settings
for now.
I have PG 8.1.3. installed with autovacuum=on.
My test table has 15830 records with 190 fields.
I have different fields types (date, numeric, varchar,
integer, smallint,...).
I decided to evaluate PG because I need to use schemas.
First test I did is not very promising.
I tried to update one fields in test table several times
to see how PG react on this.
I do like this:
update table
set field = null
After first execute I get time 3 seconds. Then I repeat
this update. After each update time increase. I get
4 sec, 7 sec, 10 sec, 12 sec, 15 sec, 18 sec, 21 sec.
Is this normal (default) behaviour or I must do something
to prevent this.
Regards,
Radovan Antloga
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: radovan.antloga@siol.net
Subject: Re: Performance decrease
In-Reply-To: <011b01c6648e$067ee170$1e4ba8c0@AR6>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox