Performance decrease

From: "Radovan Antloga" <radovan(dot)antloga(at)siol(dot)net>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Performance decrease
Date: 2006-04-20 15:20:56
Message-ID: 011b01c6648e$067ee170$1e4ba8c0@AR6
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Gevik Babakhani 2006-04-20 15:40:55 TODO item pg_hba.conf
Previous Message Tom Lane 2006-04-20 15:11:19 Re: pg_dump -Ft failed on Windows XP

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2006-04-20 15:41:41 Re: Performance decrease
Previous Message Luke Lonergan 2006-04-20 15:16:34 Re: Quick Performance Poll