On 19 March 2018 17:31:20 CET, Jimmy Augustine <jimmy.augustine@xxxxxxx> wrote: >Dear Friends, > >I am newbie to postgresql. >I have 162 GB on my database but when I check size of all tables, I >approximately obtain 80 GB. Indexes? >I also see that I have 68GB of temporary files however I only found Where can you see that? >2.4MB >at postgres/data/base/pgsql_tmp. > >Could you tell me what are those temporary files and where are they at? >Can >I delete some of them? No, never delete files in datadir! > >All values come from pgAdmin 4 and checked by my own SQL >queries(postgresql-9.6). >I already run vacuum full and there is few dead tuples. A few dead tuples arn't a real problem. > >Best regards, >Jimmy AUGUSTINE -- 2ndQuadrant - The PostgreSQL Support Company
