Re: [PERFORM] Bad plan choice nestloop vs. hashjoin

2010-01-18 Thread Kenneth Marshall
On Mon, Jan 18, 2010 at 12:13:24PM -0500, Tom Lane wrote: > Kenneth Marshall writes: > > We have just upgraded our monitoring server software and > > now the following query for graphing the data performs > > abysmally with the default settings. Here is the results > > of the EXPLAIN ANALYZE run w

Re: [PERFORM] Bad plan choice nestloop vs. hashjoin

2010-01-18 Thread Tom Lane
Kenneth Marshall writes: > We have just upgraded our monitoring server software and > now the following query for graphing the data performs > abysmally with the default settings. Here is the results > of the EXPLAIN ANALYZE run with nestloops enabled: I poked at this a bit more and now think I s

Re: [PERFORM] Bad plan choice nestloop vs. hashjoin

2010-01-15 Thread Tom Lane
Kenneth Marshall writes: > We have just upgraded our monitoring server software and > now the following query for graphing the data performs > abysmally with the default settings. Here is the results > of the EXPLAIN ANALYZE run with nestloops enabled: That plan seems a bit wacko --- I don't see

Re: [PERFORM] Bad plan choice nestloop vs. hashjoin

2010-01-15 Thread Kenneth Marshall
On Fri, Jan 15, 2010 at 04:58:57PM -0600, Kevin Grittner wrote: > Kenneth Marshall wrote: > > > with the default settings > > Do you mean you haven't changed any settings in your postgresql.conf > file from their defaults? > > -Kevin > Sorry, here are the differences from the default: max_

Re: [PERFORM] Bad plan choice nestloop vs. hashjoin

2010-01-15 Thread Kevin Grittner
Kenneth Marshall wrote: > with the default settings Do you mean you haven't changed any settings in your postgresql.conf file from their defaults? -Kevin -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresq