Re: [PERFORM] quad or dual core Intel CPUs

2007-02-14 Thread Kenji Morishige
Thanks Claus thats good news! I'm having a reputable vendor build the box and test it for me before delivering. The bottom line of your message, did you mean 'should be not a problem'? I wonder what the main reason for your improvement, your ram was increased by a factor of 2, but 4 way

[PERFORM] quad or dual core Intel CPUs

2007-02-13 Thread Kenji Morishige
I am about to pull the trigger on a new machine after analyzing some discussions I posted here last year. I've been trying to spec out a reliable and powerfull enough machine where I won't have to replace it for some time. Currently I've been using a dual Xeon 3.06ghz with 4GB of ram and

Re: [PERFORM] most bang for buck with ~ $20,000

2006-08-18 Thread Kenji Morishige
Regarding the DL585 etc boxes from HP, they seem to require external JBOD or SCSI/SAS enclosures. Does anyone have any particular preference on how these units should be configured or speced? I'm guessing I'll use the onboard SCSI RAID 1 with the onboard drives for the OS, but will need 2

Re: [PERFORM] most bang for buck with ~ $20,000

2006-08-18 Thread Kenji Morishige
expensive). Best regards, Arjen van der Meijden On 8-8-2006 22:43, Kenji Morishige wrote: I've asked for some help here a few months ago and got some really helpfull answers regarding RAID controllers and server configuration. Up until recently I've been running PostgreSQL on a two year old

Re: [PERFORM] most bang for buck with ~ $20,000

2006-08-18 Thread Kenji Morishige
, Arjen On 18-8-2006 21:07, Kenji Morishige wrote: Thanks Arjen, I have unlimited rack space if I really need it. Is serial/SAS really the better route to go than SCSI these days? I'm so used to ordering SCSI that I've been out of the loop with new disk enclosures and disk tech. I been

Re: [PERFORM] most bang for buck with ~ $20,000

2006-08-09 Thread Kenji Morishige
-8-2006 22:43, Kenji Morishige wrote: I've asked for some help here a few months ago and got some really helpfull answers regarding RAID controllers and server configuration. Up until recently I've been running PostgreSQL on a two year old Dual Xeon 3.06Ghz machine with a single channel RAID

[PERFORM] most bang for buck with ~ $20,000

2006-08-08 Thread Kenji Morishige
I've asked for some help here a few months ago and got some really helpfull answers regarding RAID controllers and server configuration. Up until recently I've been running PostgreSQL on a two year old Dual Xeon 3.06Ghz machine with a single channel RAID controller (previously Adaptec 2200S, but

Re: [PERFORM] most bang for buck with ~ $20,000

2006-08-08 Thread Kenji Morishige
The 1+0 on the WAL is better than on PGDATA? I guess I'm confused about the write sequence of the data. I will research more, thank you! -Kenji On Tue, Aug 08, 2006 at 04:59:09PM -0500, Thomas F. O'Connell wrote: On Aug 8, 2006, at 4:49 PM, Joshua D. Drake wrote: I am considering a setup

Re: [PERFORM] most bang for buck with ~ $20,000

2006-08-08 Thread Kenji Morishige
Great info, which vendor were you looking at for these Opterons? I am goign to be purchasing 2 of these. :) I do need 24/7 reliability. On Tue, Aug 08, 2006 at 05:08:29PM -0500, Scott Marlowe wrote: On Tue, 2006-08-08 at 15:43, Kenji Morishige wrote: I've asked for some help here a few months

Re: [PERFORM] suggested RAID controller for FreeBSD 6.1 + PostgreSQL 8.1

2006-07-06 Thread Kenji Morishige
On Thu, Jul 06, 2006 at 12:52:09PM +1200, Mark Kirkwood wrote: Kenji Morishige wrote: I am currently running FreeBSD 4.11 (due to IT requirements for now) and Adaptec's 2200S RAID controller running in RAID5. I was advised in the past that the 2200S is actually a poor performing controller

[PERFORM] utilizing multiple disks for i/o performance

2006-05-19 Thread Kenji Morishige
Where can I find any documentation to partition the tablespace disk files onto different physical arrays for improved performance? -Kenji ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ?

[PERFORM] optimizing db for small table with tons of updates

2006-04-03 Thread Kenji Morishige
I am using postgresql to be the central database for a variety of tools for our testing infrastructure. We have web tools and CLI tools that require access to machine configuration and other states for automation. We have one tool that uses a table that looks like this: systest_live=# \d cuty

Re: [PERFORM] optimizing db for small table with tons of updates

2006-04-03 Thread Kenji Morishige
without it prompting me. Is it possible? -Kenji On Mon, Apr 03, 2006 at 02:39:10PM -0400, Tom Lane wrote: Kenji Morishige [EMAIL PROTECTED] writes: Various users run a tool that updates this table to determine if the particular resource is available or not. Within a course of a few days

Re: [PERFORM] optimizing db for small table with tons of updates

2006-04-03 Thread Kenji Morishige
Sweet! Thanks. -Kenji On Mon, Apr 03, 2006 at 03:03:54PM -0400, Alvaro Herrera wrote: Kenji Morishige wrote: I've been stumped as to how to call psql from the command line without it prompting me for a password. Is there a enviornoment variable I can specify for the password

Re: [PERFORM] optimizing db for small table with tons of updates

2006-04-03 Thread Kenji Morishige
: Alvaro Herrera [EMAIL PROTECTED] writes: Kenji Morishige wrote: I've been stumped as to how to call psql from the command line without it prompting me for a password. Is there a enviornoment variable I can specify for the password or something I can place in .pgsql? I could write a perl

[PERFORM] Best OS Configuration for Dual Xeon w/4GB Adaptec RAID 2200S

2006-03-17 Thread Kenji Morishige
About a year ago we decided to migrate our central database that powers various intranet tools from MySQL to PostgreSQL. We have about 130 tables and about 10GB of data that stores various status information for a variety of services for our intranet. We generally have somewhere between 150-200

Re: [PERFORM] Best OS Configuration for Dual Xeon w/4GB Adaptec RAID 2200S

2006-03-17 Thread Kenji Morishige
Thanks guys, I'm studying each of your responses and am going to start to experiement. Unfortunately, I don't have another box with similar specs to do a perfect experiment with, but I think I'm going to go ahead and open a service window to ungrade the box to FBSD6.0 and apply some other