Re: [GENERAL] [Q] single image Table across multiple PG servers

2009-07-14 Thread Kevin Kempter
On Tuesday 14 July 2009 14:16:33 you wrote: > This is great, > thank you > > I have to say, if this is a free-of-charge > add on to postgres that works and utilizes the hardware on each server > to perform > the join, > > -- why would anybody need to use mapreduce/hadoop/etc? > for database-like se

Re: [GENERAL] [Q] single image Table across multiple PG servers

2009-07-14 Thread Scott Marlowe
On Tue, Jul 14, 2009 at 12:38 PM, 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 thin

Re: [GENERAL] [Q] single image Table across multiple PG servers

2009-07-14 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 > The reason why I think the data will not fit into one database, > is because I just do not have money for servers (everything is coming > out of my small pocket) so I just want to deploy inexpensive computers > but add them as I get more data

Re: [GENERAL] [Q] single image Table across multiple PG servers

2009-07-14 Thread Scott Mead
On Tue, Jul 14, 2009 at 1:16 AM, V S P 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 >

Re: [GENERAL] [Q] single image Table across multiple PG servers

2009-07-14 Thread Kevin Kempter
On Tuesday 14 July 2009 13:35:23 you wrote: > yes -- thank you > > that's in the direction of what I am looking for > > > ODBC connectivity and joins across databases! > > > It looks like it cannot support > a single image table across databases It's effectively a single image across nodes - in

Re: [GENERAL] [Q] single image Table across multiple PG servers

2009-07-14 Thread Kevin Kempter
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

Re: [GENERAL] [Q] single image Table across multiple PG servers

2009-07-14 Thread V S P
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 AP

Re: [GENERAL] [Q] single image Table across multiple PG servers

2009-07-14 Thread Ransika de Silva
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; http://www.jurriaanpersyn.com/archives/2009/02/12/database-sharding-at-netlog-with-mysql-and-php/, true that it's not done with PG, but the

Re: [GENERAL] [Q] single image Table across multiple PG servers

2009-07-14 Thread Scott Marlowe
On Mon, Jul 13, 2009 at 11:16 PM, V S P 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 > >

[GENERAL] [Q] single image Table across multiple PG servers

2009-07-13 Thread V S P
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 anticipati