Re: How to solve my slow disk i/o throughput during index scan
On 11/7/2024 21:59, FREYBURGER Simon (SNCF VOYAGEURS / DIRECTION GENERALE TGV / DM RMP YIELD MANAGEMENT) wrote: Hello, and thank you again for your example ! Sorry for my late answer, I was working on a patch for our requests. I am though not completely understanding what is happening. Here is
Re: How to solve my slow disk i/o throughput during index scan
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 pr
Re: How to solve my slow disk i/o throughput during index scan
On Thursday, July 11, 2024, FREYBURGER Simon (SNCF VOYAGEURS / DIRECTION GENERALE TGV / DM RMP YIELD MANAGEMENT) 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 l
RE: How to solve my slow disk i/o throughput during index scan
2024-07-11
Thread
FREYBURGER Simon (SNCF VOYAGEURS / DIRECTION GENERALE TGV / DM RMP YIELD MANAGEMENT)
E public."F_TDOJ_SC_HIST_2" ADD CONSTRAINT "F_TDOJ_SC_HIST_2_ID_OD_fkey" FOREIGN KEY ("ID_OD") REFERENCES public."D_OD"("ID_OD"); ALTER TABLE public."F_TDOJ_SC_HIST_2" ADD CONSTRAINT "F_TDOJ_SC_HIST_2_ID_TRAIN_fkey" FOREIGN KE
RE: How to solve my slow disk i/o throughput during index scan
2024-07-11
Thread
FREYBURGER Simon (SNCF VOYAGEURS / DIRECTION GENERALE TGV / DM RMP YIELD MANAGEMENT)
) ; pgsql-performance@lists.postgresql.org; Peter Geoghegan Objet : Re: How to solve my slow disk i/o throughput during index scan On 7/4/24 22: 23, FREYBURGER Simon (SNCF VOYAGEURS / DIRECTION GENERALE TGV / DM RMP YIELD MANAGEMENT) wrote: > Hello, > > Thank you, splitting in “
Re: How to solve my slow disk i/o throughput during index scan
On 7/4/24 22:23, FREYBURGER Simon (SNCF VOYAGEURS / DIRECTION GENERALE TGV / DM RMP YIELD MANAGEMENT) wrote: Hello, Thank you, splitting in “OR” query definitely enables bitmap heap scans, and thus parallelized read to disk 😃! I though did not understand your second point, what is parallel app
RE: How to solve my slow disk i/o throughput during index scan
2024-07-04
Thread
FREYBURGER Simon (SNCF VOYAGEURS / DIRECTION GENERALE TGV / DM RMP YIELD MANAGEMENT)
À : FREYBURGER Simon (SNCF VOYAGEURS / DIRECTION GENERALE TGV / DM RMP YIELD MANAGEMENT) ; pgsql-performance@lists.postgresql.org; Peter Geoghegan Objet : Re: How to solve my slow disk i/o throughput during index scan On 4/7/2024 20: 25, FREYBURGER Simon (SNCF VOYAGEURS / DIRECTION GENERALE TGV
Re: How to solve my slow disk i/o throughput during index scan
On 4/7/2024 20:25, FREYBURGER Simon (SNCF VOYAGEURS / DIRECTION GENERALE TGV / DM RMP YIELD MANAGEMENT) wrote: *My question is : what can I change to get a better index reading speed ?* What I already tried : * Setting random_page_cost to prohibitive value (1000) to force a bitmap hea
