Re: [EXTERNAL] Re: Inserts and bad performance

From: Michael Lewis <mlewis(at)entrata(dot)com>
To: "Godfrin, Philippe E" <philippe(dot)godfrin(at)nov(dot)com>
Cc: Gavin Roy <gavinr(at)aweber(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: [EXTERNAL] Re: Inserts and bad performance
Date: 2021-11-25 00:58:00
Message-ID: CAHOFxGoqdDyKqJDHN1vAjvRJGkFhcr98-gdfF_jkXah3AP9Z8w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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*

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David Rowley 2021-11-25 01:13:26 Re: [EXTERNAL] Re: Inserts and bad performance
Previous Message Godfrin, Philippe E 2021-11-24 20:27:48 RE: [EXTERNAL] Re: Inserts and bad performance