query concerning vacuum and tablespaces

Поиск
Список
Период
Сортировка
От Colton Smith
Тема query concerning vacuum and tablespaces
Дата
Msg-id 42D3CBF6.3060802@skio.peachnet.edu
обсуждение исходный текст
Список 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!


В списке pgsql-admin по дате отправления:

Предыдущее
От: Ezequiel Tolnay
Дата:
Сообщение: functions vs stored procedures
Следующее
От:
Дата:
Сообщение: Import Oracle to Postgres