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" <rans...@gmail.com> 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.marl...@gmail.com> wrote: On Mon, Jul 13, 2009 at 11:16 PM, V S P<[3]torea...@fastmail.fm> 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-gene...@postgresql.org) 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-netlog-with-mysql-and-php/ 2. mailto:scott.marl...@gmail.com 3. mailto:torea...@fastmail.fm 4. mailto:pgsql-general@postgresql.org 5. http://www.postgresql.org/mailpref/pgsql-general -- Vlad P author of C++ ORM http://github.com/vladp/CppOrm/tree/master -- http://www.fastmail.fm - The professional email service
