From: | Igor Neyman <ineyman(at)perceptron(dot)com> |
---|---|
To: | "Henrik Cednert (Filmlance)" <henrik(dot)cednert(at)filmlance(dot)se>, "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org> |
Subject: | RE: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade |
Date: | 2017-11-21 16:57:30 |
Message-ID: | CY1PR17MB0458CCD58564A78023E04EAADA230@CY1PR17MB0458.namprd17.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
From: Henrik Cednert (Filmlance) [mailto:henrik(dot)cednert(at)filmlance(dot)se]
Sent: Tuesday, November 21, 2017 11:48 AM
To: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade
I VACUUM every sunday so that is done already. =/
Not sure I have the proper params though since I'm not used to db's but have followed other's "how to's", but these are the lines in my script for that;
${BINARY_PATH}/vacuumdb --analyze --host=localhost --username=postgres --echo --verbose --no-password ${database} | tee -a ${log_pg_optimize}_${database}.log
${BINARY_PATH}/reindexdb --host=localhost --username=postgres --no-password --echo ${database} | tee -a ${log_pg_optimize}_${database}.log
--
Henrik Cednert
cto | compositor
Filmlance International
mobile [ + 46 (0)704 71 89 54 ]
skype [ cednert ]
_______________________________________________________________________________________________
To do vacuum full you need to add –full option to your vacuumdb command:
${BINARY_PATH}/vacuumdb --full --analyze --host=localhost --username=postgres --echo --verbose --no-password ${database} | tee -a ${log_pg_optimize}_${database}.log
Just be aware that “vacuum full” locks tables unlike just analyze”. So, like I said, no other acivity during this process.
Regards,
Igor
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2017-11-21 17:01:27 | Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade |
Previous Message | Henrik Cednert (Filmlance) | 2017-11-21 16:48:07 | Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade |