Message-ID: <4BBB604F.6060005@ca.com>
Date: Tue, 06 Apr 2010 09:24:47 -0700
From: Brian Cox <brian.cox@ca.com>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US;
	rv:1.9.1.5) Gecko/20091204 Lightning/1.0b1 Thunderbird/3.0
MIME-Version: 1.0
To: "Craig Ringer [craig@postnewspapers.com.au]" <craig@postnewspapers.com.au>
CC: "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Subject: Re: query slow; strace output worrisome
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

On 04/06/2010 01:18 AM, Craig Ringer [craig@postnewspapers.com.au] wrote:
> I'm wondering if the issue is with strace rather than Pg. That is to
> say, that strace is trying to print:
Thanks, Craig: I do think that this is a strace issue.

> As for what Pg is doing: creat() returns -1 on error and a file
> descriptor otherwise, so the return value appears to indicate success.
> I'm kind of wondering what the Pg backend is actually _doing_ though -
> if it was using sort temp files you'd expect
> open()/write()/read()/close() not just creat() calls.
My quesiton exactly: what is the backend doing calling creat() over and 
over again? Note that this query does complete -- in 30-40 mins.

Brian