running out of disk space

2019-05-09 Thread Julie Nishimura
hello, We are running out of disk space, and we introduced new volume to it. I am about to create new tablespace X and alter user databases to set to this new tablespace X. So, all new tables will be created in X, but what about existing tables on previous volume? Its data will be split between

Re: running out of disk space

2019-05-09 Thread Alan Hodgson
On Thu, 2019-05-09 at 15:46 +, Julie Nishimura wrote: > hello, > > We are running out of disk space, and we introduced new volume to it. > I am about to create new tablespace X and alter user databases to set > to this new tablespace X. So, all new tables will be created i

Re: running out of disk space

2019-05-09 Thread Julie Nishimura
extend vol3 instead of creating new tablespace on vol4 (if possible). If not, then what is my best bet? Thanks, Julie From: Alan Hodgson Sent: Thursday, May 9, 2019 9:15 AM To: Julie Nishimura; pgsql-general Subject: Re: running out of disk space On Thu, 2019-05

Re: running out of disk space

2019-05-09 Thread Alan Hodgson
On Thu, 2019-05-09 at 16:49 +, Julie Nishimura wrote: > 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 > > >