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

Re: [SQL] 7.3 analyze & vacuum analyze problem

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: <josh(at)agliodbs(dot)com>,"Achilleus Mantzios" <achill(at)matrix(dot)gatewaynet(dot)com>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: [SQL] 7.3 analyze & vacuum analyze problem
Date: 2003-05-01 01:51:41
Message-ID: 0a1301c30f84$39a2dbe0$6500a8c0@fhp.internal (view raw or flat)
Thread:
Lists: pgsql-performancepgsql-sql
> > I am afraid it is not so simple.
> > What i (unsuccessfully) implied is that
> > dynacom=# VACUUM ANALYZE status ;
> > VACUUM
> > dynacom=# ANALYZE status ;
> > ANALYZE
> > dynacom=#
>
> You're right, that is mysterious.   If you don't get a response from one
of
> the major developers on this forum, I suggest that you post those EXPLAIN
> results to PGSQL-BUGS.

Is it mysterious?  The ANALYZE histogram algorithm does do random sampling
doesn't it?

Chris


In response to

pgsql-performance by date

Next:From: Rajesh Kumar MallahDate: 2003-05-01 14:59:16
Subject: Re: profiling plpgsql functions..
Previous:From: Tom LaneDate: 2003-05-01 00:10:38
Subject: Re: [SQL] 7.3 analyze & vacuum analyze problem

pgsql-sql by date

Next:From: Tom LaneDate: 2003-05-01 01:53:33
Subject: Re: PERFORM / FOUND, what's up?
Previous:From: Tom LaneDate: 2003-05-01 00:10:38
Subject: Re: [SQL] 7.3 analyze & vacuum analyze problem

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