On Wed, Jun 24, 2009 at 11:03:07PM -0700, [email protected] wrote: > GOals are to scale our game for 10000 simultaneous connection to db > right now db crashing at 500 or 1000 sim connections
Consider using pgbouncer to multiplex your database connections. If that doesn't work, consider hiring one of the PostgreSQL consulting outfits like Command Prompt, Endpoint, OmniTI, or the one I work for, PostgreSQL Experts <http://www.pgexperts.com/> Cheers, David. > On Mon, Jun 15, 2009 at 8:07 AM, David Fetter <[email protected]> > wrote: > > > On Mon, Jun 15, 2009 at 12:32:15AM -0700, [email protected] > > wrote: > > > Hey guys what is a good way to horizontal shard in postgresql > > > > "Sharding" is not really a technical term, so it's not really > > possible to answer this question meaningfully as posed. > > > > What is it that you actually want to accomplish here exactly? > > What are your goals, and what are your priorities on those goals? > > What will you trade off to achieve them? > > > > > 1. pgpool 2 2. gridsql > > > > > > which is a better way to use sharding > > > > > > also is it possible to paritition without changing client code > > > > Almost certainly not. This would be one of the trade-offs > > mentioned above. -- David Fetter <[email protected]> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: [email protected] Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
