On Sat, Apr 3, 2021 at 7:08 PM aditya desai <admad...@gmail.com> wrote: > > Hi, > We migrated our Oracle Databases to PostgreSQL. One of the simple select > query that takes 4 ms on Oracle is taking around 200 ms on PostgreSQL. Could > you please advise. Please find query and query plans below. Gather cost seems > high. Will increasing max_parallel_worker_per_gather help?
No it doesn't. For small tables, parallelism might not help since it doesn't come for free. Try setting max_parallel_worker_per_gather to 0 i.e. without parallel query. With Regards, Bharath Rupireddy. EnterpriseDB: http://www.enterprisedb.com
