Re: Slow tab completion w/ lots of tables

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: Slow tab completion w/ lots of tables
Дата
Msg-id CA+TgmoZBPn=dU=TiXFqpoMWKuxpgiQZjwPPoem59fe7O+HBpeQ@mail.gmail.com
обсуждение исходный текст
Ответ на Slow tab completion w/ lots of tables  (Stephen Frost <sfrost@snowman.net>)
Ответы Re: Slow tab completion w/ lots of tables
Re: Slow tab completion w/ lots of tables
Список 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 по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: 9.2RC1 wraps this Thursday ...
Следующее
От: Robert Haas
Дата:
Сообщение: Re: huge tlb support