All Questions
Tagged with performance-tuning postgresql
9 questions
2
votes
1
answer
354
views
Postgresql performance seems capped, cannot work out why
I'm setting up a new PG13 cluster, on ubuntu 20.04, virtual machine. The performance I'm seeing, via pgbench, is neither good nor bad. What I'm trying to work out is why it is what it is, and not ...
- 238
1
vote
1
answer
536
views
Persist statistics data from Postgres' stats_temp_directory on demand
We are investigating I/O load in one of our VMs and possibilities to optimize it and it showed that most of the load is generated by the stats collector of PostgreSQL. It jumps between 3,5 and 6,5 MB/...
11
votes
3
answers
7k
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 ...
- 1,356
6
votes
1
answer
14k
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 ...
- 368
4
votes
2
answers
1k
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 ...
- 161
5
votes
1
answer
5k
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,560
1
vote
2
answers
1k
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 ...
- 7,457
2
votes
2
answers
808
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 ...
- 377
1
vote
1
answer
1k
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 ...
- 30.4k