-3
votes
1answer
106 views

Can postgres go faster? [closed]

My question is simply: have i missed any configuration settings that might make postgres achieve better read throughput? Background I'm modeling a very simple twitter program. My schema has only 3 ...
1
vote
0answers
245 views

How to manage postgres server cpu load and idle in transaction warning? [closed]

I am using postgres db with django app. I created two daemon process out of it, one is used for scheduling some tasks(APScheduler) and other one is to dump events into database subscribing them via ...
0
votes
1answer
70 views

Mysql proxy in comparison with two database connection

We have a situation in which we have master salve databases, we write in master and read from slave. in application we defined two connections one for write and other for read. I came to know know ...
0
votes
1answer
113 views

Optimizing MySQL Database for wordpress

I am maintaining a blog with self hosted wordpress. For the last 5 months, my blog isn't really active as I hit "Server Error 500". The error says "The FastCGI process exceeded configured activity ...
0
votes
1answer
133 views

MySQL's Query Optimizer's take on disk access time

I don't have a ton of background with MySQL, and I was wondering of anyone can give me some insight into MySQL's query optimizer and the impact on the cost of disk accesses in determining a query plan ...
2
votes
5answers
6k views

How to Best Manage High PostgreSQL CPU Use?

I am trying to fix a high PostgreSQL CPU use problem. We are using PostgreSQL 8.0.9 and when our JEE web application (in JBoss) is used in certain load increase conditions, top shows a slow increase ...
2
votes
3answers
369 views

PostgreSQL lots of writes

I am using postgreSQL for a scientific application (unsupervised clustering). The python program is multi-threaded so that each thread manages its own postmaster process (one per core). Hence, their ...