Re: Very slow left outer join - Mailing list pgsql-performance

From Tyrrill, Ed
Subject Re: Very slow left outer join
Date
Msg-id A23190A408F7094FAF446C1538222F7603F9811F@avaexch01.avamar.com
Whole thread Raw
In response to Re: Very slow left outer join  (Michael Glaesemann <grzm@seespotcode.net>)
List pgsql-performance
Michael Glaesemann <grzm@seespotcode.net> writes:
> Off the cuff, when was the last time you vacuumed or ran ANALYZE?
> Your row estimates look off by a couple orders of magnitude. With up-
> to-date statistics the planner might do a better job.
>
> As for any other improvements, I'll leave that to those that know
> more than I. :)
>
> Michael Glaesemann
> grzm seespotcode net

The script that imports data into these tables runs a vacuum analyze at
the end so there has been no new data added to the tables since the last
time vacuum analyze was run.


pgsql-performance by date:

Previous
From: mark@mark.mielke.cc
Date:
Subject: Re: setting up raid10 with more than 4 drives
Next
From: "Tyrrill, Ed"
Date:
Subject: Re: Very slow left outer join