Postgres Pro
Downloads
Home   >   mailing lists

Re: query takes 65 times longer if I add 1 column (explain attached) - Mailing list pgsql-general

From Dan Weber
Subject Re: query takes 65 times longer if I add 1 column (explain attached)
Date
Msg-id 5dfa06e10611021222w22655b4yfca8290f8b5a6a72@mail.gmail.com
Whole thread Raw
In response to Re: query takes 65 times longer if I add 1 column (explain attached)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view

What have you got work_mem set to?

The default, 1024.
 
The fact that the estimates diverge so far from reality can no doubt be
blamed on the horridly bad rowcount estimates: 3 rows estimated vs
179 actual for table_one, and 128592 estimated vs 4202 actual for
table_two.  Have you ANALYZEd these tables lately?

Nope.  Doing that caused the first operation to respond very quickly.
(And the second as well, of course.)

Thanks for the assistance.


pgsql-general by date:

Previous
From: Reece Hart
Date:
Subject: Re: DELETE performance issues
Next
From: Ron Johnson
Date:
Subject: Re: Is there anyway to...