Re: [PERFORM] pg_dump index creation order

On Saturday May 6 2006 7:15 pm, Ed L. wrote: > 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 g

[PERFORM] pg_dump index creation order

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

Re: [PERFORM] Memory and/or cache issues?

Title: RE: [PERFORM] Memory and/or cache issues? Thank you again to all who have offered advice, suggestions, tips and offers of support/training.  From the gist of some of the latter posts I must come off as a rank rookie, lol.  Deservedly so as I've only been working with postgres for 7 mont