Postgres Pro
Downloads
Home   >   mailing lists

Re: Temp tables being written to disk. Avoidable? [Another TO-DO] - Mailing list pgsql-sql

From Chris Ruprecht
Subject Re: Temp tables being written to disk. Avoidable? [Another TO-DO]
Date
Msg-id 001f01c12ca2$17cb2d40$5dd26383@corp.compucom.com
Whole thread Raw
In response to Temp tables being written to disk. Avoidable?  (Paul McGarry <PaulM@opentec.com.au>)
List pgsql-sql
Tree view 
(Maybe this thread is dead now, but here goes anyway)
Suggestion: have an environment variable or a PostgreSQL parameter to
indicate where to write the temp-table to. This way, you could easily direct
it to a RAM disk (if small enough) or to a drive other than your main
database. Default could be $TMP.

Best regards,
Chris



_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

pgsql-sql by date:

Previous
From: Murray Hobbs
Date:
Subject: Re: [GENERAL] protected ON DELETE CASCADE
Next
From: Vivek Khera
Date:
Subject: Re: DBD::Pg install error (freebsd)