Re: [GENERAL] Large data and slow queries

Поиск
Список
Период
Сортировка
От Samuel Williams
Тема Re: [GENERAL] Large data and slow queries
Дата
Msg-id CAHkN8V_j=Lzgr8gbxqrF+h3EP0O-ac9-LRAB_T2muQQfPtPKJQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] Large data and slow queries  ("Martijn Tonies \(Upscene Productions\)" <m.tonies@upscene.com>)
Список pgsql-general
Martijn that is a good question. It's because we are only concerned
with a subset of events for this index and this particular query. The
query planner can recognise this and use the index correctly. By doing
this, we reduce the size of the index significantly. In the best case,
where we only wanted a few things, the index was reduced from 21GB to
8MB.


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

Предыдущее
От: "Martijn Tonies \(Upscene Productions\)"
Дата:
Сообщение: Re: [GENERAL] Large data and slow queries
Следующее
От: vinny
Дата:
Сообщение: Re: [GENERAL] Large data and slow queries