Re: [PERFORM] IDE x SAS RAID 0 on HP DL 380 G5 P400i controller performance problem

2010-07-19 Thread Daniel Ferreira de Lima
ries (and.. why it's not default???). I think that this thread is now finished. Thanks! -- Daniel Ferreira

Re: [PERFORM] IDE x SAS RAID 0 on HP DL 380 G5 P400i controller performance problem

2010-07-19 Thread Daniel Ferreira de Lima
bled by default. Or problems with older version of kernel module (cciss) turn it off by some kind of incompatibility. Search the archives for BBU and you'll find many other discussions > of this. > > -Kevin > Thanks, Kevin. -- Daniel Ferreira

[PERFORM] IDE x SAS RAID 0 on HP DL 380 G5 P400i controller performance problem

2010-07-19 Thread Daniel Ferreira de Lima
real case: ~100k database insertions that runs in 2 min in the IDE, against ~40 minutes (P400i) in the HP. The same test in the HP Blade G5 P200 controller works fine. Thanks for any answers/analisys. Best regards. -- Daniel Ferreira

[PERFORM] query planner uses sequencial scan instead of index scan

2009-05-21 Thread Daniel Ferreira
Hi all, iam having trouble with a query, in this query we have parameters, to indicate the starting month and the ending month (commented line in the query). You can see the explain using the parameters of month from 1 to 6 EXPLAIN ANALYZE select pq.nome, mv.data, mv.valor, gprd.tipo,