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 27D8552991 for ; Tue, 12 Jul 2005 10:56:24 -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 72217-06 for ; Tue, 12 Jul 2005 13:56:17 +0000 (GMT) Received: from ahab.skio.peachnet.edu (ahab.skio.peachnet.edu [168.20.254.11]) by svr1.postgresql.org (Postfix) with ESMTP id 7B2FC52988 for ; Tue, 12 Jul 2005 10:56:17 -0300 (ADT) Received: from skio.peachnet.edu (sprat.skio.peachnet.edu [168.20.2.26]) by ahab.skio.peachnet.edu (8.12.10/8.12.10) with ESMTP id j6CDu6hj010146 for ; Tue, 12 Jul 2005 09:56:06 -0400 (EDT) Message-ID: <42D3CBF6.3060802@skio.peachnet.edu> Date: Tue, 12 Jul 2005 09:56:06 -0400 From: Colton Smith User-Agent: Mozilla/5.0 (X11; U; SunOS sun4u; en-US; rv:1.4) Gecko/20040414 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: query concerning vacuum and tablespaces Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-SkIO-MailScanner-Information: Please contact the ISP for more information X-SkIO-MailScanner: Found to be clean X-MailScanner-From: smith@skio.peachnet.edu X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200507/93 X-Sequence-Number: 18149 Hi I have two general questions: Let's say I vacuum a table called 'foo'. Does that release memory for subsequent reuse by table 'barr'? Or is the marked memory restricted solely for later reuse by table 'foo'? I get the impression the latter is the case. I'm I mistaken? Is it possible to move an already populated table or index from one tablespace to another? Thanks so much!