On Tuesday 14 July 2009 12:38:27 V S P wrote: > Hi, > thank you for the links > > > I read through the presentation > > and they did not solve the issue for me -- which presenting a e > table from multiple > shards as one single table (at least for reads) for ODBC clients. > > > I also do not think that skypetools do that > > they have implemented essentially an API on top of their shards > (separate db servers) > that does the table querying. That means that I have to write a > separate API for every time > a user decides on a new query. > > > May be I misunderstood the approaches, but none of them actually > figures out how to > utilize the computing power/memory of multiple servers to satisfy > requests that spawn across > servers. > > I think Oracle supports the ability to at least reference a table > in another server, I do not think > PG does that > > It is possible that I have to look into the free DB2 server > offering (as the free version is exactly meant > to run on underpowered computers) > > I just wanted to ask the list first. > > > thank you > > > On Tue, 14 Jul 2009 13:04 +0530, "Ransika de Silva" > <ransika@xxxxxxxxx> wrote: > > Hello, > > > > We were also in search of having a table split across multiple > databases but then found out about skypetools and at the same > time the following > article; [1]http://www.jurriaanpersyn.com/archives/2009/02/12/dat > abase-sharding-at-netlog-with-mysql-and-php/, true that it's not > done with PG, but the same thing can be done with PG as well. > > > > Assume this will be helpful for you. > > > > Regards, > > Ransika > > On Tue, Jul 14, 2009 at 4:20 PM, Scott Marlowe > <[2]scott.marlowe@xxxxxxxxx> wrote: > > On Mon, Jul 13, 2009 at 11:16 PM, V S P<[3]toreason@xxxxxxxxxxx> > > wrote: > > Hello > > > > I am researching how to store the data for easy 'user-driven' > > reporting (where I do not need to develop application for > > every user request). > > > > The data will typically be number ranges and text strings with > > unique Id for each row > > > > I hope there will be a lot of data :-). > > > > So in that anticipation I am looking for a way > > to allow > > SQL/ODBC access to the data > > > > but in a way that each table resides on more than one > > PG server > > > > for example: > > > > table 1 lives in 3 PG instances (I can partition the data by > > date range) > > > table 2 lives in the same 3 instances plus another one (because > > it's > > > bigger) > > > > > > and I would like users to be able to issue SQL from within ODBC > > that > > > joins them. > > I think that skype's skytools could be used to create such a > solution, > in particular pl/proxy. > > > -- > Sent via pgsql-general mailing list > ([4]pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > [5]http://www.postgresql.org/mailpref/pgsql-general > > -- > Ransika De Silva > SCMAD 1.0, SCJP 1.4, > BSc.(Hons) Information Systems > > References > > 1. > http://www.jurriaanpersyn.com/archives/2009/02/12/database-sharding-at-netl >og-with-mysql-and-php/ 2. mailto:scott.marlowe@xxxxxxxxx > 3. mailto:toreason@xxxxxxxxxxx > 4. mailto:pgsql-general@xxxxxxxxxxxxxx > 5. http://www.postgresql.org/mailpref/pgsql-general > -- > Vlad P > author of C++ ORM http://github.com/vladp/CppOrm/tree/master Maybe this is what you're looking for? http://www.enterprisedb.com/community/projects/gridsql.do -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
