Re: [GENERAL] I feel the need for speed. What am I doing wrong?

From: Doug McNaught <doug(at)mcnaught(dot)org>
To: "Dann Corbit" <DCorbit(at)connx(dot)com>
Cc: "johnnnnnn" <john(at)phaedrusdeinus(dot)org>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [GENERAL] I feel the need for speed. What am I doing wrong?
Date: 2003-01-07 23:43:50
Message-ID: m3ptr8y18p.fsf@varsoon.wireboard.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Dann Corbit" <DCorbit(at)connx(dot)com> writes:

> No analyze for 7.1.3.
> Just ran vacuum a few minutes before the query. No boost at all.

VACUUM or VACUUM ANALYZE? Standalone ANALYZE was not in 7.1 but
VACUUM ANALYZE does what you need to do...

-Doug

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jean-Luc Lachance 2003-01-07 23:59:45 Re: [HACKERS] I feel the need for speed. What am I doing
Previous Message Steve Crawford 2003-01-07 23:36:10 Re: [HACKERS] Have people taken a look at pgdiff yet?