| From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
|---|---|
| To: | Dmitry Dolgov <9erthalion6(at)gmail(dot)com> |
| Cc: | Michael Paquier <michael(at)paquier(dot)xyz>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, James Coleman <jtc331(at)gmail(dot)com>, Pg Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: remove spurious CREATE INDEX CONCURRENTLY wait |
| Date: | 2020-11-16 20:35:54 |
| Message-ID: | 20201116203554.GA15547@alvherre.pgsql |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 2020-Nov-16, Dmitry Dolgov wrote:
> The same with reindex without locks:
>
> nsecs : count distribution
> 512 -> 1023 : 0 | |
> 1024 -> 2047 : 111345 | |
> 2048 -> 4095 : 6997627 |****************************************|
> 4096 -> 8191 : 18575 | |
> 8192 -> 16383 : 586 | |
> 16384 -> 32767 : 312 | |
> 32768 -> 65535 : 18 | |
>
> The same with reindex with locks:
>
> nsecs : count distribution
> 512 -> 1023 : 0 | |
> 1024 -> 2047 : 59438 | |
> 2048 -> 4095 : 6901187 |****************************************|
> 4096 -> 8191 : 18584 | |
> 8192 -> 16383 : 581 | |
> 16384 -> 32767 : 280 | |
> 32768 -> 65535 : 84 | |
>
> Looks like with reindex without locks is indeed faster (there are mode
> samples in lower time section), but not particularly significant to the
> whole distribution, especially taking into account extremity of the
> test.
I didn't analyze these numbers super carefully, but yeah it doesn't look
significant.
I'm looking at these patches now, with intention to push.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2020-11-16 20:52:31 | VACUUM (DISABLE_PAGE_SKIPPING on) |
| Previous Message | Jacob Champion | 2020-11-16 20:00:47 | Re: Support for NSS as a libpq TLS backend |