pgtune icon indicating copy to clipboard operation
pgtune copied to clipboard

support for postgresql 9.2, 9.3 and 9.4

Open ssbarnea opened this issue 9 years ago • 10 comments

While pgtune is a really valuable tool it seems that it getting behind postgresql versions.

ssbarnea avatar Aug 11 '15 12:08 ssbarnea

+1!

scottcc avatar Aug 27 '15 19:08 scottcc

+1

lynchc avatar Aug 28 '15 00:08 lynchc

:+1:

ei-grad avatar Sep 01 '15 00:09 ei-grad

:+1:

agb80 avatar Sep 02 '15 02:09 agb80

+1

emerson-h avatar Sep 03 '15 18:09 emerson-h

+1

vultron81 avatar Oct 15 '15 20:10 vultron81

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.

mcmd1962 avatar Dec 31 '15 12:12 mcmd1962

+1

ColonelBundy avatar Jan 03 '16 03:01 ColonelBundy

+1 for TS

skvskv avatar Apr 06 '16 14:04 skvskv

The web version seems to be more up-to-date: http://pgtune.leopard.in.ua/

deric avatar Apr 18 '16 15:04 deric