Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

support for postgresql 9.2, 9.3 and 9.4 #13

Open
ssbarnea opened this issue Aug 11, 2015 · 10 comments
Open

support for postgresql 9.2, 9.3 and 9.4 #13

ssbarnea opened this issue Aug 11, 2015 · 10 comments

Comments

@ssbarnea
Copy link

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

@scottcc
Copy link

scottcc commented Aug 27, 2015

+1!

@lynchc
Copy link

lynchc commented Aug 28, 2015

+1

4 similar comments
@ei-grad
Copy link

ei-grad commented Sep 1, 2015

👍

@agb80
Copy link

agb80 commented Sep 2, 2015

👍

@emerson-h
Copy link

+1

@vultron81
Copy link

+1

@mcmd1962
Copy link

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.

@ColonelBundy
Copy link

+1

@skvskv
Copy link

skvskv commented Apr 6, 2016

+1 for TS

@deric
Copy link

deric commented Apr 18, 2016

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests