On Tue, May 1, 2012 at 3:48 PM, Stephen Frost <sfr...@snowman.net> wrote: > Try loading the TIGER 2011 data into a single table, where you load each > county (or perhaps state) in a separate, parallel, process. That's what > I was doing when I hit this lock full-force and bitched about it on this > list. > > I'd be happy to help construct that case, as well as test any changes in > this area which might help address it (on a 10G SSD-backed SAN..).
Hmm, can you ship me one of those 10G SSD-backed SANs? That'd be awesome. In all seriousness, this is not a great test case unless you can provide some scripts to make it easy to run it in a reproducible fashion. Can you? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers