pg_dump index creation order

From: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
To: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: pg_dump index creation order
Date: 2006-05-07 01:15:55
Message-ID: 200605061915.55712.pgsql@bluepolka.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

I'm watching a long, painfully slow 60GB load from pg_dump
(8.1.2), and noticing it's jumping back and forth from different
tables. I assume this is the index creation order showing up.

Would it make more sense to have pg_dump dump indexes grouped by
the table? That way, if a table got loaded into cache for one
index creation, it might still be there for the immediatly
following index creations on the same table...

Ed

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Ed L. 2006-05-07 03:09:20 Re: pg_dump index creation order
Previous Message mcelroy, tim 2006-05-06 14:53:54 Re: Memory and/or cache issues?