Re: Simple join optimized badly? - Mailing list pgsql-performance

From Chris Browne
Subject Re: Simple join optimized badly?
Date
Msg-id 60hcye8ab1.fsf@dba2.int.libertyrms.com
Whole thread Raw
In response to Simple join optimized badly?  ("Craig A. James" <cjames@modgraph-usa.com>)
List pgsql-performance
tgl@sss.pgh.pa.us (Tom Lane) writes:
> Another thing we've been beat up about in the past is that loading a
> pg_dump script doesn't ANALYZE the data afterward...

Do I misrecall, or were there not plans (circa 7.4...) to for pg_dump
to have an option to do an ANALYZE at the end?

I seem to remember some dispute as to whether the default should be to
include the ANALYZE, with an option to suppress it, or the opposite...
--
(reverse (concatenate 'string "ofni.sesabatadxunil" "@" "enworbbc"))
http://www3.sympatico.ca/cbbrowne/wp.html
"You can measure a programmer's perspective by noting his attitude on
the continuing vitality of FORTRAN." -- Alan J. Perlis

pgsql-performance by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Performance Optimization for Dummies 2 - the SQL
Next
From: Mark Kirkwood
Date:
Subject: Re: Simple join optimized badly?