-3
votes
1answer
80 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
196 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 ...
2
votes
1answer
128 views

how to optimize postgresql81 for a hug query but not a complicated one?

i have a query which execution takes 15s on the server. the server is bi-xeon 5130 (2GHz) with 2GB of RAM and 160GB of scsi hardrive in RAID. Database is PostgreSQL 8.1 on Debian 4 etch. This query ...
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 ...
0
votes
1answer
277 views

Postgresql Optimization

I am running a more or less out the box Postgresql installation which is running really slowly. I am parsing a whole bunch of logs files using Perl and using Perl's DBI interface (connecting to the ...
2
votes
1answer
1k views

How to optimize a postgreSQL server for a “write once, read many”-type infrastructure?

Greetings, I am working on a piece of software that logs entries (and related tagging) in a PostgreSQL database for storage and retrieval. We never update any data once it has been inserted; we might ...
2
votes
3answers
364 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 ...
0
votes
3answers
821 views

How to optimize postgresql for use with Jackrabbit (a lot of blobs)?

Jackrabbit is a implementation of the JCR (Java Content Repository API), and it is used for instance by Artifactory which stores the maven artifacts in it. Therefore most of the stuff consists of ...