Re: [PERFORM] MySQL HandlerSocket - Is this possible in PG?

-- Michael Ben-Nes - Internet Consultant and Director. http://www.epoch.co.il - weaving the Net. Cellular: 054-4848113 -- On Tue, Dec 21, 2010 at 11:07 PM, Merlin Moncure wrote: > On Tue, Dec 21, 2010 at 10:50 AM, Pavel Stehule > wrote: >

Re: [PERFORM] MySQL HandlerSocket - Is this possible in PG?

rds > > Pavel Stehule > > 2010/12/21 Michael Ben-Nes : > > Hi, > > > > Just stumbled on the following post: > > > http://yoshinorimatsunobu.blogspot.com/2010/10/using-mysql-as-nosql-story-for.html > > > > The post claim that MySQL can do more qps the

[PERFORM] MySQL HandlerSocket - Is this possible in PG?

, is it possbile to achive the same using PG 9.0.x 2. Is it possible at all? It seems to me that if such gain is possible, PG should benefit from that significantly when it comes to Key/Value queries. Best, Miki -- Michael Ben-Nes - Internet

Re: [PERFORM] Integrated perc 5/i

Thanks for all the answers. It seems its a capable card. Did any one changed the default stripe of 128kb ? On 8/16/07, Steinar H. Gunderson <[EMAIL PROTECTED]> wrote: > > On Thu, Aug 16, 2007 at 11:26:52AM +0300, Michael Ben-Nes wrote: > > Does any one have any experience with

[PERFORM] Integrated perc 5/i

/pgsql.performance/browse_thread/thread/b85926fe6de1f6c2/38837995887b6033?lnk=st&q=perc+5%2Fi+performance&rnum=6&hl=en#38837995887b6033 Does any one have any experience with RAID 10 & perc 5/i ? Thanks, Miki -- -------------- Michael Ben-Nes - Internet Consulta

[PERFORM] RAID 10 or RAID 10 + RAID 1

) + RAID 10 on 4 disks ( PostgreSQL ) What is the recommended stripe size ( The computer is Dell PowerEdge 2950 ) Thanks, Miki -- -- Michael Ben-Nes - Internet Consultant and Director. http://www.epoch.co.il - weaving the Net. Cellular: 054-4848113 --

[PERFORM] Lower Random Access Time vs RAID 0 / 1

chart=32 Will be happy to hear recommendations and ideas. Thanks, Miki -- -------------- Michael Ben-Nes - Internet Consultant and Director. http://www.epoch.co.il - weaving the Net. Cellular: 054-4848113 --

Re: [PERFORM] Advice on RAID card

I think the answer is simple if the question is low end Raid card or software ? go on the software and youll get better performance. If this is a high end server i wouldnt think twice. HW RAID is a must and not only because the performance but because the easynes ( hot swap and such ) and t

Re: [PERFORM] Advice on RAID card

I would consider Software Raid PFC wrote: Hello fellow Postgresql'ers. I've been stumbled on this RAID card which looks nice. It is a PCI-X SATA Raid card with 6 channels, and does RAID 0,1,5,10,50. It is a HP card with an Adaptec chip on it, and 64 MB cache. HP Part # :

Re: [PERFORM] RAID Stripe size

Hi John A Meinel wrote: bm\mbn wrote: Hi Everyone The machine is IBM x345 with ServeRAID 6i 128mb cache and 6 SCSI 15k disks. 2 disks are in RAID1 and hold the OS, SWAP & pg_xlog 4 disks are in RAID10 and hold the Cluster itself. the DB will have two major tables 1 with 10 million rows