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
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 |
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 |