Skip site navigation (1) Skip section navigation (2)

Re: extending relations more efficiently

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 (view raw or flat)
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

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2012-05-01 20:43:23
Subject: Re: port _srv.o makefile rules don't observe dependency tracking
Previous:From: Bruce MomjianDate: 2012-05-01 20:39:32
Subject: Re: remove dead ports?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group