X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 4DD4CD1CA64 for ; Sat, 1 May 2004 01:38:10 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 66066-06 for ; Sat, 1 May 2004 01:37:50 -0300 (ADT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 10D21D1B432 for ; Sat, 1 May 2004 01:37:49 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i414bmEo010460; Sat, 1 May 2004 00:37:49 -0400 (EDT) To: "Michael L. Hostbaek" Cc: pgsql-sql@postgresql.org Subject: Re: Performance issue In-reply-to: <20040427091252.GA93126@mich2.itxmarket.com> References: <20040427091252.GA93126@mich2.itxmarket.com> Comments: In-reply-to "Michael L. Hostbaek" message dated "Tue, 27 Apr 2004 11:12:52 +0200" Date: Sat, 01 May 2004 00:37:48 -0400 Message-ID: <10459.1083386268@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200405/1 X-Sequence-Number: 17715 "Michael L. Hostbaek" writes: > I cron script is being run every night (while very low db activity), > that deletes all rows from the table, and injects a bunch of new data... You should vacuum in between ... or even better, do the deletion with TRUNCATE. regards, tom lane