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

Re: [SQL] 7.3 analyze & vacuum analyze problem

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: 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-04-30 18:48:18
Message-ID: 200304301148.18322.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-performancepgsql-sql
Achilleus,

> 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.

-- 
-Josh Berkus
 Aglio Database Solutions
 San Francisco


In response to

Responses

pgsql-performance by date

Next:From: Achilleus MantziosDate: 2003-04-30 20:57:31
Subject: 7.3 analyze & vacuum analyze problem
Previous:From: Josh BerkusDate: 2003-04-30 17:33:17
Subject: Re: Like search performance.

pgsql-sql by date

Next:From: Josh BerkusDate: 2003-04-30 20:41:35
Subject: Re: EASY QUESTION!!
Previous:From: Rajesh Kumar MallahDate: 2003-04-30 18:10:15
Subject: Re: differences between oracle,pgsql,sybase

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