Re: [PERFORM] Distributed/Parallel Computing

2009-10-05 Thread Viji V Nair
Hi Jeff, These are bulk updates of GIS data and OLTP. For example, we are running some sqls to remove specific POIs those are intersecting with others, for such exercise we need to compare and remove the data form diffrent tables including the 20M data tables. Apart form these there are bulk sele

Re: [PERFORM] Distributed/Parallel Computing

2009-10-05 Thread Jeff Janes
On Mon, Oct 5, 2009 at 12:11 PM, Viji V Nair wrote: > Hi Team, > > This question may have asked many times previously also, but I could not > find a solution for this in any post. any help on the following will be > greatly appreciated. > > We have a PG DB with PostGIS functions. There are around

[PERFORM] Distributed/Parallel Computing

2009-10-05 Thread Viji V Nair
Hi Team, This question may have asked many times previously also, but I could not find a solution for this in any post. any help on the following will be greatly appreciated. We have a PG DB with PostGIS functions. There are around 100 tables in the DB and almost all the tables contains 1 million