Protocol 3, Execute, maxrows to return, impact?

Поиск
Список
Период
Сортировка
От Stephen R. van den Berg
Тема Protocol 3, Execute, maxrows to return, impact?
Дата
Msg-id 20080709185039.GA8190@cuci.nl
обсуждение исходный текст
Ответы Re: Protocol 3, Execute, maxrows to return, impact?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
I was wondering, if there is any real advantage to actually specify say
64 for the maxrows parameter to the Execute message in the PostgreSQL
network protocol?

I.e.:
- Is it easier on the server, because it somehow uses less total memory when batching the Executes with 64 rows at a
time?
- Is it better for latency when expecting notices/notifies in between?
- Is it simply slowing down the protocol because every 64 rows I introduce a round-trip delay for the next
PortalSuspended/Executecombo?
 

Please note that we're only running the query once, I'm just batching
the results with the Execute maxrows parameter.
-- 
Sincerely,          Stephen R. van den Berg.

Limited offer:  Pacemakers, with a unique life-time warranty


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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: [PATCHES] GIN improvements
Следующее
От: Neil Conway
Дата:
Сообщение: Re: CommitFest: how does handoff work for non-committer reviewers?