2
votes
2answers
772 views

Too much I/O generated by postgres stats collector process

I am using XenServer with several virtual machines having local postgres databases. Even when all applications are unused and the databases are idle, each vm causes constant storage network traffic ...
3
votes
1answer
1k views

Strange high CPU I/O wait on postgresql server

I'm really struggling with a performance issue currently, where all my database queries takes up to a 1000 times more than normally, when my database server is under "heavy" load. I have a server ...
3
votes
2answers
495 views

PostgreSQL tuning recommendation for large server and dataset

I'm working with a PostgreSQL (8.1) server on a dedicated machine with 64 GB of RAM and a fast RAID disk. The data set itself is pretty huge -- we have several tables around 200 GB, more in the 50-100 ...
4
votes
1answer
1k views

PostgreSQL - count() performance and how to tweak it?

I've done some reading in google and the only thing I did was get myself confused. Some of the people say that count() is slower with many records, others say you can cache the number or even use ...
1
vote
2answers
743 views

How to tune down the Hyperic built-in postgresql database for a small setup

We are testing out Hyperic 4.5.1 in a quite small environment for now. Currently there are just 1-5 agents and there probably won't be any more than 10-15. When I run ps ax there are 20(!) postgres ...
1
vote
2answers
115 views

Simple queries occasionally running very slowly

I have some very simple queries that occasionally run very slowly. The table viewed_sites has about 10 - 20 rows. Running EXPLAIN ANALYZE always gives a runtime of less than 3 milliseconds. When ...
1
vote
1answer
457 views

postgresql - cache preferences per table/db

i'm curious if there is any way to hint postgresql which data should be more likely cached in memory. in my scenario the server would be handling mostly read traffic, whole data-set is much larger ...