[PERFORM] Query performance and understanding explain analzye

2005-01-19 Thread Benjamin Wragg
oin the time taken is reported as: -> Hash Join (cost=533.45..4548.30 rows=14028 width=582) (actual time=63.79..3826.16 rows=14028 loops=1) So does this mean that at that point 3826.16 milli seconds had past and if we take 414.43 from 3826.16 it shows that all the hash joins took about 3

Re: [PERFORM] Disk configuration

2005-01-19 Thread Benjamin Wragg
, 20 January 2005 2:53 AM To: Benjamin Wragg Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] Disk configuration The primary goal is to reduce the number of seeks a disk or array has to perform. Serial write throughput is much higher than random write throughput. If you are performing

[PERFORM] areca raid controller

2005-01-19 Thread Benjamin Wragg
Hi,   Has anyone had any experiance with any of the Areca SATA RAID controllers? I was looking at a 3ware one but it won't fit in the 2U case we have so the sales guy recommended these.   Cheers,   Benjamin Wragg -- No virus found in this outgoing message. Checked by AVG Anti-

[PERFORM] Disk configuration

2005-01-18 Thread Benjamin Wragg
, or will this create a bottle neck? Would a multi disk array be more appropriate?   Cheers,   Benjamin Wragg -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.7.0 - Release Date: 17/01/2005

Re: [PERFORM] which dual-CPU hardware/OS is fastest for PostgreSQL?

2005-01-14 Thread Benjamin Wragg
s RAID 10 and supports battery backed cache. Anyone had any experience with this? Any other particular controller that people recommend? From what I've been reading RAID 10 and battery backed cache sound like things I need. :) Thanks, Benjamin Wragg -Original Message- From: [EMAIL PROT