2
votes
5answers
7k 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 ...
1
vote
2answers
361 views

PostgreSQL Left join select VS Normal select

I was wondering which is faster - joining several selects into one join select or actually doing the separate selects is faster ? I'm doing a task which has many tables(currently 4 but it'll increase ...
1
vote
2answers
208 views

Geographic web+pgsql load balancing

My goal is (don't know if this is possible, that's why I'm asking): have two separate geographic locations. At each location, a web server and a postgres database run. The application is the same at ...
2
votes
1answer
1k views

Loading large CSV into Postgres

I'm trying to load a CSV of about 100M records (around 8GB on disk) into Postgres via the copy command: copy mytable from 'path/to/myfile.csv' with CSV; I have been monitoring the progress by checking ...
2
votes
3answers
3k views

managing high load of a postgresql database

I seem to be having a problem whereby a server running postgresql is experiencing rather high load with the average being above 30. This server is running as a vm on vmware. What I'm wondering is ...