Re: [PERFORM] Interpreting vmstat

[Thom Dyson]

Well,

Since I haven't seen any other responds, I'll offer a bit of advice and let
others correct me. :)

Your shared buffers may be too big (?).  It is much larger than the guide
on varlena.com recommends.  All I can suggest is trying some experiments
with halving/doubling the numbers to see which way performance goes.  Also,
if you are counting on cache to improve performance, then the db has to be
loaded into cache the first time. So, are subsequent re-queries faster?

Thom Dyson
Director of Information Services
Sybex, Inc.



[EMAIL PROTECTED] wrote on 05/18/2004 11:12:14 AM:

 Hello,
 (note best viewed in fixed-width font)

 I'm still trying to find where my performance bottle neck is...
 I have 4G ram, PG 7.3.4
 shared_buffers = 75000
 effective_cache_size = 75000



---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match

Re: [PERFORM] best arrangement of 3 disks for (insert) performance - Dell

[Thom Dyson]

The Dell PERC controllers have a very strong reputation for terrible
performance.  If you search the archives of the Dell Linux Power Edge list
(dell.com/linux), you will find many, many people who get better
performance from software RAID, rather than the hw RAID on the PERC.
Having said that, the 3/SC might be one of the better PERC controllers.  I
would spend and hour or two and benchmark hw vs. sw before I committed to
either one.

Thom Dyson
Director of Information Services
Sybex, Inc.

On 9/12/2003 9:55:40 AM, Richard Jones [EMAIL PROTECTED] wrote:
 The machine is coming from dell, and i have the option of a
 PERC 3/SC RAID Controller (32MB)
 or software raid.

 does anyone have any experience of this controller?
 its an additional £345 for this controller, i'd be interested to know
what
 people think - my other option is to buy the raid controller separately,
 which appeals to me but i wouldnt know what to look for in a raid
 controller.

 that raid controller review site sounds like a good idea :)

 Richard.



---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster