3 ms·
FETCH_COUNT is a psql side setting, not something you can configure server side.
by anarazel 4y ago
FETCH_COUNT is a psql side setting, not something you can configure server side.
- koolba 4y agoI think GP is referring to running psql server side on the database server itself (i.e., connecting to localhost). Running a gigantic result will keep allocating memory for the result and potentially OOM the server as it’s competing for resources with the database itself right?
- anarazel 4y agoMy point is just that you can't set FETCH_COUNT with ALTER etc (as the post I was replying to suggested), because the server doesn't know anything about the parameter, as it just affects psql.
- mac-chaffee 4y agoOh yeah seems that FETCH_COUNT is special and is not a regular setting. All normal settings that you can SET can also be set per-DB and per-user: https://www.postgresql.org/docs/current/config-setting.html#CONFIG-SETTING-SQL-COMMAND-INTERACTION https://www.postgresql.org/docs/current/config-setting.html#...
- anarazel 4y agoIt's just a clientside knob for psql. You can do something like it in any client.