Re: Re: getting the most of out multi-core systems for repeated complex SELECT statements - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: Re: getting the most of out multi-core systems for repeated complex SELECT statements
Date
Msg-id AANLkTi=fJVDEa4ZewLLNSpnHP1UgeUeVJgtAMt03Ud3k@mail.gmail.com
Whole thread Raw
In response to Re: getting the most of out multi-core systems for repeated complex SELECT statements  (Mark Stosberg <mark@summersault.com>)
List pgsql-performance
On Fri, Feb 4, 2011 at 2:18 PM, Mark Stosberg <mark@summersault.com> wrote:
> It looks like it's going to be trivial-- Divide up the data with a
> modulo, and run multiple parallel cron scripts that each processes a
> slice of the data. A benchmark showed that this approach sped up our
> processing 3x when splitting the application 4 ways across 4 processors.
> (I think we failed to achieve a 4x improvement because the server was
> already busy handling some other tasks).

I once had about 2 months of machine work ahead of me for one server.
Luckily it was easy to break up into chunks and run it on all the
workstations at night in the office, and we were done in < 1 week.
pgsql was the data store for it, and it was just like what you're
talking about, break it into chunks, spread it around.

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: checkpoint_completion_target and Ext3
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Slow count(*) again...