'Re: [GENERAL] AutoVacuum Behaviour Question'

[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] AutoVacuum Behaviour Question
From:       Denis Gasparin <denis () edistar ! com>
Date:       2007-06-29 7:14:40
Message-ID: 4684B160.603 () edistar ! com
[Download RAW message or body]

Martijn van Oosterhout ha scritto:
> On Thu, Jun 28, 2007 at 11:12:19AM +0100, Bruce McAlister wrote:
>   
>> I just want to verify that I understand you correctly here, do you mean
>> that the temporary table is created by specific sql, for example, create
>> temp table, then perform some actions on that temp table, then, either
>> you remove the temp table, or, if you close the session/connection the
>> postmaster will clean up the temp table? What happens if you're using
>> connection pools, i mean are those sessions deemed "closed" after the
>> queries complete, when the pool connections are persistent.
>>     
>
> Yes, the temp table is private to the session and will be removed once
> the session closes, if not sooner. As for connection pools, IIRC there
> is a RESET SESSION command which should also get rid of the temporary
> tables.
>   
RESET SESSION command is available only in 8.2 branch, isn't it?
I tried to issue the command in a 8.1 server and the answer was: ERROR: 
unrecognized configuration parameter "session"

Is there available a patch for the 8.1 version of postgresql?

Thank you,
Denis

[Attachment #3 (text/html)]

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-15"
 http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Martijn van Oosterhout ha scritto:
<blockquote cite="mid:20070628104102.GB12791@svana.org" type="cite">
  <pre wrap="">On Thu, Jun 28, 2007 at 11:12:19AM +0100, Bruce McAlister wrote:
  </pre>
  <blockquote type="cite">
    <pre wrap="">I just want to verify that I understand you correctly here, do you mean
that the temporary table is created by specific sql, for example, create
temp table, then perform some actions on that temp table, then, either
you remove the temp table, or, if you close the session/connection the
postmaster will clean up the temp table? What happens if you're using
connection pools, i mean are those sessions deemed "closed" after the
queries complete, when the pool connections are persistent.
    </pre>
  </blockquote>
  <pre wrap=""><!---->
Yes, the temp table is private to the session and will be removed once
the session closes, if not sooner. As for connection pools, IIRC there
is a RESET SESSION command which should also get rid of the temporary
tables.
  </pre>
</blockquote>
RESET SESSION command is available only in 8.2 branch, isn't it?<br>
I tried to issue the command in a 8.1 server and the answer was:
ERROR:  unrecognized configuration parameter "session"<br>
<br>
Is there available a patch for the 8.1 version of postgresql?<br>
<br>
Thank you,<br>
Denis<br>
</body>
</html>


[prev in list] [next in list] [prev in thread] [next in thread]
Configure | About | News | Add a list | Sponsored by KoreLogic