Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id B97079FB4EF for ; Thu, 5 Apr 2007 15:05:10 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 48619-05 for ; Thu, 5 Apr 2007 15:04:53 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from davinci.ethosmedia.com (server227.ethosmedia.com [209.128.84.227]) by postgresql.org (Postfix) with ESMTP id 097769FBC55 for ; Thu, 5 Apr 2007 15:04:52 -0300 (ADT) X-EthosMedia-Virus-Scanned: no infections found Received: from [63.195.55.98] (account josh@agliodbs.com HELO [192.168.2.3]) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.1.8) with ESMTP id 11833003 for pgsql-performance@postgresql.org; Thu, 05 Apr 2007 11:08:56 -0700 From: Josh Berkus Organization: PostgreSQL @ Sun To: pgsql-performance@postgresql.org Subject: Re: Equivalents in PostgreSQL of MySQL's "ENGINE=MEMORY" "MAX_ROWS=1000" Date: Thu, 5 Apr 2007 11:05:16 -0700 User-Agent: KMail/1.8.2 References: <4612A421.4060808@andromeiberica.com> <5482c80a0704040134q760dc58fp6eda892ab70eb738@mail.gmail.com> <5482c80a0704040546q7a27e2cdk8ed8307f0ebb39f8@mail.gmail.com> In-Reply-To: <5482c80a0704040546q7a27e2cdk8ed8307f0ebb39f8@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200704051105.16516.josh@agliodbs.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/111 X-Sequence-Number: 23988 Dimitri, > Probably another helpful solution may be to implement: > > ALTER TABLE LOGGING OFF/ON; > > just to disable/enable WAL? Actually, a patch similar to this is currently in the queue for 8.3. -- Josh Berkus PostgreSQL @ Sun San Francisco