Re: Large arrays give long lag on server side before command executes

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: David Helgason <david(at)uti(dot)is>
Cc: postgresql General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Large arrays give long lag on server side before command executes
Date: 2004-09-24 15:50:44
Message-ID: 22931.1096041044@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

David Helgason <david(at)uti(dot)is> writes:
> Here's the gmon.out file that was created after a short run of
> postgres, and the output of 'gprof /usr/local/postgres/bin/postgres
> gmon.out'. The data didn't make much sense to me though.

I think you got a gmon.out from the wrong backend run. This run looks
like it didn't do much except start and exit --- it certainly didn't run
for any five seconds, which is what you were saying the problem case
took.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ed L. 2004-09-24 16:16:56 8.0 logging question
Previous Message David Helgason 2004-09-24 15:39:24 Re: Large arrays give long lag on server side before command executes