Pgsql DB User Function fix (find who's calling it)
€30-250 EUR
Paid on delivery
I'm having issues with a specific user function in my Pgsql ( postgresql 8.4) database that needs fixing.
After transferring server and DB from real PC to the VM, all works except new server doesn't show statistics.
We found the problem source (most possibly) is stats update function in DB.
Found by adding "track_functions = pl" to /etc/postgresql/8.4/main/[login to view URL]
So old server has:
datacenter_new=# SELECT * FROM pg_stat_user_functions;
funcid | schemaname | funcname | calls | total_time | self_time
----------+------------+-----------------------+-------+------------+----------- 32645236 | ADMIN | _get_news_url | 44 | 43244836 | ADMIN | _util_update_stat_new | 27 | 1365 | 1365
32645239 | ADMIN | _util_update_stat | 27 | 37511 | 37511
calls
And new doesn't have any calls of _util_update_stat at all which makes Stats table empty
You need to track why is this happening & fix it.
Server is a bunch of [login to view URL] scripts, but seems it doesn't matter cause all scripts just READ this stats table (i guess)
Pgsql expirience is a must Perl expirience is a plus.
Plz no "manager" bids, don't waste your time, will talk with developers only. (if you are a "manager" it will be seen after the 2nd tech question Plz don't waste OUR time!!!!)
Thank you!
p.s. max budget is 100.
Project ID: #38046025
About the project
Awarded to:
Hi there, i have experience in pgsql and Linux administration. I can check why stats are not being enabled in your new server for pgsql. Need root login details to troubleshoot the problem. Thank you
15 freelancers are bidding on average €142 for this job
My name is Muhammad Abdullah, an experienced IT professional with a strong grasp on Linux, making me well-versed in PostgreSQL. Given your project's specific need of fixing a user function and rectifying statistics iss More
Dear sir, I'm knowledgeable in PostgreSql, and Perl programming language. I can help to fix the issue is related to the pg_stat_user_functions view not showing any calls for the _util_update_stat function on the new s More
As an expert in PostgreSQL and Linux, I am confident in my ability to address the issues you're experiencing with your Pgsql user function. With a strong background in database management and optimization, I am well-ve More
Hi there, ★★★ Database Design & Development Expert ★★★ 7+ Years of Experience ★★★ I've read requirements and ready to work on your project. I have completed multiple projects across various domains like Manufacturing, More
I have more than 14 years of IT experience with various database technologies. Working Knowledge of Oralce,postgres Databases. Strong experience in Oracle to postgres migration Strong Oralce Development Skills worki More