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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
