I would like to get the suggestion for my usecase.
We have a database in our production machine.We are doing continuous writes in that database since we are doing crawling,parsing and it is being inserted into database as a streamer.We are running some crons on the database.That database gets some reads for the web application also.
I got the requirement just to store the html document into one another table for the cross verification.So,the plan was to store the pages into one new table which was created in the same database.Here we need to run one more cron on the new table to find the page number and update into that table.
We got one more idea like to create the table and running cron in new database instead of the old database by considering performance improvement.
Will it be any difference to create a new database and update into it rather than using old database to update the data and running a cron?
we are using amazon ec2 medium instance with Ubuntu operating system also PostgreSQL 8.4.
your thoughts please?