View Single Post

   
  #2 (permalink)  
Old 04-12-2008, 06:33 AM
Tom Lane
 
Posts: n/a
Default Re: pg_dump ANALYZE statements

"Simon Riggs" <simon@2ndquadrant.com> writes:
> 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.


Having pg_dump emit ANALYZE was discussed and rejected years ago.
Have you read that discussion? Do you have any new arguments to make?

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply With Quote