Search Results
Search type | Search syntax |
---|---|
Tags | [tag] |
Exact | "words here" |
Author |
user:1234 user:me (yours) |
Score |
score:3 (3+) score:0 (none) |
Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
Views | views:250 |
Code | code:"if (foo != bar)" |
Sections |
title:apples body:"apples oranges" |
URL | url:"*.example.com" |
Saves | in:saves |
Status |
closed:yes duplicate:no migrated:no wiki:no |
Types |
is:question is:answer |
Exclude |
-[tag] -apples |
For more details on advanced search visit our help page |
Performance issues with PostgreSQL queries
2
votes
Measure CPU and Memory usage while running pgbench
Greg Smith has pgbench-tools which does multiple runs of pgbench, with concurrent runs of vmstat and iostat during the pgbench runs. It also lets you graph results with gnuplot. It sounds like it woul …
1
vote
enabling fsync in postgresql 9.1
If you've not changed those parameters they should be enabled by default.
You should only need to uncomment them if you're going to change them.
You can check the running parameters for the server w …
6
votes
Accepted
Postgresql equivalent to sqlite pragma
Most of what these pragmas do for SQLite can be best accomplished by using an UNLOGGED table or a TEMPORARY table.
This also makes it very obvious that these are ephemeral tables, that aren't crash …
2
votes
Accepted
To minimize Cache misses in PostgreSQL?
Keeping things cached with PostgreSQL is a balance between what you can have in shared_buffers and what you have in the filesystem cache, and avoiding both of them being pushed out by other processes. …
6
votes
What causes large INSERT to slow down and disk usage to explode?
If you only changed the shared_buffers,work_mem, and effective_cache_size config variables, then you're probably still running with checkpoint_segments=3.
In this case you only have three WAL segmen …
2
votes
Accepted
Postgres 4x Slower Than It Was
Based on your configurations and output, the only suggestions I can make for you to try are the following.
Disable Transparent Huge Pages. Evidence from the PostgreSQL mailing lists, and Red Hat them …