X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6780C5E46EE for ; Sun, 15 Aug 2004 11:18:54 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 00173-01 for ; Sun, 15 Aug 2004 14:18:50 +0000 (GMT) Received: from out006.verizon.net (out006pub.verizon.net [206.46.170.106]) by svr1.postgresql.org (Postfix) with ESMTP id D1B405E46E7 for ; Sun, 15 Aug 2004 11:18:47 -0300 (ADT) Received: from [127.0.0.1] ([162.83.222.216]) by out006.verizon.net (InterMail vM.5.01.06.06 201-253-122-130-106-20030910) with ESMTP id <20040815141853.IMAW22385.out006.verizon.net@[127.0.0.1]> for ; Sun, 15 Aug 2004 09:18:53 -0500 Message-ID: <411F70CB.6040505@spacemonkeylabs.com> Date: Sun, 15 Aug 2004 10:18:51 -0400 From: Mitch Pirtle Organization: Spacemonkey Laboratories User-Agent: Mozilla Thunderbird 0.7.3 (Windows/20040803) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin Subject: PostgreSQL equivalent to MySQL's HEAP tables? Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Authentication-Info: Submitted using SMTP AUTH at out006.verizon.net from [162.83.222.216] at Sun, 15 Aug 2004 09:18:52 -0500 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/128 X-Sequence-Number: 14523 Hi gang, I have a table with three columns but many rows, that will constantly be updated and selected. The MySQL way is to create a HEAP table, or basically a table that is stored only in RAM. How shall I do this in PostgreSQL? Is there a better way? -- Mitch, loving 8.0.0 beta1