Jozsef Szalay escribió: > I don't know why ANALYZE would have any effect on a sequential scan of a > table but it does appear to impact both performance and memory usage > significantly. It doesn't. What it does is provide the query optimizer with the information that it needs to know that the table contains many different values, which makes it turn the initial hashed aggregation into a sort plus group aggregation. This allows the aggregation to use less memory. As an exercise, see an EXPLAIN of the query, both before and after the analyze, and study the difference. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
