Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

Next:From: Dave CramerDate: 2006-08-30 23:48:12
Subject: Re: performance problems.
Previous:From: Matthew SullivanDate: 2006-08-30 22:17:46
Subject: Re: performance problems.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group