Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] I feel the need for speed. What am I doing wrong? - Mailing list pgsql-hackers

From Doug McNaught
Subject Re: [GENERAL] I feel the need for speed. What am I doing wrong?
Date
Msg-id m3ptr8y18p.fsf@varsoon.wireboard.com
Whole thread Raw
In response to Re: [GENERAL] I feel the need for speed. What am I doing wrong?  ("Dann Corbit" <DCorbit@connx.com>)
List pgsql-hackers
Tree view 
"Dann Corbit" <DCorbit@connx.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

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: MOVE LAST: why?
Next
From: Tom Lane
Date:
Subject: Re: MOVE LAST: why?