Tagged Questions
2
votes
1answer
49 views
What fillfactor for caching table?
I have heavily updated / accessed table where I store serialized java objects. They are in the table for 2-3 hours (also are being updated during that period) and then removed. Size of table is around ...
1
vote
1answer
60 views
Something wrong in pg_hba.conf
this my configuration:
#postgres.conf:
listen_addresses = 'localhost'
#pg_hba.conf:
local all postgres md5
local all appuser trust
local all devuser trust
local all all peer
i'm connecting in ...
3
votes
1answer
80 views
Can't understand results of pg_stat_statements view
I configured my postgresql.conf (my version is 9.1) with the normal persistent configuration:
shared_preload_libraries = 'pg_stat_statements,plperl'
custom_variable_classes = ...
2
votes
1answer
120 views
Optimal PostgreSQL setup for Windows 2008 R2
I have PostgreSQL 9.2 setup on Windows 2008 R2 64bit with 96 gigs of RAM and 8 cores. What would the optimal settings be for shared_buffers, effective_cache_size, work_mem, etc.? I realize that these ...
4
votes
1answer
141 views
PostgreSQL: Recommendation size for shared_buffers
I am rather new to PostgreSQL. I started migrating some MySQL databases to PostgreSQL one month ago.
I am looking for help about the proper memory values for the configuration file.
Currently, I ...
0
votes
1answer
115 views
Why doesn't more memory necessarily make Postgres more performant?
The Postgres resource consumption docs state, under the shared_buffers:
...it is unlikely that an allocation of more than 40% of RAM to shared_buffers will work better than a smaller amount.
Why ...
1
vote
1answer
255 views
Can't start postgres server, SHMMAX too small
When I try to start the postgres server with sudo /etc/init.d/postgresql start I get this error:
Starting PostgreSQL 8.4 database server: mainThe PostgreSQL server
failed to start. Please check ...
2
votes
1answer
319 views
Postgres: Server does not listen even listen_addresses is set to '*' in postgresql.conf
I've set listen_addresses to '*' in postgresql.conf and stopped/started Postgres to "reload" configs.
Even then, psql SHOW listen_addresses; is showing localhost.
I'm sure I've edited and saved the ...
2
votes
1answer
336 views
How to make it impossible for a postgres user to delete databases?
What yould be the sql statement (that the user postgres will execute) so it will be impossible for the postgres user user1 to delete (drop) databases?
Or can I add a rule into some config file?
1
vote
2answers
141 views
Postgresql Cost-Based Vacuum Delay parameters
How to set the these parameters on postgresql.conf ?
What I should consider while setting them?
What should I monitor?
#vacuum_cost_delay = 0ms
#vacuum_cost_page_hit = 1 ...
