Re: running out of disk space

Alan, thanks for your reply.

So, we currently have this situation:

/dev/sda1             2.7T  2.4T  298G  90% /data/vol1

/dev/sdb2             2.7T  2.4T  296G  89% /data/vol2

/dev/mapper/vg00-data

                       16T   16T  373G  98% /data/vol3

postgres=# SELECT * FROM pg_tablespace;

  spcname   | spcowner | spclocation |              spcacl              

------------+----------+-------------+-----------------------------------

 pg_default |       10 |             |

 pg_global  |       10 |             |

 vol1       |       10 | /data/vol1  | {postgres=C/postgres,=C/postgres}

 vol2       |       10 | /data/vol2  | {postgres=C/postgres,=C/postgres}

 vol3       |       10 | /data/vol3  | {postgres=C/postgres,=C/postgres}

(5 rows)

And we added new volume yday:

/dev/mapper/vg00-vol4
                      4.0T  195M  3.8T   1% /data/vol4

So, if I understood you correctly, it is better to extend vol3 instead of creating new tablespace on vol4 (if possible).

If not, then what is my best bet?