X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 9B07755818 for ; Sat, 26 Feb 2005 14:04:58 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 33310-08 for ; Sat, 26 Feb 2005 14:04:56 +0000 (GMT) Received: from hub.org (hub.org [200.46.204.220]) by svr1.postgresql.org (Postfix) with ESMTP id 4761C52A67 for ; Sat, 26 Feb 2005 14:04:56 +0000 (GMT) Received: from localhost (unknown [200.46.204.144]) by hub.org (Postfix) with ESMTP id 35F4A12B079 for ; Sat, 26 Feb 2005 10:04:54 -0400 (AST) Received: from hub.org ([200.46.204.220]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 34752-02 for ; Sat, 26 Feb 2005 14:04:47 +0000 (GMT) Received: from ganymede.hub.org (blk-222-231-176.eastlink.ca [24.222.231.176]) by hub.org (Postfix) with ESMTP id 8D6B912B074 for ; Sat, 26 Feb 2005 10:04:45 -0400 (AST) Received: by ganymede.hub.org (Postfix, from userid 1000) id 4694C8B12B; Sat, 26 Feb 2005 10:05:29 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by ganymede.hub.org (Postfix) with ESMTP id 459FF8B106 for ; Sat, 26 Feb 2005 10:05:29 -0400 (AST) X-Return-Path: X-Received: from localhost ([unix socket]) by ganymede.hub.org (Cyrus v2.2.10) with LMTPA; Sat, 26 Feb 2005 08:16:34 -0400 X-Sieve: CMU Sieve 2.2 X-Received: from localhost (localhost [127.0.0.1]) by ganymede.hub.org (Postfix) with ESMTP id E70CE8AB44 for ; Sat, 26 Feb 2005 08:15:44 -0400 (AST) X-Received: from mail.postgresql.org [200.46.204.71] by localhost with IMAP (fetchmail-6.2.5) for scrappy@localhost (single-drop); Sat, 26 Feb 2005 08:15:44 -0400 (AST) X-Received: from svr1.postgresql.org ([unix socket]) by svr1.postgresql.org (Cyrus v2.2.10) with LMTPA; Sat, 26 Feb 2005 12:12:53 +0000 X-Sieve: CMU Sieve 2.2 X-Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id AA84B56438 for ; Sat, 26 Feb 2005 12:12:53 +0000 (GMT) X-Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 05452-09 for ; Sat, 26 Feb 2005 12:12:50 +0000 (GMT) X-Received: from mail.kusardi.de (server19320154105.serverpool.info [193.201.54.105]) by svr1.postgresql.org (Postfix) with SMTP id 556F156433 for ; Sat, 26 Feb 2005 12:12:48 +0000 (GMT) X-Received: (qmail 6226 invoked by uid 1012); 26 Feb 2005 12:13:16 -0000 X-Received: from postgresql@kusardi.de by debianimage by uid 1001 with qmail-scanner-1.20 (clamscan: 0.67. spamassassin: 2.63. Clear:RC:0(84.56.131.214):SA:0(?/?):. Processed in 3.581851 secs); 26 Feb 2005 12:13:16 -0000 X-Received: from unknown (HELO Common) (glenn@kusardi.de@kusardi.de@84.56.131.214) by server19320154105.serverpool.info with SMTP; 26 Feb 2005 12:13:12 -0000 Date: Sat, 26 Feb 2005 13:13:07 +0100 From: Glenn Kusardi X-Mailer: The Bat! (v2.00) CD5BF9353B3B7091 Reply-To: Glenn Kusardi X-Priority: 3 (Normal) Message-ID: <1035996232.20050226131307@kusardi.de> To: psql-performance@postgresql.org Subject: PostgreSQL 7.4.3 Performance issues on OpenBSD MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-DCC: : X-Spam-Pyzor: ReSent-Date: Sat, 26 Feb 2005 10:05:24 -0400 (AST) Resent-From: "Marc G. Fournier" Resent-To: pgsql-performance@postgresql.org ReSent-Subject: PostgreSQL 7.4.3 Performance issues on OpenBSD ReSent-Message-ID: <20050226100524.N75321@ganymede.hub.org> X-Virus-Scanned: by amavisd-new at hub.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.946 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200502/365 X-Sequence-Number: 10694 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