Less than 1 month –
10-30 hrs/week –
Running a 400GB CDR file that contains many call detail records. Performance tweaking needed on a slave DB that is replicated by slony.
Machines contain SSDs and lots of RAM, but certain queries still take multiple minutes.
Hoping that expert can assist with running maintenance on the database, including VACUUM, ANALYZE, in addition to setting up postgresql.conf