Re: Quick Performance Poll - Mailing list pgsql-performance

From Jim C. Nasby
Subject Re: Quick Performance Poll
Date
Msg-id 20060420165532.GZ49405@pervasive.com
Whole thread Raw
In response to Re: Quick Performance Poll  ("Jim Buttafuoco" <jim@contactbda.com>)
List pgsql-performance
Interested in doing a case study for the website?

On Thu, Apr 20, 2006 at 09:36:25AM -0400, Jim Buttafuoco wrote:
>
> Simon,
>
> I have many databases over 1T with the largest being ~6T.  All of my databases store telecom data, such as call
detail
> records.  The access is very fast when looking for a small subset of the data.  For servers, I am using white box
intel
> XEON and P4 systems with SATA disks, 4G of memory.  SCSI is out of our price range, but if I had unlimited $ I would
go
> with SCSI /SCSI raid instead.
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

pgsql-performance by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: SELECT FOR UPDATE performance is bad
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Performance decrease