Bruce Momjian <br...@momjian.us> wrote: >>>> cir=# analyze "CaseHist"; >>>> ANALYZE >>>> Time: 143450.467 ms > OK, so a single 44GB tables took 2.5 minutes to analyze; that is > not good. It would require 11 such tables to reach 500GB (0.5 > TB), and would take 27 minutes. The report I had was twice as > long, but still in the ballpark of "too long". :-( We have a sister machine to the one used for that benchmark -- same hardware and database. The cost limit didn't seem to make much difference: cir=# set vacuum_cost_delay = 0; SET cir=# \timing on Timing is on. cir=# analyze "CaseHist" ; ANALYZE Time: 146169.728 ms So it really does seem to take that long. -Kevin
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
