Re: ECPG FETCH readahead

Поиск
Список
Период
Сортировка
От Noah Misch
Тема Re: ECPG FETCH readahead
Дата
Msg-id 20120409021519.GD11987@tornado.leadboat.com
обсуждение исходный текст
Ответ на Re: ECPG FETCH readahead  (Michael Meskes <meskes@postgresql.org>)
Список pgsql-hackers
On Sun, Apr 08, 2012 at 04:25:01PM +0200, Michael Meskes wrote:
> On Sat, Apr 07, 2012 at 11:50:42AM -0400, Noah Misch wrote:
> > I do call your attention to a question I raised in my second review: if a
> > program contains "DECLARE foo READAHEAD 5 CURSOR FOR ..." and the user runs
> > the program with ECPGFETCHSZ=10 in the environment, should that cursor use a
> > readahead window of 5 or of 10?  Original commentary:
> > http://archives.postgresql.org/message-id/20120329004323.GA17329@tornado.leadboat.com
> 
> I'd say it should be 5. I don't like an environment variable overwriting a
> hard-coded setting. I think this is what you, Noah, thought, too, right?

Yes.


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: bug in fast-path locking
Следующее
От: "Etsuro Fujita"
Дата:
Сообщение: Re: WIP: Collecting statistics on CSV file data