Re: Problema con indice

On Thu, Nov 18, 2004 at 11:48:01PM -0600, Jaime Casanova wrote:

> Hola,
> ok, empezamos con datos basicos, cuantos registros
> tiene tu tabla? cuantos registros devuelve la
> consulta? has hecho analyze recientemente en la tabla?

Hoy me toco una divertida: en una empresa tenian un guion de shell en cron
que ejecutaba

vacuumdb analyze <nombre-de-la-bd>

Y no hacia analyze, porque la sintaxis correcta es
vacuumdb -z <...>

Lo malo era que VACUUM funcionaba, vacuumdb no reclamaba que tenia un
argumento no valido, etc :-)

--
Alvaro Herrera (<alvherre[(at)]dcc(dot)uchile(dot)cl>)
Bob [Floyd] used to say that he was planning to get a Ph.D. by the "green
stamp method," namely by saving envelopes addressed to him as 'Dr. Floyd'.
After collecting 500 such letters, he mused, a university somewhere in
Arizona would probably grant him a degree. (Don Knuth)