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

From: Francisco Olarte <folarte(at)peoplecall(dot)com>
To: Thorsten Schöning <tschoening(at)am-soft(dot)de>
Cc: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Increased size of database dump even though LESS consumed storage
Date: 2021-02-10 12:34:31
Message-ID: CA+bJJbxVErKGidwdMM=D-JAr1ApGtVqGdqEhi8B9HHrBZPaD_g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thorsten:

On Wed, Feb 10, 2021 at 12:46 PM Thorsten Schöning
<tschoening(at)am-soft(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thorsten Schöning 2021-02-10 13:47:27 Re: Increased size of database dump even though LESS consumed storage
Previous Message Francisco Olarte 2021-02-10 12:30:43 Re: Increased size of database dump even though LESS consumed storage