On Sat, Apr 3, 2021 at 7:08 PM aditya desai <admad123@xxxxxxxxx> 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
