re: Speeding up COPY TO for uuids and arrays

From: Ranier Vilela <ranier(dot)vf(at)gmail(dot)com>
To: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Cc: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, Andres Freund <andres(at)anarazel(dot)de>, Michael Paquier <michael(at)paquier(dot)xyz>
Subject: re: Speeding up COPY TO for uuids and arrays
Date: 2024-02-22 19:42:37
Message-ID: CAEudQAorCYpN727YEXpMs9kzJaa44f45cNo1sovZ_MfQJ1R1vw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Munro 2024-02-22 19:42:56 Re: Unlinking Parallel Hash Join inner batch files sooner
Previous Message Alena Rybakina 2024-02-22 18:50:03 Re: Optimize planner memory consumption for huge arrays