Postgres Pro
Downloads
Home   >   mailing lists

Re: [Q] single image Table across multiple PG servers - Mailing list pgsql-general

From Scott Mead
Subject Re: [Q] single image Table across multiple PG servers
Date
Msg-id d3ab2ec80907141249x53b68e6fp8d10a4dd956c5a6@mail.gmail.com
Whole thread Raw
In response to [Q] single image Table across multiple PG servers  ("V S P" <toreason@fastmail.fm>)
List pgsql-general
Tree view

On Tue, Jul 14, 2009 at 1:16 AM, V S P <toreason@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:

   It'll do what you want and provide parallel query across your nodes.

--Scott 

pgsql-general by date:

Previous
From: Kevin Kempter
Date:
Subject: Re: [Q] single image Table across multiple PG servers
Next
From: "Greg Sabino Mullane"
Date:
Subject: Re: [Q] single image Table across multiple PG servers