Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id A86AD2E002D for ; Tue, 29 Apr 2008 11:21:10 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 28688-05 for ; Tue, 29 Apr 2008 11:21:01 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by developer.postgresql.org (Postfix) with ESMTP id 469262E005A for ; Tue, 29 Apr 2008 11:21:01 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m3TEKm1D000945; Tue, 29 Apr 2008 10:20:49 -0400 (EDT) To: "A B" cc: pgsql-performance@postgresql.org Subject: Re: Where do a novice do to make it run faster? In-reply-to: References: Comments: In-reply-to "A B" message dated "Tue, 29 Apr 2008 11:09:48 +0200" Date: Tue, 29 Apr 2008 10:20:48 -0400 Message-ID: <944.1209478848@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/442 X-Sequence-Number: 29935 "A B" writes: > I'm not sure what the size acctually is... But I can't imagine that it > is 1,6 GB!!! I'd say I have 11MB of data in it... Sounds like you've got a rather severe case of table and/or index bloat. This is typically caused by not vacuuming often enough. The easiest way to get the size back down is probably to dump and reload the database. After that you need to look at your vacuuming practices. > Will I see a general improvement in performance in 8.3.X over 8.1.11? Probably so, if only because it has autovacuum turned on by default. That's not really a substitute for careful administration practices, but it helps. regards, tom lane