pgtune
pgtune copied to clipboard
support for postgresql 9.2, 9.3 and 9.4
While pgtune is a really valuable tool it seems that it getting behind postgresql versions.
+1!
+1
:+1:
:+1:
+1
+1
It is possible to generate yourself the pg_settings files for the newer pg versions. You can find this in the pgtune script:
Read and index a delimited text dump of a typical pg_settings dump for the appropriate architecture. Maximum values are different for some settings on 32 and 64 bit platforms.
An appropriately formatted dump can be generated with:
psql postgres -c "COPY (SELECT name,setting,unit,category,short_desc, extra_desc,context,vartype,min_val,max_val,enumvals,boot_val FROM pg_settings WHERE NOT source='override') TO '/
/pg_settings- - '" Note that some of these columns (such as boot_val) are only available␣ starting in PostgreSQL 8.4
The settings file seems primarily needed for getting info on the used units for a specific attribute.
+1
+1 for TS
The web version seems to be more up-to-date: http://pgtune.leopard.in.ua/