Re: Enumeration of tables is very slow in largish database - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Enumeration of tables is very slow in largish database
Date
Msg-id 4F0DF2E7.50406@gmail.com
Whole thread Raw
In response to Re: Enumeration of tables is very slow in largish database  (Kirill Müller <kirill.mueller@ivt.baug.ethz.ch>)
Responses Re: Enumeration of tables is very slow in largish database  (Kirill Müller <kirill.mueller@ivt.baug.ethz.ch>)
List pgsql-general
On 01/11/2012 11:45 AM, Kirill Müller wrote:
> Adrian,
>
>
> On 01/11/2012 04:32 PM, Adrian Klaver wrote:
>> Would seem that they both have the same issue, namely pulling over the
>> table
>> names and the meta data is resource intensive.
> The problem is that the slow part is the "connect", just at the ***** in
> the in-line comment :-)

More digging:
Looks like QGIS use the geometry_columns table first to determine the
geometry aware tables, failing that it walks the tables looking for
geometry columns. Is the geometry_columns table up to date with the
actual tables?

> Cheers
>
> Kirill
>


--
Adrian Klaver
adrian.klaver@gmail.com

pgsql-general by date:

Previous
From: "Francisco Figueiredo Jr."
Date:
Subject: Re: Is there a reason why Postgres doesn't have Byte or tinyint?
Next
From: Reid Thompson
Date:
Subject: Re: Enumeration of tables is very slow in largish database