Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 606FC9FB5FA for ; Thu, 5 Apr 2007 16:01:21 -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 80355-01-8 for ; Thu, 5 Apr 2007 16:01:04 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.182]) by postgresql.org (Postfix) with ESMTP id 018469FBEBA for ; Thu, 5 Apr 2007 16:00:21 -0300 (ADT) Received: by py-out-1112.google.com with SMTP id a73so324492pye for ; Thu, 05 Apr 2007 12:00:20 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=YipLFgWd6hJvIfH/kQiarwzpftG1JlcBC9wmSt11+juY9q6PqjkgmuE5s6oCOhtV/D/Pr82b1mmSvXCpSnDhtuyXnU9A/MvapLj8+0xeYiMpHnXKpWTsF9WC37ykB4Dy3FInHgbkFmMi2Hn+nl7YovE6dllSAdYL4/vM9tCe8d0= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=IIelX3+UHEbIVajyV+z5/nYy45UlBZqBG5DP+DEfVGDu/qKrn2LMETOGXiftf1Q5hYX5eoytLqjgfoagEfEGvgRFcNRkrU2SVkd2j4BRvQtOob5W0Z/j6Ep3jBYln0Fh+yjLbu7s/YF8MUdSTPnMkJ0F0n1SwCQuelY+yPYa+Yc= Received: by 10.35.89.10 with SMTP id r10mr3734462pyl.1175799619942; Thu, 05 Apr 2007 12:00:19 -0700 (PDT) Received: by 10.35.110.1 with HTTP; Thu, 5 Apr 2007 12:00:19 -0700 (PDT) Message-ID: <5482c80a0704051200h51fbfb77n8122f1022c0abc66@mail.gmail.com> Date: Thu, 5 Apr 2007 21:00:19 +0200 From: Dimitri To: "Josh Berkus" Subject: Re: Equivalents in PostgreSQL of MySQL's "ENGINE=MEMORY" "MAX_ROWS=1000" Cc: pgsql-performance@postgresql.org In-Reply-To: <200704051105.16516.josh@agliodbs.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <4612A421.4060808@andromeiberica.com> <5482c80a0704040134q760dc58fp6eda892ab70eb738@mail.gmail.com> <5482c80a0704040546q7a27e2cdk8ed8307f0ebb39f8@mail.gmail.com> <200704051105.16516.josh@agliodbs.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/120 X-Sequence-Number: 23997 Wow, it's excellent! :)) probably the next step is: ALTER TABLE CACHE ON/OFF; just to force keeping any table in the cache. What do you think?... Rgds, -Dimitri On 4/5/07, Josh Berkus wrote: > 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 7: You can help support the PostgreSQL project by donating at > > http://www.postgresql.org/about/donate >