On 1/5/07, Albert Cervera Areny <[EMAIL PROTECTED]> wrote:
Here's a new version that takes into account the SELECT INTO TEMP case. Thanks Jaime!
ok. seems good to me...
What other temporary objects do you think should be considered?
sorry for the noise, seems i'm thinking on other dbms... i really thought sequences use tablespaces but it seems i was wrong... maybe once this patch is applied you can think on make indexes and [temp] sequences on temp tables use the same temp_tablespace that table is using...
Any other comments on the patch?
yes. there are 2 things missing: the first one is put temp_tablespaces in postgresql.conf and/or making it a per database parameter (i don't think it should be a per user parameter) the second are docs... ;) -- regards, Jaime Casanova "Programming today is a race between software engineers striving to build bigger and better idiot-proof programs and the universe trying to produce bigger and better idiots. So far, the universe is winning." Richard Cook ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate