postgres database disk issue I have a postgres database running on my application, and the postgres partition is 100% full. Upon checking the files in pgdata directory is see below files occupying lot of space.

smsstoregt1 ins /postgres/pgdata/base/16384&gt; du -skh * | grep -i M
589M    16400
244M    16405


Please can anyone suggest how to cleanup the space and if we can move the files 16400 and 16405 to another path or delete them, or if we can purge any data from postgres database from DB login.

Below is my postgres partition

/dev/mapper/mpath0p1  939M  900M     0 100% /postgres
You can create a new tablespace on a different disk and then move those tables to that new tablespace. 

First create a new table space on a disk that has enough space:

create tablespace large_disk 
   location '/path/to/directory/with/more/space'
   owner your_postgres_user;


By making your_postgres_user the owner of that tablespace, the user automatically gets all privileges on that tablespace. 

Then you need to find out to which tables those files belong to:

select 16400::regclass, 16405::regclass;


Then move the tables:

alter table public.table_one
    set tablespace large_disk;

alter table public.table_two
    set tablespace large_disk;