Re: Slow tab completion w/ lots of tables

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