X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 9946E9DC86D for ; Tue, 17 Jan 2006 00:13:26 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 20531-03 for ; Tue, 17 Jan 2006 00:13:25 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.refusion.com (mail.refusion.com [213.144.155.20]) by postgresql.org (Postfix) with ESMTP id 47FC89DC827 for ; Tue, 17 Jan 2006 00:13:23 -0400 (AST) Received: from iwing by mail.refusion.com (MDaemon.PRO.v8.1.4.R) with ESMTP id md50000479534.msg for ; Tue, 17 Jan 2006 05:12:02 +0100 Message-ID: <074b01c61b1c$538335e0$6402a8c0@iwing> From: To: "Christopher Browne" , References: <43CC1938.7020807@gmail.com> <18875.1137451410@sss.pgh.pa.us> <070501c61aee$ed450560$6402a8c0@iwing> <22960.1137460135@sss.pgh.pa.us> <071801c61b05$7ea50c10$6402a8c0@iwing> Subject: Re: new to postgres (and db management) and performance already a problem :-( Date: Tue, 17 Jan 2006 05:13:09 +0100 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.3790.1830 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830 X-Authenticated-Sender: info@alternize.com X-Spam-Processed: mail.refusion.com, Tue, 17 Jan 2006 05:12:02 +0100 (not processed: message from trusted or authenticated source) X-MDRemoteIP: 80.238.235.198 X-Return-Path: me@alternize.com X-MDaemon-Deliver-To: pgsql-performance@postgresql.org X-ClamAV: Pass X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=2.724 required=5 tests=[AWL=-0.699, DNS_FROM_RFC_DSN=2.872, NO_REAL_NAME=0.55, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 2.724 X-Spam-Level: ** X-Archive-Number: 200601/216 X-Sequence-Number: 16694 > Try a), b), and c) in order on the "offending" tables as they address > the problem at increasing cost... thanks alot for the detailed information! the entire concept of vacuum isn't yet that clear to me, so your explanations and hints are very much appreciated. i'll defenitely try these steps this weekend when the next full vacuum was scheduled :-) best regards, thomas