Does anyone encounter this?
I've just started with postgres and i'm using it to store data from financial feeds...stuff like stocks etc.
it goes to the source site to grab every 15 minutes.
This is what i noticed...when i first started this, it took 3 minutes to completely grab all relevant stuff. subsequently it starting to slow down to 15 minutes to complete the grabbing. basically eating up all my CPU time.
because of that, i moved the capture to a fresh server with postgres. everything was back to normal...the capture was fast.
but today i realised it's gone back to taking as long as 15-30 minutes to grab the feeds.
any suggestions or insights?? i'm using perl with pg.pm module to access the db.
thanks
Leslie
I've just started with postgres and i'm using it to store data from financial feeds...stuff like stocks etc.
it goes to the source site to grab every 15 minutes.
This is what i noticed...when i first started this, it took 3 minutes to completely grab all relevant stuff. subsequently it starting to slow down to 15 minutes to complete the grabbing. basically eating up all my CPU time.
because of that, i moved the capture to a fresh server with postgres. everything was back to normal...the capture was fast.
but today i realised it's gone back to taking as long as 15-30 minutes to grab the feeds.
any suggestions or insights?? i'm using perl with pg.pm module to access the db.
thanks
Leslie