Re: what's the slowest part in the SQL

Поиск
Список
Период
Сортировка
От Claudio Freire
Тема Re: what's the slowest part in the SQL
Дата
Msg-id CAGTBQpb5B3FYdV1M=gHkFZjb2HQQzuEDtDBC92g7eSVg_yHfew@mail.gmail.com
обсуждение исходный текст
Ответ на Re: what's the slowest part in the SQL  (Suya Huang <shuang@connexity.com>)
Список pgsql-performance
On Tue, Aug 9, 2016 at 10:46 PM, Suya Huang <shuang@connexity.com> wrote:
> Hi Claudio,
>
> Here is the index definition
>     "idx_data_3" gin (name gin_trgm_ops), tablespace "tbs_data"
>     "idx_data_4" gin (displayname gin_trgm_ops), tablespace "tbs_data"


GIN indexes are quite big, they can be bigger than the data. Check
their size, it's possible that you can't fit data + indexes on those
2GB.

But if prod is going to be bigger, prehaps it's a non-issue for you?


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

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: Logging queries using sequential scans
Следующее
От: Andrey Zhidenkov
Дата:
Сообщение: Planner do seq scan on empty master partitioned table