Re: Enumeration of tables is very slow in largish database

From: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
To: Kirill Müller <kirill(dot)mueller(at)ivt(dot)baug(dot)ethz(dot)ch>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Enumeration of tables is very slow in largish database
Date: 2012-01-11 20:36:55
Message-ID: 4F0DF2E7.50406@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)klaver(at)gmail(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Reid Thompson 2012-01-11 21:33:06 Re: Enumeration of tables is very slow in largish database
Previous Message giuliano.medina 2012-01-11 20:29:38 Problemas ao salvar endereços de rede.