Re: pgsql: Add parallel-aware hash joins.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pgsql: Add parallel-aware hash joins.
Дата
Msg-id 21339.1516633310@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pgsql: Add parallel-aware hash joins.  (Thomas Munro <thomas.munro@enterprisedb.com>)
Ответы Re: pgsql: Add parallel-aware hash joins.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-committers
Thomas Munro <thomas.munro@enterprisedb.com> writes:
> On Mon, Jan 22, 2018 at 11:17 PM, Thomas Munro
> <thomas.munro@enterprisedb.com> wrote:
>> It looks to me like longfin's average and
>> variation increased half way between fa330f9a and 18042840, somewhere
>> near Dec 7 to 9, when we went from ~40s +/- 1 to ~50s with several
>> seconds' variation.  Was there some other environmental change then on
>> that machine?

> Ahh.  That corresponds to the release of this patch:
> https://support.apple.com/en-nz/HT208331

Yeah, I'm pretty sure that I installed that update immediately when
it came out.

There were some other strange things going on on that machine too;
I remember having noticed and killed a daemon process that seemed to be
stuck at 100% CPU.  That might explain the sudden dropoff in runtimes in
early January.  And seeing that the times seem to be back up, I looked
just now, and there it is again:

PID    COMMAND      %CPU TIME     #TH   #WQ  #PORT MEM    PURG   CMPRS  PGRP
360    fontworker   75.9 238 hrs  4     4    45-   28M    0B     0B     360
359    fontd        25.3 86:18:50 4/1   3/1  74    33M+   0B     1396K  359
76     logd         12.7 26:25:16 5     5    611   31M-   0B     0B     76
46241  top          2.6  00:01.04 1/1   0    23    2140K  0B     0B     46241

Weird --- my other macOS machines aren't doing that.

Anyway, it looks like we should write off these longfin timings as
ambient noise :-(

            regards, tom lane


В списке pgsql-committers по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: pgsql: Transaction control in PL procedures
Следующее
От: Tom Lane
Дата:
Сообщение: pgsql: Make pg_dump's ACL, sec label,and comment entries reliably iden