On Tue, Jul 14, 2009 at 1:16 AM, V S P <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
Take a look at open-source GridSQL:http://sourceforge.net/projects/gridsql/ It'll do what you want and provide parallel query across your nodes. --Scott