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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Gregory S(dot) Williamson" <gsw(at)globexplorer(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org, "PostGIS Users Discussion" <postgis-users(at)postgis(dot)refractions(dot)net>
Subject: Re: [postgis-users] Is my query planner failing me, or vice versa?
Date: 2005-12-15 05:36:20
Message-ID: 10011.1134624980@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Gregory S. Williamson" <gsw(at)globexplorer(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Bühler 2005-12-15 06:22:47 effizient query with jdbc
Previous Message Gavin Sherry 2005-12-15 02:29:43 Re: PostgreSQL performance question.