From: | "Simon Riggs" <simon(at)2ndquadrant(dot)com> |
---|---|
To: | <pgsql-hackers(at)postgresql(dot)org> |
Subject: | pg_dump ANALYZE statements |
Date: | 2007-01-22 15:40:17 |
Message-ID: | 1169480417.3776.324.camel@silverbirch.site |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
There is currently a performance tip to run ANALYZE after a pg_dump
script has been restored.
ISTM that pg_dump should default to have ANALYZE statements for a table,
when both table definition and data are dumped. If only data (-a) or
only table definition (-s) is dumped the default should be to *not* add
an ANALYZE statement.
There doesn't seem to be any reason to skip the ANALYZE, but I'll
implement it as an option.
-z on | off
--analyze=on | off
This would add a table-specific ANALYZE statement following each table's
actions.
I'm not aware of a strong argument against such an option. Performance
surely can't be one because the time saved on the ANALYZE will quickly
bite back on time lost on poorly planned queries.
What does the panel think?
--
Simon Riggs
EnterpriseDB http://www.enterprisedb.com
From | Date | Subject | |
---|---|---|---|
Next Message | Merlin Moncure | 2007-01-22 15:40:37 | Re: savepoint improvements |
Previous Message | Bruce Momjian | 2007-01-22 15:30:09 | Re: [HACKERS] Autovacuum Improvements |