Re: [EXTERNAL] Re: Inserts and bad performance - Mailing list pgsql-general

From Michael Lewis
Subject Re: [EXTERNAL] Re: Inserts and bad performance
Date
Msg-id CAHOFxGoqdDyKqJDHN1vAjvRJGkFhcr98-gdfF_jkXah3AP9Z8w@mail.gmail.com
Whole thread Raw
In response to RE: [EXTERNAL] Re: Inserts and bad performance  ("Godfrin, Philippe E" <Philippe.Godfrin@nov.com>)
List pgsql-general
How many partitions? How many rows do they have when performance is slowing considerably? Does this table get many updates or is it insert only? What version of PostgreSQL? Are the inserts randomly distributed among the partitions or targeting one or a few partitions? Are you able to capture an example and run it in a transaction with explain (analyze, buffers, verbose) and then rollback?


Michael Lewis  |  Database Engineer
Entrata

pgsql-general by date:

Previous
From: "Godfrin, Philippe E"
Date:
Subject: RE: [EXTERNAL] Re: Inserts and bad performance
Next
From: David Rowley
Date:
Subject: Re: [EXTERNAL] Re: Inserts and bad performance