Home > mailing lists

re: Speeding up COPY TO for uuids and arrays - Mailing list pgsql-hackers

From	Ranier Vilela
Subject	re: Speeding up COPY TO for uuids and arrays
Date	February 22 22:42:37
Msg-id	CAEudQAorCYpN727YEXpMs9kzJaa44f45cNo1sovZ_MfQJ1R1vw@mail.gmail.com Whole thread Raw
In response to	Speeding up COPY TO for uuids and arrays (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses	Re: Speeding up COPY TO for uuids and arrays
List	pgsql-hackers

Hi,

On 2024-02-17 17:48:23 +0100, Laurenz Albe wrote:

> As a test case, I created a table with 10000 rows, each of which
> had an array of 10000 uuids. The table resided in shared buffers.

Can you share exactly script used to create a table?

best regards,

Ranier Vilela

From: Alena Rybakina
Date: 22 February, 21:50:03
Subject: Re: Optimize planner memory consumption for huge arrays

From: Thomas Munro
Date: 22 February, 22:42:56
Subject: Re: Unlinking Parallel Hash Join inner batch files sooner