Re: Increased size of database dump even though LESS consumed storage

Поиск
Список
Период
Сортировка
От Francisco Olarte
Тема Re: Increased size of database dump even though LESS consumed storage
Дата
Msg-id CA+bJJbxVErKGidwdMM=D-JAr1ApGtVqGdqEhi8B9HHrBZPaD_g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Increased size of database dump even though LESS consumed storage  (Thorsten Schöning<tschoening@am-soft.de>)
Список pgsql-general
Thorsten:

On Wed, Feb 10, 2021 at 12:46 PM Thorsten Schöning
<tschoening@am-soft.de> wrote:
....
UUppzz, completely missed the second message.

> > CREATE INDEX idx_datagram_for_time_window ON datagram USING btree (src_meter, captured_at DESC);

Depending on the query and data "shape", this may be chosen or not for
queries. You should be the one more probable to know it.

Francisco Olarte.



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

Предыдущее
От: Francisco Olarte
Дата:
Сообщение: Re: Increased size of database dump even though LESS consumed storage
Следующее
От: Thorsten Schöning
Дата:
Сообщение: Re: Increased size of database dump even though LESS consumed storage