Re: do postgresql this job for me ? (firebird user) - Mailing list pgsql-general

Le dimanche 24 mai 2009 à 11:34:46, mnavahan a écrit :
> [...]
> >>Temp tables are allocated on disk. However, they get the normal benefits
> >>of PostgreSQL's caching, and tend to be very fast. You can put them in a
> >>tablespace on a RAM disk or the like if you want, though.
>
> i read some about PG but dont see any topic about put some table to
> different tablespace
> really can do it ?

Yes, of course. You can use the ALTER TABLE statement
(http://www.postgresql.org/docs/8.3/interactive/sql-altertable.html) on a
regular table.

For temporary objects (like table), you can also use the temp_tablespace
parameter (http://www.postgresql.org/docs/8.3/interactive/runtime-config-
client.html#GUC-TEMP-TABLESPACES).


--
Guillaume.
 http://www.postgresqlfr.org
 http://dalibo.com