On Thu, May 11, 2006 at 12:09:56PM -0500, Jim C. Nasby wrote:
> Unfortunately, I suspect some of these were grabbed after the process
> had already moved past whatever was holding it in sblock.
>
> Here's the traces that we captured...
>
> Got 2 of these:
> #0 0x000000080135bd2c in recvfrom () from /lib/libc.so.6
> #1 0x00000000004f9898 in secure_read (port=0x834800, ptr=0x7cebe0, len=8192) at be-secure.c:320
This is an idle backend waiting for the user.
> #0 0x000000080137638c in sendto () from /lib/libc.so.6
> #1 0x0000000000535e67 in pgstat_report_tabstat () at pgstat.c:846
This definitly the statistics collector, which is something that was
speculated upthread. Do you get a lot of these?
> I suspect the rest of these probably happened after the sblock state had
> cleared, but here they are anyway in case I'm wrong. Also, I removed the
> 'incriminating evidence' from the query strings; there wasn't anything
> unusual about those queries, so I don't think it should matter.
The rest look like backends going through normal query functions...
There was one waiting for a lock but that's unlikely to be
significant...
Hope this helps,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.