Re: Planner choosing nested loop in place of Hashjoin

On Tue, Mar 7, 2023 at 7:14 AM Praneel Devisetty wrote: > Hi, > > I have a query which is taking roughly 10mins to complete and the query > planner is choosing a nested loop. > > query and query plan with analyze,verbose,buffers > qsEn | explain.depesz.com

Huge Tables

Hello Guys Regarding a particular performance + architecture situation with postgres 12, I have a table with 300 millions rows and then I ask you, which basic approach like *parameters in postgres.conf*, suitable index type , partitions type, would you suggest me knowing that we have Queries usi

Re: INSERT statement going in IPC Wait_event

Hello Aditya, How many connections do you have on your PostgreSQL cluster? And, do your webserver and database service run on the same machine/VM? I would check system logs on the server on which PostgreSQL cluster run. Best regards. Samed YILDIRIM On Wed, 1 Mar 2023 at 22:40, aditya desai wr

Re: Planner choosing nested loop in place of Hashjoin

Hi Praneel, It is hard to propose a solution without seeing the actual query and knowing details of the tables. If I were you, I would try to increase statistics target for the columns used in joins. Default value is 100. You need to analyze those tables again after updating the statistics targets