On Sun, Dec 09, 2018 at 10:01:08AM -0600, Justin Pryzby wrote:
> On Sun, Dec 09, 2018 at 05:18:55PM +0200, Mariel Cherkassky wrote:
> > I'm trying to understand why my database consume so much space. I checked
> > the space it consume on disk :
To find single relations which are using more than 10
On Sun, Dec 09, 2018 at 05:18:55PM +0200, Mariel Cherkassky wrote:
> I'm trying to understand why my database consume so much space. I checked
> the space it consume on disk :
This seems to be essentially the same question you asked last month, so should
either continue the existing thread or link
On Sun, Dec 9, 2018 at 10:19 AM Mariel Cherkassky <
mariel.cherkas...@gmail.com> wrote:
> Hi,
> I'm trying to understand why my database consume so much space. I checked
> the space it consume on disk :
>
>
Have you tried running pg_repack? (It is an extension.)
Hi,
I'm trying to understand why my database consume so much space. I checked
the space it consume on disk :
[root@ base]# du -sh * | sort -n
1.1T17312
5.2Gpgsql_tmp
6.3M1
6.3M12865
6.4M12870
119G17313
myBIGdb=# select t1.oid,t1.datname AS
db_name,pg_size_pretty(pg_databas