From: Brian Cox <brian.cox@ca.com>
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
Date: Tue, 06 Apr 2010 09:24:47 -0700
Message-ID: <4BBB604F.6060005@ca.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: brian.cox@ca.com, craig@postnewspapers.com.au
Subject: Re: query slow; strace output worrisome
In-Reply-To: <4BBB604F.6060005@ca.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox