From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | mnavahan <mnavahan(at)yahoo(dot)com> |
Subject: | Re: do postgresql this job for me ? (firebird user) |
Date: | 2009-05-24 13:49:49 |
Message-ID: | 200905241549.50683.guillaume@lelarge.info |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | mnavahan | 2009-05-24 14:12:06 | Re: do postgresql this job for me ? (firebird user) |
Previous Message | Jasen Betts | 2009-05-24 11:47:09 | Re: 8.3: timestamp subtraction |