Re: [PERFORM] Filesystem benchmarking for pg 8.3.3 server

2008-08-08 Thread Andrej Ricnik-Bay
On 09/08/2008, Henrik <[EMAIL PROTECTED]> wrote: > But random writes should be faster on a RAID10 as it doesn't need to > calculate parity. That is why people suggest RAID 10 for datases, correct? If it had 10 spindles as opposed to 4 ... with 4 drives the "split" is (because you're striping and m

Re: [PERFORM] file system and raid performance

2008-08-07 Thread Andrej Ricnik-Bay
2008/8/8 Scott Marlowe <[EMAIL PROTECTED]>: > noatime turns off the atime write behaviour. Or did you already know > that and I missed some weird post where noatime somehow managed to > slow down performance? Scott, I'm quite aware of what noatime does ... you didn't miss a post, but if you look

Re: [PERFORM] file system and raid performance

2008-08-07 Thread Andrej Ricnik-Bay
To me it still boggles the mind that noatime should actually slow down activities on ANY file-system ... has someone got an explanation for that kind of behaviour? As far as I'm concerned this means that even to any read I'll add the overhead of a write - most likely in a disk-location slightly of

Re: [PERFORM] Fusion-io ioDrive

2008-07-01 Thread Andrej Ricnik-Bay
On 02/07/2008, Jeffrey Baker <[EMAIL PROTECTED]> wrote: > Yeah. The manufacturer rates it for 5 years in constant use. I > remain skeptical. I read in one of their spec-sheets that w/ continuous writes it should survive roughly 3.4 years ... I'd be a tad more conservative, I guess, and try to dr

Re: [PERFORM] Fusion-io ioDrive

2008-07-01 Thread Andrej Ricnik-Bay
On 02/07/2008, Jeffrey Baker <[EMAIL PROTECTED]> wrote: > Red Hat and its clones. The other problem is the 80GB model is too > small to hold my entire DB, Although it could be used as a tablespace > for some critical tables. But hey, it's fast. And when/if it dies, please give us a rough gues

Re: [PERFORM] Max shared_buffers

2008-04-03 Thread Andrej Ricnik-Bay
On 04/04/2008, Scott Marlowe <[EMAIL PROTECTED]> wrote: > Not entirely true. on 32 bit OS / software, the limit is just under 2 > Gig. Where do you get that figure from? There's an architectural (theoretical) limitation of RAM at 4GB, but with the PAE (that pretty much any CPU since the Pentium

Re: [PERFORM] What is the best way to storage music files in Postgresql

2008-03-18 Thread Andrej Ricnik-Bay
On 18/03/2008, Craig Ringer <[EMAIL PROTECTED]> wrote: > Isn't a 10 or 24 spindle RAID 5 array awfully likely to encounter a > double disk failure (such as during the load imposed by rebuild onto a > spare) ? I never said that we actually USED that set-up. I just said I did extensive testing wi

Re: [PERFORM] What is the best way to storage music files in Postgresql

2008-03-18 Thread Andrej Ricnik-Bay
On 18/03/2008, Peter Koczan <[EMAIL PROTECTED]> wrote: > available, and RAID 5 and RAID 6 are just huge pains and terribly slow > for writes. RAID 5 and RAID 6 are just huge pains and terribly slow for writes with small numbers of spindles ;} In my testing I found that once you hit 10 spi

Re: [PERFORM] performance tools

2008-03-17 Thread Andrej Ricnik-Bay
On 18/03/2008, sathiya psql <[EMAIL PROTECTED]> wrote: > i thought many a replies will come... but only one.. You *ARE* aware of the fact that many people on this planet aren't in your time-zone, eh? And as Ben pointed out: there's been a good lot of similar questions - people who want to know can

Re: [PERFORM] Benchmark: Dell/Perc 6, 8 disk RAID 10

2008-03-17 Thread Andrej Ricnik-Bay
On 17/03/2008, Justin <[EMAIL PROTECTED]> wrote: > OK i'm showing my ignorance of linux. On Ubuntu i can't seem to figure > out if XFS file system is installed, if not installed getting it > installed. ... > any pointers would be nice. I 'm not going to reinstall the OS. Nor do > i want to

Re: [PERFORM] ER diagram tool

2008-03-13 Thread Andrej Ricnik-Bay
On 14/03/2008, sathiya psql <[EMAIL PROTECTED]> wrote: > no other groups are replying. You waited for a *whole* *hour* before deciding to cross-post? Wow. -- Please don't top post, and don't use HTML e-Mail :} Make your quotes concise. http://www.american.edu/econ/notes/htmlmail.htm -- S