Postgres Pro
Downloads
Home   >   mailing lists

Re: Improving the performance of psql tab completion - Mailing list pgsql-hackers

From Merlin Moncure
Subject Re: Improving the performance of psql tab completion
Date
Msg-id CAHyXU0yTd=hKvH+mxfDH6wOiP7RpXW=JNNAqZGHmfYJN9LUvmg@mail.gmail.com
Whole thread Raw
In response to Re: Improving the performance of psql tab completion  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Improving the performance of psql tab completion  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: Improving the performance of psql tab completion  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
On Wed, Oct 10, 2012 at 8:45 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Merlin Moncure <mmoncure@gmail.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

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Improving the performance of psql tab completion
Next
From: Pavel Stehule
Date:
Subject: Re: enhanced error fields