105 reputation
3
bio website
location
age
visits member for 1 year, 11 months
seen Jan 26 at 18:00

Jan
22
comment How should I tune Postgresql for 20 GB of RAM?
@mvp, it should be initdb's job to tune it right from the start. Having pgtune included for later tuning will also help, but only if it's maintained, of course, as it should be.
Jan
22
comment How should I tune Postgresql for 20 GB of RAM?
@mvp, pgtune helps over the defaults, but I wouldn't call it "fine". One can do better at args such as default_statistics_target, wal_buffers, checkpoint_completion_target, checkpoint_timeout, etc. I have some working notes.
Jan
22
comment How should I tune Postgresql for 20 GB of RAM?
As a word of caution, users must remember to always first check the existing value before updating it. If the existing value is already higher, and it may very well be, it then doesn't need to be updated.
Jan
22
comment How should I tune Postgresql for 20 GB of RAM?
pgtune is old and has not been maintained for years.
Nov
7
comment PostgreSQL Complete Database Backup
Isn't there pg_basebackup?
Nov
4
comment How to take pg_dump of a very large postgres database?
By the way, having 18500 tables in your database is outrageous, not because it is a large number, but because it is almost certainly indicative of a schema gone very wrong. And the solution is not merely to split your database into multiple databases.
Mar
27
awarded  Supporter
Mar
27
revised How do I list all databases and tables using psql?
Corrected two spelling mistakes. Made a sentence briefer.
Mar
27
suggested approved edit on How do I list all databases and tables using psql?
Feb
5
awarded  Excavator
Feb
5
awarded  Editor
Feb
5
revised How do I find PostgreSQL's data directory?
Added note suggesting that superuser access is required.
Feb
4
suggested approved edit on How do I find PostgreSQL's data directory?