Re: What ist the standard setting of FETCH_COUNT?

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: What ist the standard setting of FETCH_COUNT?
Дата
Msg-id CAFj8pRBkGN67J0n+jOap0woCPDqK9sm96d2V8oXVQFWKayUx7g@mail.gmail.com
обсуждение исходный текст
Ответ на What ist the standard setting of FETCH_COUNT?  (Tiaswin <tiaswin@gmx.de>)
Список pgsql-general
Дерево обсуждения
Hi

po 19. 9. 2022 v 11:10 odesílatel Tiaswin <tiaswin@gmx.de> 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.


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

Предыдущее
От: Laura Smith
Дата:
Сообщение: pg RLS suggestions needed
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: Suggest using boolean index with (bflag is true) condition for the query with (bflag = true) clause