[gdal-dev] Pg Table Listing

[Paul Ramsey]

Yes, that’s what ‘f’ is.
It could just be that on a database with N-hundred tables the query would be slow regardless. Something I’ll do a quick test of.
I’m writing up a few variants to go into those slots for different versions.
 P


--  
http://postgis.net  
http://cleverelephant.ca


On March 18, 2015 at 10:09:26 AM, Sandro Santilli (strk at keybit.net) wrote:
> 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
>