>>> On Tue, Jun 24, 2008 at 4:54 PM, in message <[EMAIL PROTECTED]>, Tom Lane <[EMAIL PROTECTED]> wrote: > "Jeffrey Baker" <[EMAIL PROTECTED]> writes: >> Creating the table in this case takes half an >> hour and then indexing it requires almost an hour. > > These numbers seem to me to be pretty strong evidence that > maintenance_work_mem = 1GB is a mistake. Try it at 100MB and then some > intermediate values. > > Now, *why* it is a mistake is interesting to speculate about, but > let's confirm the theory first. Could this be related to hint bit rewrites during indexing? Would a vacuum between creation and indexing be a good way to tell? -Kevin
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
