Re: functions, selects and the planner - Mailing list pgsql-general

From Tom Lane
Subject Re: functions, selects and the planner
Date
Msg-id 5733.1213502285@sss.pgh.pa.us
Whole thread Raw
In response to functions, selects and the planner  ("Matthew Dennis" <mdennis@merfer.net>)
List pgsql-general
"Matthew Dennis" <mdennis@merfer.net> writes:
> My question is when is the "select into _data" query planned/replanned?  I'm
> concerned that the query might only be planned once (e.g. the first time
> it's executed or when the function is first defined) and cached
> indefinitely.  The table t is initially empty, but grows at a fairly steady
> rate over time.  So if the table is essentially empty when the query is
> planned, a seqscan is certainly what the planner would do.  However, as time
> goes on and table t is filled with data and the stats change, will the query
> eventually be replanned?

In 8.3, a replan will occur whenever VACUUM/ANALYZE update
pg_class.reltuples, so I think you don't need to worry --- at least not
unless you've disabled autovacuum and chosen a bad manual vacuuming
strategy.

            regards, tom lane

pgsql-general by date:

Previous
From: "Matthew Dennis"
Date:
Subject: functions, selects and the planner
Next
From: "D. Dante Lorenso"
Date:
Subject: Need Tool to sync databases with 8.3.1