Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 0487E9FBAEE for ; Tue, 3 Apr 2007 16:06:14 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 73711-03 for ; Tue, 3 Apr 2007 16:05:51 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from outmail136082.authsmtp.co.uk (outmail136082.authsmtp.co.uk [62.13.136.82]) by postgresql.org (Postfix) with ESMTP id 5DF999FBB0D for ; Tue, 3 Apr 2007 16:05:53 -0300 (ADT) Received: from outmail128178.authsmtp.net (outmail128178.authsmtp.net [62.13.128.178]) by punt2.authsmtp.com (8.13.8/8.13.8/Kp) with ESMTP id l33J5pld062698; Tue, 3 Apr 2007 20:05:51 +0100 (BST) Received: from [192.168.2.2] (adsl-63-195-55-98.dsl.snfc21.pacbell.net [63.195.55.98]) (authenticated bits=0) by mail.authsmtp.com (8.13.8/8.13.8/Kp) with ESMTP id l33J5n3L060994; Tue, 3 Apr 2007 20:05:50 +0100 (BST) Message-ID: <4612A57B.2030601@agliodbs.com> Date: Tue, 03 Apr 2007 12:05:31 -0700 From: Josh Berkus User-Agent: Thunderbird 1.5.0.10 (Macintosh/20070221) MIME-Version: 1.0 To: arnaulist@andromeiberica.com CC: pgsql-performance@postgresql.org Subject: Re: Equivalents in PostgreSQL of MySQL's "ENGINE=MEMORY" "MAX_ROWS=1000" References: <4612A421.4060808@andromeiberica.com> In-Reply-To: <4612A421.4060808@andromeiberica.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Server-Quench: 569b4271-e216-11db-a443-001185d377ca X-AuthRoute: OCdyZgscClZXSx8a IioLCC5HRQ8+YBZL BAkGMA9GIUINWEQL c1ACdR16KEdbHwkB BHYJW15UVVd0WS1z aBRQZABDZ09QVg11 Uk1LR01SWllrAmYE WB1iUh9yfgxCNndz ZghnWHkJWEZ9dFso QE9SCGwHMTV9OWQb U11YdwJVeAYefRhC OQExNiYHcQ5nExgW ODUWCngcJCheNi1R TwcRNhoTRw4zGSUg SAoPJgwLVUoLDwAi FCUCZUVUVms3HWQU HA4EdHc/CS5YaEUU Omh9NxV+GGJUHnJz VUky X-Authentic-SMTP: 61633136333939.squirrel.dmpriest.net.uk:556/Kp X-Report-SPAM: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-Virus-Status: No virus detected - but ensure you scan with your own anti-virus system! X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/25 X-Sequence-Number: 23902 Arnau, > Is there anything similar in PostgreSQL? The idea behind this is how I > can do in PostgreSQL to have tables where I can query on them very often > something like every few seconds and get results very fast without > overloading the postmaster. If you're only querying the tables every few seconds, then you don't really need to worry about performance. --Josh Berkus