Re: [PERFORM] Big number of connections

2016-04-01 Thread jarek
Hello! Dnia 2016-03-31, czw o godzinie 19:12 +, Igor Neyman pisze: > Take a look at PgBouncer. > It should solve your problems. Well, we don't have problems yet :), but we are looking for possible threats. I'll be happy to hear form users of big PostgreSQL installations, how many users do yo

Re: [PERFORM] Fast HashJoin only after a cluster/recreate table

2016-04-01 Thread David Rowley
On 1 April 2016 at 15:44, Alexandre de Arruda Paes wrote: > In the query below, the planner choose an extreme slow mergejoin(380 > seconds). 'Vacuum analyze' can't help. > Yeah, it appears that planner is estimating the WHERE clause on es09t quite badly, expecting just 1 row, but there's actuall

Re: [PERFORM] Fast HashJoin only after a cluster/recreate table

2016-04-01 Thread Alexandre de Arruda Paes
Hi David, Thanks for the explanations. But I don't undestand why when I recreate the table, the planner choose a best mode for sometime... >I wonder what the planner would do if you pulled out the join to ES08T. If that generates a better plan, then providing that es08tipdoc is the primary key of