Re: [PERFORM] query slow; strace output worrisome

2010-04-07 Thread Robert Haas
On Tue, Apr 6, 2010 at 10:32 PM, Craig Ringer wrote: > On 7/04/2010 12:24 AM, Brian Cox wrote: >> >> On 04/06/2010 01:18 AM, Craig Ringer [cr...@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: >> >>

Re: [PERFORM] query slow; strace output worrisome

2010-04-06 Thread Craig Ringer
On 7/04/2010 12:24 AM, Brian Cox wrote: On 04/06/2010 01:18 AM, Craig Ringer [cr...@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

Re: [PERFORM] query slow; strace output worrisome

2010-04-06 Thread Brian Cox
On 04/06/2010 01:18 AM, Craig Ringer [cr...@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

Re: [PERFORM] query slow; strace output worrisome

2010-04-05 Thread Craig Ringer
Brian Cox wrote: > On 04/05/2010 09:53 PM, Craig Ringer [cr...@postnewspapers.com.au] wrote: >> Anything in `dmesg' (command) or /var/log/syslog ? > nothing out of the ordinary. Brian I'm wondering if the issue is with strace rather than Pg. That is to say, that strace is trying to print: creat(

Re: [PERFORM] query slow; strace output worrisome

2010-04-05 Thread Brian Cox
On 04/05/2010 09:53 PM, Craig Ringer [cr...@postnewspapers.com.au] wrote: Anything in `dmesg' (command) or /var/log/syslog ? nothing out of the ordinary. Brian -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgres

Re: [PERFORM] query slow; strace output worrisome

2010-04-05 Thread Craig Ringer
On 6/04/2010 9:01 AM, Brian Cox wrote: The SELECT show below has been running for 30+mins and the strace output is alarming: [r...@dione ~]# strace -p 10083 Process 10083 attached - interrupt to quit creat(umovestr: Input/output error 0x2, 0377) = 1025220608 creat(umovestr: Input/output