On Sat, Nov 01, 2003 at 10:29:34PM +0100, Manfred Spraul wrote:
> Mark Wong wrote:
> >Yeah, my dbt2 applications are multithreaded.
> Do you need SIGPIPE delivery in your app? If no, could you try what
> happens if you apply the attached patch to postgres, and perform the
> signal(SIGPIPE, SIG_IGN);
> once in your dbt2 app?
Wow, that patch made a pretty big difference:
- metric 1605.51
So no one has to look for older mail before I applied that patch:
- metric 1427.24
Looks like about a 12% improvement in the overall metric. The first thing I
noticed is that do_sigaction in the kernel profile almost disappeared. The
top few functions in the database profile doesn't appear to have changed much.
In response to
pgsql-hackers by date
|Next:||From: Michael Owens||Date: 2003-11-02 04:54:05|
|Subject: Getting number of matched records from query|
|Previous:||From: Christopher Kings-Lynne||Date: 2003-11-02 03:03:34|
|Subject: Re: OSDL DBT-2 w/ PostgreSQL 7.3.4 and 7.4beta5|