| From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
|---|---|
| To: | Stephen Frost <sfrost(at)snowman(dot)net> |
| Cc: | Andres Freund <andres(at)anarazel(dot)de>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: extending relations more efficiently |
| Date: | 2012-05-01 20:39:42 |
| Message-ID: | CA+TgmoYpVpMTmsHuttu3NVYwfcR4SvJuMi7SnS65LZbsx9niqg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2012-05-01 20:43:23 | Re: port _srv.o makefile rules don't observe dependency tracking |
| Previous Message | Bruce Momjian | 2012-05-01 20:39:32 | Re: remove dead ports? |