On Sun, 8 Feb 2004, Bruno BAGUETTE wrote:
> > On Fri, 6 Feb 2004, Bruno BAGUETTE wrote:
> >
> > > > In addition to what Tom said, the row estimates look suspiciously
> > > > default. You mention vacuuming, but do you ever analyze
> > > > the tables?
> > >
> > > I run VACUUM FULL ANALYZE with the p
> On Fri, 6 Feb 2004, Bruno BAGUETTE wrote:
>
> > > In addition to what Tom said, the row estimates look suspiciously
> > > default. You mention vacuuming, but do you ever analyze
> > > the tables?
> >
> > I run VACUUM FULL ANALYZE with the postgres user on all the
> > PostgreSQL
> > databases
On Sat, Feb 07, 2004 at 01:51:54AM -0500, Tom Lane wrote:
> Karl Denninger <[EMAIL PROTECTED]> writes:
> > akcs=> explain analyze select forum, (replied > (select lastview from forumlog
> > where forumlog.login='genesis' and forumlog.forum='General' and
> > number=post.number)) as newflag, * from
Josh Berkus <[EMAIL PROTECTED]> writes:
> Orion,
>> Here's one good example of 7.3 beating 7.4 soundly:
> Need an EXPLAIN ANALYZE, not just an EXPLAIN.
Indeed. Also, please try 7.4 with enable_hashagg turned off to see
what it does with a 7.3-style plan.
regards, tom lan
Karl Denninger <[EMAIL PROTECTED]> writes:
> akcs=> explain analyze select forum, (replied > (select lastview from forumlog where
> forumlog.login='genesis' and forumlog.forum='General' and number=post.number)) as
> newflag, * from post where forum = 'General' and toppost = 1 order by pinned desc
