Re: [PERFORM] PostgreSQL Configuration Tool for Dummies

2007-06-19 Thread Charles Sprickman
On Tue, 19 Jun 2007, Josh Berkus wrote: "What OS Are You Using", of course, needs to have Linux, Solaris, BSD, OSX and Windows. At some point, this tool will also need to generate for the user any shmem settings that they need to make on the OS. I also noticed that on FreeBSD (6.2) at least t

Re: [PERFORM] Best OS for Postgres 8.2

2007-05-08 Thread Charles Sprickman
On Tue, 8 May 2007, [EMAIL PROTECTED] wrote: one issue with journaling filesystems, if you journal the data as well as the metadata you end up with a very reliable setup, however it means that all your data needs to be written twice, oncce to the journal, and once to the final location. the wr

Re: [PERFORM] SCSI vs SATA

2007-04-06 Thread Charles Sprickman
On Fri, 6 Apr 2007, [EMAIL PROTECTED] wrote: On Fri, 6 Apr 2007, Scott Marlowe wrote: Based on experience I think that on average server drives are more reliable than consumer grade drives, and can take more punishment. this I am not sure about I think they should survey Tivo owners next t

Re: [PERFORM] Writting a "search engine" for a pgsql DB

2007-02-27 Thread Charles Sprickman
On Tue, 27 Feb 2007, Dave Page wrote: Magnus Hagander wrote: Just as a datapoint, we did try to use mnogosearch for the postgresql.org website+archives search, and it fell over completely. Indexing took way too long, and we had search times several thousand times longer than with tsearch2. Th

Re: [PERFORM] Writting a "search engine" for a pgsql DB

2007-02-26 Thread Charles Sprickman
On Mon, 26 Feb 2007, Madison Kelly wrote: Hi all, I'd really like to come up with a more intelligent search engine that doesn't take two minutes to return results. :) I know, in the end good indexes and underlying hardware will be important, but a sane as possible query structure helps to st

[PERFORM] recommended benchmarks

2006-09-22 Thread Charles Sprickman
Hi all, I still have an dual dual-core opteron box with a 3Ware 9550SX-12 sitting here and I need to start getting it ready for production. I also have to send back one processor since we were mistakenly sent two. Before I do that, I would like to record some stats for posterity and post to t

[PERFORM] Benchmarks

2006-08-22 Thread Charles Sprickman
Hi all, I'm really glad to see all the test results people are posting here. In fact, I used info from the archives to put together our first "big" database host: -Tyan dual-core/dual-cpu mainboard ( -One Opteron 270 2.0GHz (although our vendor gave us two for some reason) -Chenbro 3U case (

Re: [PERFORM] Performance with 2 AMD/Opteron 2.6Ghz and 8gig

2006-07-28 Thread Charles Sprickman
On Fri, 28 Jul 2006, Mikael Carneholm wrote: Luke, Yeah, I read those results, and I'm very disappointed with my results from the MSA1500. I would however be interested in other people's bonnie++ and benchmarksql results using a similar machine (2 cpu dual core opteron) with other "off the shel

Re: [PERFORM] Huge Data sets, simple queries

2006-01-29 Thread Charles Sprickman
On Sun, 29 Jan 2006, Luke Lonergan wrote: In fact, in our testing of various host-based SCSI RAID adapters (LSI, Dell PERC, Adaptec, HP SmartArray), we find that *all* of them underperform, most of them severely. [snip] The important lesson we've learned is to always test the I/O subsystem p

Re: [PERFORM] SAN/NAS options

2006-01-14 Thread Charles Sprickman
On Sat, 14 Jan 2006, Luke Lonergan wrote: Charles, On 1/14/06 6:37 PM, "Charles Sprickman" <[EMAIL PROTECTED]> wrote: I'm vaguely considering pairing these two devices: http://www.areca.us/products/html/products.htm That's an Areca 16 channel SATA II (I haven&#x

Re: [PERFORM] SAN/NAS options

2006-01-14 Thread Charles Sprickman
Following up to myself again... On Wed, 14 Dec 2005, Charles Sprickman wrote: Hello all, Supermicro 1U w/SCA backplane and 4 bays 2x2.8 GHz Xeons Adaptec 2015S "zero channel" RAID card I don't want to throw away the four machines like that that we have. I do want to thr

Re: [PERFORM] SAN/NAS options

2005-12-20 Thread Charles Sprickman
On Wed, 14 Dec 2005, Charles Sprickman wrote: [big snip] The list server seems to be regurgitating old stuff, and in doing so it reminded me to thank everyone for their input. I was kind of waiting to see if anyone who was very pro-NAS/SAN was going to pipe up, but it looks like most people

[PERFORM] SAN/NAS options

2005-12-20 Thread Charles Sprickman
Hello all, It seems that I'm starting to outgrow our current Postgres setup. We've been running a handful of machines as standalone db servers. This is all in a colocation environment, so everything is stuffed into 1U Supermicro boxes. Our standard build looks like this: Supermicro 1U w/S

[PERFORM] SAN/NAS options

2005-12-13 Thread Charles Sprickman
Hello all, It seems that I'm starting to outgrow our current Postgres setup. We've been running a handful of machines as standalone db servers. This is all in a colocation environment, so everything is stuffed into 1U Supermicro boxes. Our standard build looks like this: Supermicro 1U w/S