Postgres Pro
Downloads
Home   >   mailing lists

Re: How to solve my slow disk i/o throughput during index scan - Mailing list pgsql-performance

From David G. Johnston
Subject Re: How to solve my slow disk i/o throughput during index scan
Date
Msg-id CAKFQuwYGDsejBZnS1pPvod4aGywuijAmK8iUAH3eOkH97k5mzA@mail.gmail.com
Whole thread Raw
In response to RE: How to solve my slow disk i/o throughput during index scan  ("FREYBURGER Simon (SNCF VOYAGEURS / DIRECTION GENERALE TGV / DM RMP YIELD MANAGEMENT)" <simon.freyburger@sncf.fr>)
List pgsql-performance
Tree view
On Thursday, July 11, 2024, FREYBURGER Simon (SNCF VOYAGEURS / DIRECTION GENERALE TGV / DM RMP YIELD MANAGEMENT) <simon.freyburger@sncf.fr> wrote:

Also, It might not be related, but I have suspiciously similar slow reads when I am inserting in database, could it be related ?
I’m using a 3 steps process to insert my lines in the table :

  • COPY into a temporary table
  • DELETE FROM on the perimeter I will be inserting into
  • INSERT … INTO mytable SELECT … FROM temporarytable ON CONFLICT DO NOTHING

 

Is it possible to parallelize the scans during the modify step ?



This tells you when parallelism is used:


David J.

pgsql-performance by date:

Previous
From: "FREYBURGER Simon (SNCF VOYAGEURS / DIRECTION GENERALE TGV / DM RMP YIELD MANAGEMENT)"
Date:
Subject: RE: How to solve my slow disk i/o throughput during index scan
Next
From: Andrei Lepikhov
Date:
Subject: Re: How to solve my slow disk i/o throughput during index scan