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 AA1709DC807 for ; Tue, 17 Jan 2006 09:28:59 -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 18967-01 for ; Tue, 17 Jan 2006 09:29:02 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from r1.mycybernet.net (r1.mycybernet.net [209.5.206.8]) by postgresql.org (Postfix) with ESMTP id 0A1DC9DC86A for ; Tue, 17 Jan 2006 09:28:56 -0400 (AST) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227]:34574 helo=phlogiston.dydns.org) by r1.mycybernet.net with esmtp (Exim 4.50 (FreeBSD)) id 1EyqtQ-0005yg-E7 for pgsql-performance@postgresql.org; Tue, 17 Jan 2006 08:29:00 -0500 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id F2C8B406C; Tue, 17 Jan 2006 08:28:59 -0500 (EST) Date: Tue, 17 Jan 2006 08:28:59 -0500 From: Andrew Sullivan To: pgsql-performance@postgresql.org Subject: Re: new to postgres (and db management) and performance already a problem :-( Message-ID: <20060117132859.GD21092@phlogiston.dyndns.org> 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> <074b01c61b1c$538335e0$6402a8c0@iwing> <92d3a4950601170014m352c75bes@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <92d3a4950601170014m352c75bes@mail.gmail.com> User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.074 required=5 tests=[AWL=0.074] X-Spam-Score: 0.074 X-Spam-Level: X-Archive-Number: 200601/225 X-Sequence-Number: 16703 On Tue, Jan 17, 2006 at 09:14:27AM +0100, Antoine wrote: > think about it - we do very little removing, pretty much only inserts and > selects. I will give it a vacuum full and see what happens. UPDATES? Remember that, in Postgres, UPDATE is effectively DELETE + INSERT (from the point of view of storage, not the point of view of the user). A -- Andrew Sullivan | ajs@crankycanuck.ca The plural of anecdote is not data. --Roger Brinner