Re: BUG #19348: Disk space error when running COPY after upgrading to PostgreSQL 17.7 - Mailing list pgsql-bugs

From weijie JL
Subject Re: BUG #19348: Disk space error when running COPY after upgrading to PostgreSQL 17.7
Date
Msg-id 12FAFDB8-3BEF-4DD3-8B37-073ACA40C9CB@gmail.com
Whole thread Raw
In response to Re: BUG #19348: Disk space error when running COPY after upgrading to PostgreSQL 17.7  (Greg Sabino Mullane <htamfids@gmail.com>)
List pgsql-bugs
[root@p-aps-d-002 ~]# df -hi
Filesystem              Inodes IUsed IFree IUse% Mounted on
devtmpfs                  126M  1016  126M    1% /dev
tmpfs                     126M    77  126M    1% /dev/shm
tmpfs                     126M  1.4K  126M    1% /run
tmpfs                     126M    17  126M    1% /sys/fs/cgroup
/dev/mapper/rl-root       103M   79K  103M    1% /
/dev/sda2                 512K    19  512K    1% /boot
/dev/sda1                    0     0     0     - /boot/efi
/dev/mapper/datavg-data   1.4G   29K  1.4G    1% /data
tmpfs                     126M     6  126M    1% /run/user/0
tmpfs                     126M     5  126M    1% /run/user/1001



2025年12月9日 22:28,Greg Sabino Mullane <htamfids@gmail.com> 写道:

Try a df -hi to check on your inode usage.

 
Cheers,
Greg

--
Enterprise Postgres Software Products & Tech Support


pgsql-bugs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: BUG #19095: Test if function exit() is used fail when linked static
Next
From: Richard Guo
Date:
Subject: Re: GROUP BY ROLLUP queries on views trigger full table scans (index usage not optimized)