"Stephen R. van den Berg" <srb(at)cuci(dot)nl> writes: > 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?
There's no benefit in it from the server's perspective, if that's what you meant. The point of the parameter is to allow the client to avoid running out of memory to store all of a huge query result --- it can pull it in sections, instead. (Think of it as a built-in cursor FETCH facility.)
> - Is it simply slowing down the protocol because every 64 rows I > introduce a round-trip delay for the next PortalSuspended/Execute combo?