r 24, 2021 1:50 PM
>To: Godfrin, Philippe E < philippe.godf...@nov.com>
>Cc: pgsql-general@lists.postgresql.org
>Subject: [EXTERNAL] Re: Inserts and bad performance
>
>
>
>
>On Wed, Nov 24, 2021 at 2:15 PM Godfrin, Philippe E <
>philippe.godf...@nov.com> w
On 28/11/21 17:17, Godfrin, Philippe E wrote:
Right you are sir! I figured that out a few hours ago!
pg
*From:* Ron
*Sent:* Wednesday, November 24, 2021 10:58 PM
*To:* pgsql-general@lists.postgresql.org
*Subject:* [EXTERNAL] Re: Inserts and bad performance
On 11/24/21 1:15 PM, Godfrin
Right you are sir! I figured that out a few hours ago!
pg
From: Ron
Sent: Wednesday, November 24, 2021 10:58 PM
To: pgsql-general@lists.postgresql.org
Subject: [EXTERNAL] Re: Inserts and bad performance
On 11/24/21 1:15 PM, Godfrin, Philippe E wrote: [snip] I dropped the unique
index , rebuilt
like to
know what separates COPY from bulk inserts…
pf
From: Gavin Roy
Sent: Wednesday, November 24, 2021 1:50 PM
To: Godfrin, Philippe E
Cc: pgsql-general@lists.postgresql.org
Subject: [EXTERNAL] Re: Inserts and bad performance
On Wed, Nov 24, 2021 at 2:15 PM Godfrin, Philippe E
xplain
>(analyze, buffers, verbose) and then rollback?
Yes, I'm looking into that
pg
-Original Message-
From: David Rowley
Sent: Wednesday, November 24, 2021 7:13 PM
To: Godfrin, Philippe E
Cc: Tom Lane ; pgsql-general@lists.postgresql.org
Subject: Re: [EXTERNAL] Re: Inserts a
On Thu, 25 Nov 2021 at 08:59, Godfrin, Philippe E
wrote:
> Hi Tom. Good point about the index paging out of the buffer. I did that and
> no change. I do have the shared buffers at 40GB, so there’s a good bit there,
> but I also did all those things on the page you referred, except for using
> c
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
exa
The notion of COPY blocks and asynchronously is very interesting
From: Gavin Roy
Sent: Wednesday, November 24, 2021 1:50 PM
To: Godfrin, Philippe E
Cc: pgsql-general@lists.postgresql.org
Subject: [EXTERNAL] Re: Inserts and bad performance
On Wed, Nov 24, 2021 at 2:15 PM Godfrin, Philippe E
a certain number of records, the speed just
dropped off.
pg
From: Tom Lane
Sent: Wednesday, November 24, 2021 1:32 PM
To: Godfrin, Philippe E
Cc: pgsql-general@lists.postgresql.org
Subject: [EXTERNAL] Re: Inserts and bad performance
"Godfrin, Philippe E"
mailto:philippe.godf...@n
all
Sent: Wednesday, November 24, 2021 1:20 PM
To: Godfrin, Philippe E
Cc: pgsql-general@lists.postgresql.org
Subject: [EXTERNAL] Re: Inserts and bad performance
On Wed, Nov 24, 2021 at 07:15:31PM +, Godfrin, Philippe E wrote:
> Greetings
> I am inserting a large number of rows, 5,10,
10 matches
Mail list logo
