[gdal-dev] Pg Table Listing

Sandro Santilli strk at keybit.net
Wed Mar 18 10:09:21 PDT 2015


On Wed, Mar 18, 2015 at 09:58:20AM -0700, Paul Ramsey wrote:

> There’s also a couple new relation types, ‘m’ for materialized
> views and ‘f’ for… gah! I don’t know. 

I think 'f' is for foreign data tables.

It's surprising that joining a view on catalogue tables considerably
slows down. Shouldn't the optimizer be able to rewrite the query
to skip redundancies ?

--strk;

  ()   Free GIS & Flash consultant/developer
  /\   http://strk.keybit.net/services.html


More information about the gdal-dev mailing list