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.)
On 12/9/18 5:51 AM, Andrew Dunstan wrote:
On 12/8/18 6:38 PM, Andres Freund wrote:
On 2018-12-08 15:23:19 -0800, Rob Sargent wrote:
On Dec 8, 2018, at 3:12 PM, Andres Freund wrote:
On 2018-12-08 12:06:23 -0800, Jeremy Schneider wrote:
On RDS PostgreSQL, the default is 25% of your server
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
On 12/8/18 6:38 PM, Andres Freund wrote:
On 2018-12-08 15:23:19 -0800, Rob Sargent wrote:
On Dec 8, 2018, at 3:12 PM, Andres Freund wrote:
On 2018-12-08 12:06:23 -0800, Jeremy Schneider wrote:
On RDS PostgreSQL, the default is 25% of your server memory. This seems
to be pretty widely acce