[GENERAL] drop view and recreate - for sync

2009-10-23 Thread Sydney Puente
Hello, I have a requirement to pull 2 tables of data from an unreliable db and stash the data in postgres on redhat. Dont imagine the initial load will be be too difficult, gonna use perl DBD to get the data. 100 000 records in total , 10 -15 fields. needs sync-ing regularly - every 12 hours

[GENERAL] drop view and recreate - for sync

2009-10-23 Thread Sydney Puente
On Fri, Oct 23, 2009 at 2:45 AM, Sydney Puente sydneypue...@yahoo.com wrote: This data will be accessed a couple of times a second, and I have a cunning plan to have a view that points to the initial dataload, and then load up the new data into a shadow table, drop the view and then recreate

[GENERAL] ms-sql - pg 8.x

2009-09-30 Thread Sydney Puente
Hello, It seems that very shortly I will have to extract some data from ms-sql server and load it into postgres. It seems that the ms-sql is getting bigger with increasingly more users and performance is getting worse n worse. And a local copy of data is required for and application that needs