Re: Faster inserts with mostly-monotonically increasing values

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: Faster inserts with mostly-monotonically increasing values
Дата
Msg-id CAA8=A79iXsuiB822MUhaG=ss02XP8VeC6OafcFR=ZEt4oao_Aw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Faster inserts with mostly-monotonically increasing values  (Pavan Deolasee <pavan.deolasee@gmail.com>)
Ответы Re: Faster inserts with mostly-monotonically increasing values  (Pavan Deolasee <pavan.deolasee@gmail.com>)
Список pgsql-hackers
On Fri, Mar 23, 2018 at 8:27 PM, Pavan Deolasee
<pavan.deolasee@gmail.com> wrote:
>>
>>
>> I would probably just have a few regression lines that should be sure
>> to exercise the code path and leave it at that.
>>
>
> I changed the regression tests to include a few more scenarios, basically
> using multi-column indexes in different ways and they querying rows by
> ordering rows in different ways. I did not take away the vacuum and I
> believe it will actually help the tests by introducing some fuzziness in the
> tests i.e. if the vacuum does not do its job, we might execute a different
> plan and ensure that the output remains unchanged.
>


If we're going to keep the vacuums in there, do we need to add a wait
barrier like Claudio suggested upthread?

Once we decide on that I propose to commit this.

cheers

andrew

-- 
Andrew Dunstan                https://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


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

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: WIP: Covering + unique indexes.
Следующее
От: "MauMau"
Дата:
Сообщение: Re: Changing default value of wal_sync_method to open_datasync on Linux