Prepared queries and ANALYZE - Mailing list pgsql-hackers

From Gavin Sherry
Subject Prepared queries and ANALYZE
Date
Msg-id Pine.LNX.4.21.0304280914080.21155-100000@linuxworld.com.au
Whole thread Raw
Responses Re: Prepared queries and ANALYZE  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Hi all,

Looking through the query preparing and stats analyze code, I noticed that
prepared queries using an analyzed table are not replanned. I imagine that
some users of prepared queries would not want the above behaviour, plan
stability etc, but surely others would.

I didn't notice any discusion of this in the list archives. Any technical
reasons why this shouldn't happen?

Thanks,

Gavin



pgsql-hackers by date:

Previous
From: "Sumaira Ali -"
Date:
Subject: ProcLock--> holding[]
Next
From: Tom Lane
Date:
Subject: Re: Prepared queries and ANALYZE