Re: [GENERAL] horizontal sharding

2009-06-28 Thread mobiledreamers
Thanks a lot greg trying it out If it does not work i ll post to pgpool groups thanks again but i think what you have pointed out is the right solution On Sat, Jun 27, 2009 at 10:59 PM, Greg Smith wrote: > On Fri, 26 Jun 2009, mobiledream...@gmail.com wrote: > > 2009-06-26 18:48:34 ERROR: pid

Re: [GENERAL] horizontal sharding

2009-06-27 Thread mobiledreamers
yeah i have never tried slony and i didnt try plproxy as it is a new language and need to modify all client code not modifiying client code in pgpool 2 rocks On Sat, Jun 27, 2009 at 12:52 AM, Scott Marlowe wrote: > Oh crap I think I mixed it up in my head with slony II. nevermind. :) > > On Sa

Re: [GENERAL] horizontal sharding

2009-06-27 Thread mobiledreamers
no it is very good and well designed the whole app code doesnt need to change we jus need to configure the pgpool insertion logic and it has a cool pgpooladmin in php like phppgadmin if only i can get it to work On Fri, Jun 26, 2009 at 10:53 PM, Scott Marlowe wrote: > I thought pgool II was ab

Re: [GENERAL] horizontal sharding

2009-06-26 Thread mobiledreamers
Hey johnthanks i did read both extensively, but finishing all the steps parallel mode or horizontal partitioning mode doesnot work! but this is my conf file # backend_hostname, backend_port, backend_weight # here are examples backend_hostname0 = 'localhost' backend_port0 = 5432 backend_weight0

Re: [GENERAL] horizontal sharding

2009-06-26 Thread mobiledreamers
can someone show how to setup pgpool 2 in parallel replication modethanks a lot On Thu, Jun 25, 2009 at 10:28 AM, Scott Marlowe wrote: > On Thu, Jun 25, 2009 at 12:03 AM, wrote: > > GOals are to scale our game for 1 simultaneous connection to db > > right now db crashing at 500 or 1000 sim c

Re: [GENERAL] horizontal sharding

2009-06-26 Thread mobiledreamers
can someone show how to setup pgpool 2 in parallel *query* mode ie horizontal partitioningthanks a lot On Fri, Jun 26, 2009 at 5:35 PM, wrote: > can someone show how to setup pgpool 2 in parallel replication modethanks > a lot > > > On Thu, Jun 25, 2009 at 10:28 AM, Scott Marlowe > wrote: > >>

Re: [GENERAL] horizontal sharding

2009-06-25 Thread mobiledreamers
GOals are to scale our game for 1 simultaneous connection to db right now db crashing at 500 or 1000 sim connections On Mon, Jun 15, 2009 at 8:07 AM, David Fetter wrote: > On Mon, Jun 15, 2009 at 12:32:15AM -0700, mobiledream...@gmail.com wrote: > > Hey guys > > what is a good way to horizon

Re: [GENERAL] horizontal sharding

2009-06-25 Thread mobiledreamers
Jim thanks Can you please show how to setup partitining in gridsql and pgpool 2 thanks a lot On Mon, Jun 15, 2009 at 10:28 AM, Jim Mlodgenski wrote: > what is a good way to horizontal shard in postgresql > >> 1. pgpool 2 >> 2. gridsql >> >> which is a better way to use sharding >> > > Both are

[GENERAL] horizontal sharding

2009-06-15 Thread mobiledreamers
Hey guys what is a good way to horizontal shard in postgresql 1. pgpool 2 2. gridsql which is a better way to use sharding also is it possible to paritition without changing client code thanks -- Bidegg worlds best auction site http://bidegg.com

Re: [GENERAL] US Highschool database in postgres

2007-03-03 Thread mobiledreamers
http://en.wikipedia.org/wiki/Category:Lists_of_schools_in_the_United_States Has one parsed the list of high schools in the USA and stored in postgres or is there an open list of backup files that people can share so they can share their useful backups of useful dbs like list of high schools list o