Re: Multiple COPY statements for one table vs one for ~half a billion records

2024-04-04 Thread Ron Johnson
On Thu, Apr 4, 2024 at 2:04 PM Carl L wrote: > Hi there, > > I have around half a billion records that are being generated from a back > end that are split into 80 threads (one per core) and I'm performing a copy > from memory ( from stdin binary) into Postgres from each of these threads - >

Multiple COPY statements for one table vs one for ~half a billion records

2024-04-04 Thread Carl L
Hi there, I have around half a billion records that are being generated from a back end that are split into 80 threads (one per core) and I'm performing a copy from memory ( from stdin binary) into Postgres from each of these threads - i.e. there are 80 COPY statements being generated for one