Postgres Pro
Downloads
Home   >   mailing lists

Re: Vacuum analyse 8.0.3 - Mailing list pgsql-novice

From Tom Lane
Subject Re: Vacuum analyse 8.0.3
Date
Msg-id 9972.1128302297@sss.pgh.pa.us
Whole thread Raw
In response to Vacuum analyse 8.0.3  (Steve Tucknott <steve@retsol.co.uk>)
List pgsql-novice
Tree view 
Steve Tucknott <steve@retsol.co.uk> writes:
> What effect does vacuum/analyze have on open cursors?

None.  A cursor's plan is determined when it's opened.

            regards, tom lane

pgsql-novice by date:

Previous
From: Steve Tucknott
Date:
Subject: Vacuum analyse 8.0.3
Next
From: A Gilmore
Date:
Subject: Comparing arrays