Re: What ist the standard setting of FETCH_COUNT?

[Pavel Stehule <pavel.stehule@xxxxxxxxx>]

Hi

po 19. 9. 2022 v 11:10 odesílatel Tiaswin <tiaswin@xxxxxx> napsal:

What is the standard default setting for fetch_count and where can I
find the current setting?

[pavel@localhost pspg-master]$ psql
Assertions: on
psql (16devel)
Type "help" for help.

(2022-09-19 11:11:47) postgres=# \set
AUTOCOMMIT = 'on'
COMP_KEYWORD_CASE = 'preserve-upper'
DBNAME = 'postgres'
ECHO = 'none'
ECHO_HIDDEN = 'off'
ENCODING = 'UTF8'
ERROR = 'false'
FETCH_COUNT = '0'
HIDE_TABLEAM = 'off'
HIDE_TOAST_COMPRESSION = 'off'
HISTCONTROL = 'none'
HISTSIZE = '500'
HOST = '/tmp'
IGNOREEOF = '0'
LAST_ERROR_MESSAGE = ''
LAST_ERROR_SQLSTATE = '00000'
_ON_ERROR_ROLLBACK_ = 'off'
_ON_ERROR_STOP_ = 'off'
PORT = '5432'
PROMPT1 = '(%`date +"%Y-%m-%d %H:%M:%S"`) %/%=# '
PROMPT2 = '%/%R%x%# '
PROMPT3 = '>> '
QUIET = 'off'
ROW_COUNT = '0'
SERVER_VERSION_NAME = '16devel'
SERVER_VERSION_NUM = '160000'
SHOW_ALL_RESULTS = 'on'
SHOW_CONTEXT = 'errors'
SINGLELINE = 'off'
SINGLESTEP = 'off'
SQLSTATE = '00000'
USER = 'pavel'
VERBOSITY = 'default'
VERSION = 'PostgreSQL 16devel on x86_64-pc-linux-gnu, compiled by gcc (GCC) 12.2.1 20220819 (Red Hat 12.2.1-2), 64-bit'
VERSION_NAME = '16devel'
VERSION_NUM = '160000'
debug_assertions = 'on'

Regards

Pavel

 

Thanks.