Re: performance problems. - Mailing list pgsql-performance

From Mark Kirkwood
Subject Re: performance problems.
Date
Msg-id 44F620EB.6020206@paradise.net.nz
Whole thread Raw
In response to performance problems.  (Matthew Sullivan <matthew@sorbs.net>)
List pgsql-performance
Matthew Sullivan wrote:

>
> The OS is FreeBSD 5.4-RELEASE-p14
> The PG Version is 8.1.3
>
> Solutions/tips greatly appreciated.
>

This won't help this particular query, but 6.1-RELEASE will possibly be
a better performer generally, in particular for your SMP system - e.g.
the vfs layer is no longer under the Giant lock in the 6.x series, so
parallel io should be much better!

Cheers

Mark

pgsql-performance by date:

Previous
From: Matthew Sullivan
Date:
Subject: Re: performance problems.
Next
From: Dave Cramer
Date:
Subject: Re: performance problems.