Re: [postgis-users] Is my query planner failing me, or vice versa? - Mailing list pgsql-performance

From Tom Lane
Subject Re: [postgis-users] Is my query planner failing me, or vice versa?
Date
Msg-id 10011.1134624980@sss.pgh.pa.us
Whole thread Raw
In response to Re: [postgis-users] Is my query planner failing me, or vice versa?  ("Gregory S. Williamson" <gsw@globexplorer.com>)
List pgsql-performance
"Gregory S. Williamson" <gsw@globexplorer.com> writes:
> Forgive the cross-posting, but I found myself wondering if might not
> be some way future way of telling the planner that a given table
> (column ?) has a high likelyhood of being TOASTed.

What would you expect the planner to do with the information, exactly?

We could certainly cause ANALYZE to record some estimate of this, but
I'm not too clear on what happens after that...

            regards, tom lane

pgsql-performance by date:

Previous
From: Gavin Sherry
Date:
Subject: Re: PostgreSQL performance question.
Next
From: Kevin Brown
Date:
Subject: Re: Simple Join