Re: Slow tab completion w/ lots of tables - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Slow tab completion w/ lots of tables
Date
Msg-id CA+TgmoZBPn=dU=TiXFqpoMWKuxpgiQZjwPPoem59fe7O+HBpeQ@mail.gmail.com
Whole thread Raw
In response to Slow tab completion w/ lots of tables  (Stephen Frost <sfrost@snowman.net>)
Responses Re: Slow tab completion w/ lots of tables
Re: Slow tab completion w/ lots of tables
List pgsql-hackers
On Thu, Aug 16, 2012 at 10:37 PM, Stephen Frost <sfrost@snowman.net> wrote:
> Greetings,
>
>   When doing tab-completion under 9.1, pg_table_is_visible(oid) is slow
>   and is ending up as the first thing tested against all the rows
>   in pg_class.  Increasing the cost of pg_table_is_visible() up to
>   10 causes it to move to the end of the tests, which improves things
>   greatly- I thought there was a plan to make that the default..?
>
>   This is with 9.1.4.

Is this a regression versus earlier releases, or just a bad thing in general?

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: 9.2RC1 wraps this Thursday ...
Next
From: Robert Haas
Date:
Subject: Re: huge tlb support