Re: [PERFORM] Best OS for Postgres 8.2

2007-05-11 Thread Adam Witney
> currently ZFS is only available on Solaris, parts of it have been released > under GPLv2, but it doesn't look like enough of it to be ported to Linux > (enough was released for grub to be able to access it read-only, but not > the full filesystem). there are also patent concerns that are preve

pgsql-performance@postgresql.org

2006-03-21 Thread Adam Witney
> [EMAIL PROTECTED]:43]~:15>sudo diskinfo -vt /dev/mirror/gm0 Can anyone point me to where I can find diskinfo or an equivalent to run on my debian system, I have been googling for the last hour but can't find it! I would like to analyse my own disk setup for comparison Thanks for any help Ad

Re: [PERFORM] Visual Explain

2004-06-17 Thread Adam Witney
Will this run on other platforms? OSX maybe? > I've known about this tool for a while, but it seems many people do not > know of its existence and I think it would be useful to a lot of people > who have a hard time reading explain analyze output. (And even those > who can read them without blink

Re: [PERFORM] Hardware advice

2003-11-24 Thread Adam Witney
On 30/5/03 6:17 pm, "scott.marlowe" <[EMAIL PROTECTED]> wrote: > On Fri, 30 May 2003, Adam Witney wrote: > >> Hi scott, >> >> Thanks for the info >> >>> You might wanna do something like go to all 146 gig drives, put a mirror >>

Re: [PERFORM] Hardware performance

2003-07-17 Thread Adam Witney
On 17/7/03 4:09 pm, "Joe Conway" <[EMAIL PROTECTED]> wrote: > Adam Witney wrote: >> I think the issue from the original posters point of view is that the Dell >> PE2650 can only hold a maximum of 5 internal drives >> > > True enough, but m

Re: [PERFORM] Hardware performance

2003-07-17 Thread Adam Witney
> As I said, I've never personally found it necessary to move WAL off to a > different physical drive. What do you think is the best configuration > given the constraint of 5 drives? 1 drive for OS, and 4 for RAID 1+0 for > data-plus-WAL? I guess the ideal would be to find enough money for that >