Re: Increased size of database dump even though LESS consumed storage - Mailing list 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.