Re: [PERFORM] Nested loop and simple join query - slow after upgrade to 9.2

Em 25-01-2013 16:29, Jeff Janes escreveu: On Fri, Jan 25, 2013 at 7:34 AM, alexandre - aldeia digital wrote: Hi, Last weekend, we upgrade a PG from 8.4 to 9.2 version (full pg_dump/restore/vacuum/analyze). After this, some simple join querys became very slow, maybe because the use of nested lo

Re: [PERFORM] Nested loop and simple join query - slow after upgrade to 9.2

On Fri, Jan 25, 2013 at 7:34 AM, alexandre - aldeia digital wrote: > Hi, > > Last weekend, we upgrade a PG from 8.4 to 9.2 version (full > pg_dump/restore/vacuum/analyze). After this, some simple join querys > became very slow, maybe because the use of nested loops. Bellow, an example > with neste

[PERFORM] Nested loop and simple join query - slow after upgrade to 9.2

Hi, Last weekend, we upgrade a PG from 8.4 to 9.2 version (full pg_dump/restore/vacuum/analyze). After this, some simple join querys became very slow, maybe because the use of nested loops. Bellow, an example with nestedloop on and off: base=# analyze verbose pc13t; INFO: analyzing "public.p