Re: iso-8859-1 postgres ssl error "could not accept SSL connection: Success" and timeout

Поиск
Список
Период
Сортировка
Искать
От
Rui DeSousa
Тема
Re: iso-8859-1 postgres ssl error "could not accept SSL connection: Success" and timeout
Дата
в 16:49:19
Msg-id
1EC66707-6F8E-4990-88D0-CEA5C56140CB@crazybean.net
Ответ на
Re: iso-8859-1 postgres ssl error "could not accept SSL connection: Success" and timeout (Holger Jakobs)
Список
Дерево обсуждения
iso-8859-1 postgres ssl error "could not accept SSL connection: Success" and timeout Sergey Cherevko <scherevko@scorewarrior.com>
Re: iso-8859-1 postgres ssl error "could not accept SSL connection: Success" and timeout Barjesh Vashist <barjeshvashist@gmail.com>
Re: iso-8859-1 postgres ssl error "could not accept SSL connection: Success" and timeout Holger Jakobs <holger@jakobs.com>
Re: iso-8859-1 postgres ssl error "could not accept SSL connection: Success" and timeout Holger Jakobs <holger@jakobs.com>
Re: iso-8859-1 postgres ssl error "could not accept SSL connection: Success" and timeout Rui DeSousa <rui@crazybean.net>
Re: iso-8859-1 postgres ssl error "could not accept SSL connection: Success" and timeout Rui DeSousa <rui@crazybean.net>


On May 4, 2023, at 4:16 AM, Holger Jakobs <holger@jakobs.com> wrote:



shared_buffers = 4GB
temp_buffers = 8MB
work_mem = 128MB
maintenance_work_mem = 128MB
dynamic_shared_memory_type = posix

bgwriter_lru_maxpages = 0
effective_io_concurrency = 3

wal_level = hot_standby

checkpoint_completion_target = 0.9

archive_mode = on
archive_command = '/bin/true'
archive_timeout = 300

max_standby_archive_delay = 21600
max_standby_streaming_delay = 21600


I should to update my openssl to see real error? How can i do that if i use ubuntu 18.04?
I am not sure what causes the problem, but some hints anyway:
max_connections = 10000

seems very high to me. In case you really have so many clients, consider using a connection pooler.



I would agree 10k connection seems excessive and the resource allocation doesn’t backup the use of that many connections.  I would assume lots of database stalls and memory contention for the shared buffer pool with only 4GB and anything approaching even a few thousand connections let alone 10k.
 

В списке pgsql-admin по дате отправления
 Предыдущее
От: Rui DeSousa
Дата: 
Следующее
От: Erik Wienhold
Дата: 
FAQ