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 ...
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 ...
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 ...
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 ...
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 ...