Re: Parallel hints in PostgreSQL with consistent perfromance

2024-01-03 Thread mohini mane
On Thu, Jan 4, 2024 at 7:13 AM Jeff Janes wrote: > > >> *1st time query executed with PARALLEL DEGREE 2 * >> explain analyze select /*+* PARALLEL(A 2)* */ * from >> test_compare_all_col_src1 A; >> >> QUERY PLAN >> >> ---

Re: Slow GroupAggregate and Sort

2024-01-03 Thread Jeff Janes
On Mon, Jan 1, 2024 at 9:57 AM Darwin Correa wrote: > Hello, Happy New Year! I add my responses in blue. > > > > El Thu, 28 Dec 2023 13:06:18 -0500, *Jeff Janes > >* escribió > > I thought the point of sharding was to bring more CPU and RAM to bear than > can feasibly be obtained in one

Re: Parallel hints in PostgreSQL with consistent perfromance

2024-01-03 Thread Jeff Janes
> *1st time query executed with PARALLEL DEGREE 2 * > explain analyze select /*+* PARALLEL(A 2)* */ * from > test_compare_all_col_src1 A; > QUERY > PLAN > > -