pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Carlo Stonebanks <stonec.register@sympatico.ca>
To: 'Jeff Janes' <jeff.janes@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Are bitmap index scans slow to start?
Date: Thu, 28 Feb 2013 00:12:48 -0500
Message-ID: <024301ce1572$3fea5560$bfbf0020$@sympatico.ca> (raw)
In-Reply-To: <CAMkU=1zRqJ6Bn08KiN8vLBoVj14W5xXM7aJLgz+QZwLC0ZRbJQ@mail.gmail.com>
References: <005701ce0fb5$6f841f30$4e8c5d90$@sympatico.ca>
	<001501ce1054$7b518380$71f48a80$@sympatico.ca>
	<CAMkU=1yG884Nak4zPoNHwDGpC7w2nrKH6_xztPw4b7P9am0wdg@mail.gmail.com>
	<B6F6FD62F2624C4C9916AC0175D56D8801B17F@jenmbs01.ad.intershop.net>
	<006201ce1125$2c554150$84ffc3f0$@sympatico.ca>
	<CAPmjWd1On_uAp6suqYoHuh3ksKD0xn6tOhOM_Z2vaweO-vexSA@mail.gmail.com>
	<009001ce1137$f9c31bf0$ed4953d0$@sympatico.ca>
	<CAMkU=1z-UOitt2mtnjn=XQ8kk2cL2nAnd2MfycLwju__qC49wQ@mail.gmail.com>
	<010601ce137a$266b7f00$73427d00$@sympatico.ca>
	<CAMkU=1wc1uMsx5viu6NHU=LFn3q_AjwUWE0y6vuCN=eYKZ+eAg@mail.gmail.com>
	<01a601ce1482$07142db0$153c8910$@sympatico.ca>
	<CAMkU=1zRqJ6Bn08KiN8vLBoVj14W5xXM7aJLgz+QZwLC0ZRbJQ@mail.gmail.com>
List-Unsubscribe:  <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>

<< 

I had thought you were saying that any one ETL procedure into one database
used 14 concurrent threads.  But really, each ETL procedure is
single-threaded, and there can be up to 5 (or theoretically up to 14) of
them running at a time into different databases?
>>

 

Sorry, just caught this. 

 

Your first interpretation was correct. Each DB runs an ETL that can have up
to 14 concurrent threads. I don't think the number should be that high, but
the engineering team insists the load time is better than fewer threads
running faster.

view thread (20+ messages)  latest in thread

Message-ID: <024301ce1572$3fea5560$bfbf0020$@sympatico.ca>
Permalink:  ../024301ce1572$3fea5560$bfbf0020$@sympatico.ca/
Also on:    postgresql.org/message-id/024301ce1572$3fea5560$bfbf0020$@sympatico.ca

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: stonec.register@sympatico.ca, jeff.janes@gmail.com
  Subject: Re: Are bitmap index scans slow to start?
  In-Reply-To: <024301ce1572$3fea5560$bfbf0020$@sympatico.ca>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox