Re: [PERFORM] Autodetect of software RAID1+0 fails

2007-06-01 Thread Luke Lonergan
Steinar, On 6/1/07 2:35 PM, "Steinar H. Gunderson" <[EMAIL PROTECTED]> wrote: > Either do your md discovery in userspace via mdadm (your distribution can > probably help you with this), or simply use the raid10 module instead of > building raid1+0 yourself. I found md raid10 to be *very* slow co

Re: [PERFORM] Autodetect of software RAID1+0 fails

2007-06-01 Thread mark
> On Fri, Jun 01, 2007 at 10:57:56AM -0700, Craig James wrote: > > The Linux kernel doesn't properly detect my software RAID1+0 when I boot > > up. It detects the two RAID1 arrays, the partitions of which are marked > > properly. But it can't find the RAID0 on top of that, because there's no >

Re: [PERFORM] Autodetect of software RAID1+0 fails

2007-06-01 Thread Steinar H. Gunderson
On Fri, Jun 01, 2007 at 10:57:56AM -0700, Craig James wrote: > The Linux kernel doesn't properly detect my software RAID1+0 when I boot > up. It detects the two RAID1 arrays, the partitions of which are marked > properly. But it can't find the RAID0 on top of that, because there's no > corresp

Re: [PERFORM] Autodetect of software RAID1+0 fails

2007-06-01 Thread Luke Lonergan
Dimitri, LVM is great, one thing to watch out for: it is very slow compared to pure md. That will only matter in practice if you want to exceed 1GB/s of sequential I/O bandwidth. - Luke On 6/1/07 11:51 AM, "Dimitri" <[EMAIL PROTECTED]> wrote: > Craig, > > to make things working properly here

Re: [PERFORM] Autodetect of software RAID1+0 fails

2007-06-01 Thread Dimitri
Craig, to make things working properly here you need to create a config file keeping both raid1 and raid0 information (/etc/mdadm/mdadm.conf). However if your root filesystem is corrupted, or you loose this file, or move disks somewhere else - you are back to the same initial issue :)) So, the s

[PERFORM] Autodetect of software RAID1+0 fails

2007-06-01 Thread Craig James
Apologies for a somewhat off-topic question, but... The Linux kernel doesn't properly detect my software RAID1+0 when I boot up. It detects the two RAID1 arrays, the partitions of which are marked properly. But it can't find the RAID0 on top of that, because there's no corresponding device t

Re: [PERFORM] Seq Scan

2007-06-01 Thread Michael Glaesemann
On Jun 1, 2007, at 11:48 , Tyler Durden wrote: I'm having some problems in performance in a simple select count(id) from Unrestricted count() (i.e., no WHERE clause) will perform a sequential scan. If you're looking for faster ways to store table row count information, please search t

Re: [PERFORM] Seq Scan

2007-06-01 Thread Dan Harris
Tyler Durden wrote: Hi, I'm having some problems in performance in a simple select count(id) from I have 700 000 records in one table, and when I do: # explain select (id) from table_name; -[ RECORD 1 ] QUERY PLAN | Seq Scan on

[PERFORM] Seq Scan

2007-06-01 Thread Tyler Durden
Hi, I'm having some problems in performance in a simple select count(id) from I have 700 000 records in one table, and when I do: # explain select (id) from table_name; -[ RECORD 1 ] QUERY PLAN | Seq Scan on table_name (cost=0.0