public inbox for [email protected]
help / color / mirror / Atom feedFrom: Andrei Lepikhov <[email protected]>
To: FREYBURGER Simon (SNCF VOYAGEURS / DIRECTION GENERALE TGV / DM RMP YIELD MANAGEMENT) <[email protected]>
To: [email protected] <[email protected]>
To: Peter Geoghegan <[email protected]>
Subject: Re: How to solve my slow disk i/o throughput during index scan
Date: Thu, 11 Jul 2024 22:22:09 +0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <MR1P264MB347367D076E53D34C6C191549DA52@MR1P264MB3473.FRAP264.PROD.OUTLOOK.COM>
References: <MR1P264MB34732DC3639E0B6656B43DFD9DDE2@MR1P264MB3473.FRAP264.PROD.OUTLOOK.COM>
<[email protected]>
<MR1P264MB34739538259E7FAF3A9DE4249DDE2@MR1P264MB3473.FRAP264.PROD.OUTLOOK.COM>
<[email protected]>
<MR1P264MB3473775C1D732E9501EF98D99DA52@MR1P264MB3473.FRAP264.PROD.OUTLOOK.COM>
<MR1P264MB347367D076E53D34C6C191549DA52@MR1P264MB3473.FRAP264.PROD.OUTLOOK.COM>
On 11/7/2024 22:09, FREYBURGER Simon (SNCF VOYAGEURS / DIRECTION
GENERALE TGV / DM RMP YIELD MANAGEMENT) wrote:
> Is it possible to parallelize the scans during the modify step ?
Temporary tables can't be used inside a query with parallel workers
involved, because such table is local for single process.
What about your question - I'm not sure without whole bunch of data. But
maximum speedup you can get by disabling as much constraints as possible
- ideally, fill each partition individually with no constraints and
indexes at all before uniting them into one partitioned table.
--
regards, Andrei Lepikhov
view thread (9+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected]
Subject: Re: How to solve my slow disk i/o throughput during index scan
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox