Skip site navigation (1) Skip section navigation (2)

Re: EXPLAIN ANALYZE output

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: David Rysdam <drysdam(at)ll(dot)mit(dot)edu>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: EXPLAIN ANALYZE output
Date: 2005-12-27 20:56:21
Message-ID: 43B1AA75.7030702@commandprompt.com (view raw or flat)
Thread:
Lists: pgsql-general
> There's been plenty of vacuuming and analyzing on these tables, so 
> outdated stats are not the answer.

No but it could be incorrect stats do to the statistics parameter not 
being set high enough.

Joshua D. Drake

> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
> 
>               http://archives.postgresql.org


In response to

pgsql-general by date

Next:From: Jim C. NasbyDate: 2005-12-27 21:12:38
Subject: Re: [GENERAL] Running with fsync=off
Previous:From: David RysdamDate: 2005-12-27 18:58:46
Subject: EXPLAIN ANALYZE output

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group