On Thu, Nov 11, 2010 at 03:56:25PM -0500, gnuo...@rcn.com wrote: > On a thread some time ago, on a similar subject, I opined that I missed the > ability to assign tables to tablespaces and buffers to tablespaces, thus > having the ability to isolate needed tables (perhaps a One True Lookup Table, > for example; or a Customer table) to memory without fear of eviction. > > I was sounding beaten about the face and breast. It really is an > "Enterprise" way of handling the situation. > > regards, > Robert >
ALTER TABLE can be used to change the tablespace of a table and/or index. Cheers, Ken -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
