Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Thu, 31 Aug 2006 11:36:11 +1200
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
- References:
- performance problems.
- From: Matthew Sullivan
- performance problems.
- Prev by Date: Re: performance problems.
- Next by Date: Re: performance problems.
- Previous by thread: Re: performance problems.
- Next by thread: High concurrency OLTP database performance tuning
- Indexes: