At 13:40 10/31/2003, Neil Conway wrote:
On Fri, 2003-10-31 at 13:27, Allen Landsidel wrote:
> I had no idea analyze was playing such a big role in this sense.. I really
> thought that other than saving space, it wasn't doing much for tables that
> don't have indexes on the.

ANALYZE doesn't save any space at all -- VACUUM is probably what you're
thinking of.

Actually, I was thinking VACUUM ANALYZE.. which is what I ran after the COPY.. sorry for my lack of precision.

I've yet to run straight-up ANALYZE AFAIK.


---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?

Reply via email to