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

Reply via email to