Re: [PERFORM] H800 + md1200 Performance problem

2012-04-09 Thread Cesar Martin
Hi, Today I'm doing new benchmarks with RA, NORA, WB and WT in the controller: With NORA - dd if=/vol02/bonnie/DD of=/dev/null bs=8M count=16384 16384+0 records in 16384+0 records out 137438953472 bytes (137 GB) copied, 318,306 s, 432 MB/s With RA dd if=/vol02/bonnie

Re: [PERFORM] about multiprocessingmassdata

2012-04-09 Thread Merlin Moncure
On Thu, Apr 5, 2012 at 9:47 AM, Tomas Vondra wrote: > On 5.4.2012 15:44, superman0920 wrote: >> Sure, i will post that at tomorrow. >> >> Today I install PG and MySQL at a  Server. I insert 85 rows record >> to each db. >> I execute "select count(*) from poi_all_new" at two db. >> MySQL takes

Re: [PERFORM] about multiprocessingmassdata

2012-04-09 Thread Tomas Vondra
On 10.4.2012 00:37, Merlin Moncure wrote: > On Thu, Apr 5, 2012 at 9:47 AM, Tomas Vondra wrote: >> If you have slower drives, the dependency is about linear (half the >> speed -> twice the time). So either your drives are very slow, or >> there's something rotten. >> >> I still haven's seen iostat

Re: [PERFORM] Planner selects slow "Bitmap Heap Scan" when "Index Scan" is faster

2012-04-09 Thread Jeff Janes
On Fri, Apr 6, 2012 at 3:09 PM, Kim Hansen wrote: > Hi all > > On Fri, Apr 6, 2012 at 19:11, Jeff Janes wrote: >> On Wed, Apr 4, 2012 at 6:47 AM, Kim Hansen wrote: >>> Hi All >>> >>> I have a query where the planner makes a wrong cost estimate, it looks >>> like it underestimates the cost of a "