query concerning vacuum and tablespaces

From: Colton Smith <smith(at)skio(dot)peachnet(dot)edu>
To: pgsql-admin(at)postgresql(dot)org
Subject: query concerning vacuum and tablespaces
Date: 2005-07-12 13:56:06
Message-ID: 42D3CBF6.3060802@skio.peachnet.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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!

Browse pgsql-admin by date

  From Date Subject
Next Message Sebastian Kühner 2005-07-12 17:49:00 LOOP and EXIT
Previous Message Thomas F. O'Connell 2005-07-12 05:24:11 Re: Regarding a backup scenario