Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 13D202E0072 for ; Mon, 28 Apr 2008 19:41:31 -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 86976-02 for ; Mon, 28 Apr 2008 19:41:24 -0300 (ADT) X-Greylist: delayed 00:06:17.118583 by SQLgrey-1.7.5 Received: from mclaren.electric.net (mclaren.electric.net [216.129.90.240]) by developer.postgresql.org (Postfix) with ESMTP id DBA4E2E0032 for ; Mon, 28 Apr 2008 19:41:24 -0300 (ADT) Received: from 1Jqbw8-0002xA-Vk by mclaren.electric.net with emc1-ok (Exim 4.67) (envelope-from ) id 1Jqbw9-0002xc-Te for pgsql-sql@postgresql.org; Mon, 28 Apr 2008 15:35:05 -0700 Received: by emcmailer; Mon, 28 Apr 2008 15:35:05 -0700 Received: from [72.35.12.251] (helo=email.exchange.electric.net) by mclaren.electric.net with esmtp (Exim 4.67) (envelope-from ) id 1Jqbw8-0002xA-Vk for pgsql-sql@postgresql.org; Mon, 28 Apr 2008 15:35:04 -0700 Received: from 64.251.85.134 ([64.251.85.134]) by EMAIL.exchange.electric.net ([10.77.77.22]) via Exchange Front-End Server owa.electricmail.com ([10.77.77.6]) with Microsoft Exchange Server HTTP-DAV ; Mon, 28 Apr 2008 22:35:04 +0000 Received: from H-S12.internal.navarik.com by owa.electricmail.com; 28 Apr 2008 15:35:04 -0700 Subject: Truncate table at a certain size. From: Dana Huggard - Navarik To: pgsql-sql@postgresql.org Content-Type: text/plain Content-Transfer-Encoding: 7bit Organization: Navarik Corp. Date: Mon, 28 Apr 2008 15:35:04 -0700 Message-Id: <1209422104.12712.12.camel@H-S12.internal.navarik.com> Mime-Version: 1.0 X-Mailer: Evolution 2.12.3 (2.12.3-4.fc8) X-Outbound-IP: 72.35.12.251 X-Env-From: dhuggard@navarik.com X-Virus-Status: Scanned by VirusSMART (c) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.599 tagged_above=0 required=5 tests=RCVD_IN_DNSWL_LOW=-1, RCVD_NUMERIC_HELO=2.599 X-Spam-Level: * X-Archive-Number: 200804/216 X-Sequence-Number: 30755 Hello, What would be the best method to truncate a table once it reaches a certain size. For instance, a table named log. I can check the size of the log; db=# select pg_relation_size('log'); pg_relation_size ------------------ 8192 (1 row) What I would like to do is If table log, is greater than xxxx bytes then truncate table log Maybe I'll dump it to a flat file first, (yes, it should really be a flat file to start with, and not in a db.) Thank you.