From: Glenn Kusardi <postgresql@kusardi.de>
To: psql-performance@postgresql.org
Subject: PostgreSQL 7.4.3 Performance issues on OpenBSD
Date: Sat, 26 Feb 2005 13:13:07 +0100
Message-ID: <1035996232.20050226131307@kusardi.de> (raw)
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
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: postgresql@kusardi.de, psql-performance@postgresql.org
Subject: Re: PostgreSQL 7.4.3 Performance issues on OpenBSD
In-Reply-To: <1035996232.20050226131307@kusardi.de>
* 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