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

On Mon, Jul 13, 2009 at 11:16 PM, V S Ptorea...@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

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

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

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

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

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

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

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

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 that the

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

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

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

-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 to

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

On Tue, Jul 14, 2009 at 12:38 PM, V S Ptorea...@fastmail.fm 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

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

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 selects ?

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

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