Re: extending relations more efficiently

On Tue, May 1, 2012 at 3:48 PM, Stephen Frost <sfrost@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