Re: AutoVacuum Behaviour Question

Bruce McAlister wrote:
> Denis Gasparin wrote:

> > 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"
>
> I had a look in our configuration and there is a "session" option that
> comes up if you type "RESET " and press TAB twice. However, if you do
> try to run it, it comes back with:
>
> blueface-crm=# RESET session ;
> ERROR: unrecognized configuration parameter "session"

If you continue tab-completing you'll notice that it's actually "reset
session authorization" which is a different animal completely.

> We're running PostgreSQL 8.2.4. Alvaro said it was only going to be
> available in 8.3. I hope they backport it to 8.2 though,

No way.

> 90% of our connections are via connection pooled drivers, so being
> able to reset the session after each transaction would be a handy way
> to ensure the environment is sane for the next transaction :)

Seems you'll be one of the early adopters of 8.3 solely for this reason
;-)

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support