PSQLException: An I/O error occurred while sending to the backend.

Hi Team, We are using PostgreSQL 11 wherein intermittently the below exception is popping up, causing our application to lose connection with the database. It isn't reconnecting until the application is restarted. org.postgresql.util.PSQLException: An I/O error occurred while sending to the b

Re: Doubt in mvcc

Dear Ramakrishna, "two different transactions can update the same version of the row" This answer itself is wrong. In my point of view, the drawback of MVCC is just holding multiple versions of tuple in a table which leads to slowness in application access. the more your table is bloated the mor

Re: Out of memory with "create extension postgis"

From: Tom Lane Sent: Wednesday, July 29, 2020 17:05 To: Daniel Westermann (DWE) Cc: pgsql-general@lists.postgresql.org Subject: Re: Out of memory with "create extension postgis"   "Daniel Westermann (DWE)" writes: >> So this is what we got today. In the log file there is this: >> 2020-07-29 1

Re: Track pgsql steps

On Wed, Jul 29, 2020 at 7:58 PM Adrian Klaver wrote: > > On 7/29/20 8:44 AM, Olivier Leprêtre wrote: > > Hi, > > > > I have a rather long pgsql procedure and I would like to detect which > > step is currently executing (subscript 1,2,3…). Due to transaction > > isolation, it’s not possible to make

How to find out why user processes are using so much memory?

Hi, Having an application on Postgres. Most parameters are on default. Memory related parameters are slightly increased: effective_cache_size = 512MB max_connections = 300 maintenance_work_mem = 64MB shared_buffers = 512MB wal_buffers = 16MB work_mem = 10MB 92 user processes are using ar

RE: Track pgsql steps

Hi, thanks for your answers, Application_name is a good tip, 64 chars are enough to code steps, I'll use that I expected being able to write raise events to a table or to store data in another table but it doesn't appear to be possible due to transaction isolation. Thanks a lot. Olivier -M

Questions about Logical Replication - Issue ???

Hi everyone, Situation: - A Master Database on the HQ - i make a dump of the master database to the Subdivision Server - I create à Publication like: CREATE PUBLICATION iNOV_MasterData_Table_Pub FOR TABLE M_Product; On the Master Database - On the Subdivision Server, I create a Sub

Re: Track pgsql steps

are you running the psql with -c or -f? add -o to put all in a file and -e to write the last query, and with a tail to the log, you can see where is the problem On 2020-07-30 10:11, Olivier Leprêtre wrote: Hi, thanks for your answers, Application_name is a good tip, 64 chars are enough to co

Re: PSQLException: An I/O error occurred while sending to the backend.

Argha Deep Ghoshal writes: > We are using PostgreSQL 11 wherein intermittently the below exception is > popping up, causing our application to lose connection with the database. > It isn't reconnecting until the application is restarted. > org.postgresql.util.PSQLException: An I/O error occur

Re: How to find out why user processes are using so much memory?

Hi čt 30. 7. 2020 v 12:33 odesílatel Zwettler Markus (OIZ) < markus.zwett...@zuerich.ch> napsal: > Hi, > > Having an application on Postgres. > Most parameters are on default. > Memory related parameters are slightly increased: > effective_cache_size = 512MB > max_connections = 300 > maintenance_

Re: Out of memory with "create extension postgis"

"Daniel Westermann (DWE)" writes: >> Umm ... you didn't issue a "bt" when you got to errfinish, so there's >> no useful info here. > Here is a new one with bt at the end: That's just showing the stack when the backend is idle waiting for input. We need to capture the stack at the moment when the

Re: PSQLException: An I/O error occurred while sending to the backend.

Hi Tom, Appreciate your inputs. Please find my comments inline below. > We are using PostgreSQL 11 wherein intermittently the below exception is > > popping up, causing our application to lose connection with the database. > > It isn't reconnecting until the application is restarted. > > > o

Costs of Heap Fetches in Postgres 13

Hi, does the planner do estimates about heap fetches on index only scans and takes them into account? At least in Pg 13? If so, is it possible to lower those costs? random_page_costs seems not to have any influence. Looks like they cause bad planner decisions. Tuning Vacuum is not an option ;)

Re: Questions about Logical Replication - Issue ???

Hi, At Thu, 30 Jul 2020 14:54:08 +0100, FOUTE K. Jaurès wrote in > Hi everyone, > > Situation: > >- A Master Database on the HQ >- i make a dump of the master database to the Subdivision Server >- I create à Publication like: CREATE PUBLICATION >iNOV_MasterData_Table_Pub FOR T

Re: Costs of Heap Fetches in Postgres 13

On Fri, 31 Jul 2020 at 05:21, wrote: > does the planner do estimates about heap fetches on index only scans and > takes them into account? > At least in Pg 13? If so, is it possible to lower those costs? > random_page_costs seems not to have any influence. > Looks like they cause bad planner de