Re: performance problems.

From: Mark Kirkwood <markir(at)paradise(dot)net(dot)nz>
To: Matthew Sullivan <matthew(at)sorbs(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: performance problems.
Date: 2006-08-30 23:36:11
Message-ID: 44F620EB.6020206@paradise.net.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Dave Cramer 2006-08-30 23:48:12 Re: performance problems.
Previous Message Matthew Sullivan 2006-08-30 22:17:46 Re: performance problems.