Re: Improving the performance of psql tab completion

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Improving the performance of psql tab completion
Date: 2012-10-10 13:51:21
Message-ID: CAHyXU0yTd=hKvH+mxfDH6wOiP7RpXW=JNNAqZGHmfYJN9LUvmg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Oct 10, 2012 at 8:45 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Merlin Moncure <mmoncure(at)gmail(dot)com> writes:
>> ...but isn't pg_table_is_visible overkill for tab completion?
>
> How much does this help?
>
> update pg_proc set procost = 10 where proname = 'pg_table_is_visible';

hm, it fixes the problem. Also, at least for 9.2, the procost is
still set at one (just looked). Well, thanks!

merlin

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2012-10-10 13:56:46 Re: enhanced error fields
Previous Message Tom Lane 2012-10-10 13:45:07 Re: Improving the performance of psql tab completion