PostgreSQL 7.4.3 Performance issues on OpenBSD

From: Glenn Kusardi <postgresql(at)kusardi(dot)de>
To: psql-performance(at)postgresql(dot)org
Subject: PostgreSQL 7.4.3 Performance issues on OpenBSD
Date: 2005-02-26 12:13:07
Message-ID: 1035996232.20050226131307@kusardi.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hello,

I'm experiencing performance problems with 7.4.3 on OpenBSD 3.6, at
least I think so. It is running on a Xeon 3 GHz with 2 GB RAM.

I have a table with 22 columns, all integer, timestamp or varchar and
10 indizes on integer, timestamp and varchar columns.

The table got 8500 rows (but growing). I try to make an UPDATE on the
table with 7000 affected rows. This update takes about 2-6 seconds.

Has it to be that slow? I'm running the same query on MySQL or Oracle
databases faster on similar machines.

EXPLAIN ANALYZE UPDATE ... tells me:
QUERY PLAN:
Seq Scan on table (cost=0.00..286.57 rows=4804 width=146) (actual
time=405.206..554.433 rows=7072 loops=1)
Filter: (system_knoten_links > 3501)
Total runtime: 2928.500 ms

So that looks fine to me, except the runtime.

Without indizes the query is fast with 456 ms.
Trying to disable fsync to avoid some disc operations aren't helping.

Sincerely TIA,
Glenn

Browse pgsql-performance by date

  From Date Subject
Next Message Simon Riggs 2005-02-27 20:25:45 Re: Possible interesting extra information for explain
Previous Message Markus Schaber 2005-02-25 16:28:58 Re: is pg_autovacuum so effective ?