Re: [HACKERS] Performance of the temporary table creation and use.

2005-01-26 Thread Luiz Gonzaga da Mata
Tom Lane escreveu: Luiz Gonzaga da Mata <[EMAIL PROTECTED]> writes: Although to have changed they sort_mem/work_mem it for 1 MB, it did not use this area in available memory for the connection to make the creation of the temporary table. Why would you expect it to, and why would you think

Re: [HACKERS] Performance of the temporary table creation and use.

2005-01-25 Thread Michael Adler
On Tue, Jan 25, 2005 at 03:29:55PM -0800, Dann Corbit wrote: > If you store the temp tables in RAM, how will you preserve the ACID > property on power failure (without using write-through which would > negate the speed advantage)? > > The temp tables may be participating in a transaction. Temp ta

Re: [HACKERS] Performance of the temporary table creation and use.

2005-01-25 Thread Dann Corbit
If you store the temp tables in RAM, how will you preserve the ACID property on power failure (without using write-through which would negate the speed advantage)? The temp tables may be participating in a transaction. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] O

Re: [HACKERS] Performance of the temporary table creation and use.

2005-01-25 Thread Tom Lane
Luiz Gonzaga da Mata <[EMAIL PROTECTED]> writes: > Although to have changed they sort_mem/work_mem it for 1 MB, it did not > use this area in available memory for the connection to make the > creation of the temporary table. Why would you expect it to, and why would you think there is any advan