Re: Performance problem with a table with 38928077 record

From: Shaun Thomas <sthomas(at)peak6(dot)com>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Giovanni Mancuso <gmancuso(at)babel(dot)it>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Performance problem with a table with 38928077 record
Date: 2011-10-27 20:31:00
Message-ID: 4EA9BF84.3000203@peak6.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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(at)peak6(dot)com

______________________________________________

See http://www.peak6.com/email-disclaimer/ for terms and conditions related to this email

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Nicholson, Brad (Toronto, ON, CA) 2011-10-27 20:45:11 Re: backups blocking everything
Previous Message Robert Haas 2011-10-27 19:13:11 Re: Performance problem with a table with 38928077 record