Postgres docs / Indexes
Examples from the Postgres docs are used
anticipate
предвидеть
Пример
It is the task of the author to anticipate the items that readers are likely to look up.
no further intervention
никакого дальнейшего вмешательства
Пример
Once an index is created, no further intervention is required.
substantially
существенно
Пример
A long running query like that will already increase the load on your server quite substantially.
show up
появляться
Пример
All these tokens will show up in the index as you will see later on.
redundant
избыточный
Пример
In single-column indexes the options are indeed redundant.
tremendous speedups
огромные ускорения
Пример
Sometimes they can produce tremendous speedups for certain queries.
observe that
обратите внимание, что
Пример
Observe that this kind of partial index requires that the common values be predetermined.
occasionally
время от времени
Пример
The indexes can be recreated occasionally to adjust for new data distributions, but this adds maintenance effort.
take up
занимать
Пример
Unbilled orders take up a small fraction of the total table.
so long as only
если задействованы только
Пример
It supports partial indexes with arbitrary predicates, so long as only columns of the table being indexed are involved.
takes place
происходит
Пример
Matching takes place at query planning time, not at run time.
laboriously
кропотливо
Пример
The problem is that the system will laboriously test each one to see if it's applicable to the current query.
sufficient
достаточный
Пример
In practice the default operator class for the column's data type is usually sufficient.
besides
помимо
Пример
There are also some built-in operator classes besides the default ones.
alleviate
облегчить
Пример
Bitmap scans try to alleviate this cost by doing the heap accesses in sorted order.
Смотрите любимых YouTube-блогеров и учите по ним английский
Englika позволяет быстро выучить английский язык, просматривая любимые YouTube-ролики с носителями языка. 🇬🇧Проходя разнообразные задания, вы научитесь понимать английскую речь на слух и стремительно расширите свой словарный запас.