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
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
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
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