Re: [PERFORM] Do work_mem and shared buffers have 1g or 2g limit on 64 bit linux?

On 06/15/15 05:44, Kaijiang Chen wrote: I've checked the source codes in postgresql 9.2.4. In function static bool grow_memtuples(Tuplesortstate *state) the codes: /* * On a 64-bit machine, allowedMem could be high enough to get us into * trouble with MaxAllocSize, to

Re: [PERFORM] Slow query: Postgres chooses nested loop over hash join, whery by hash join is much faster, wrong number of rows estimated

On Thu, Jun 11, 2015 at 7:18 PM, Sasa Vilic wrote: > Hi, > > I have a query that takes ridiculously long to complete (over 500ms) but if > I disable nested loop it does it really fast (24.5ms) > > Here are links for > * first request (everything enabled): http://explain.depesz.com/s/Q1M > * second