On 10/27/2011 02:13 PM, Robert Haas wrote:
If I had to guess, I'd bet that the second one is trying to spool the resultset in memory someplace and that's driving the machine into swap.
That would be my guess too. SELECT * on a 40-million row table is a *lot* different than getting the count, which throws away the rows once it verifies they're valid.
-- Shaun Thomas OptionsHouse | 141 W. Jackson Blvd. | Suite 800 | Chicago IL, 60604 312-676-8870 sthomas@xxxxxxxxx ______________________________________________ See http://www.peak6.com/email-disclaimer/ for terms and conditions related to this email -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
