On Tue, May 1, 2012 at 3:48 PM, Stephen Frost <sfrost(at)snowman(dot)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
> 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?
The Enterprise PostgreSQL Company
In response to
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2012-05-01 20:43:23|
|Subject: Re: port _srv.o makefile rules don't observe dependency tracking |
|Previous:||From: Bruce Momjian||Date: 2012-05-01 20:39:32|
|Subject: Re: remove dead ports?|