Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vT8fs-00DvCd-2O for pgsql-bugs@arkaria.postgresql.org; Wed, 10 Dec 2025 01:07:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vT8fr-008wok-16 for pgsql-bugs@arkaria.postgresql.org; Wed, 10 Dec 2025 01:07:23 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vT8fr-008woc-0F for pgsql-bugs@lists.postgresql.org; Wed, 10 Dec 2025 01:07:23 +0000 Received: from mail-pl1-x62b.google.com ([2607:f8b0:4864:20::62b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vT8fp-0042tq-26 for pgsql-bugs@lists.postgresql.org; Wed, 10 Dec 2025 01:07:22 +0000 Received: by mail-pl1-x62b.google.com with SMTP id d9443c01a7336-29d7b019e0eso70432125ad.2 for ; Tue, 09 Dec 2025 17:07:21 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1765328840; x=1765933640; darn=lists.postgresql.org; h=references:to:cc:in-reply-to:date:subject:mime-version:message-id :from:from:to:cc:subject:date:message-id:reply-to; bh=N+veVBpPvhNS4rONBT1uWN/g0sse3AhDDw69JoJkvA0=; b=VX8xWJge/tOS+k/R/VyuLXluK1MrPc+kQClvZTDDwHcZCJa6hAiAKeJTLW9CMMZQGp DHhUVCcOonykc5m7qTvS2AtY4pTu8qx3X48q/9aN1kUfRkdeeQftIAa+ZXXlOBmjS9W5 BS6j/FBwNPmnWzla5+a4TbXafm0hLwnnxp5KLm1wyq0gcNAiaocrcIOeJ6V/n2MfiR6R ILNNYlq3TTlSn8zBGEswECU+YFGXCwrfycn6XBceOhgyGADeliKwyq2V0JMBv+7B9lE4 fb2NcYETLxqCQF/sv/dWDYrt6sSzCmyOHw41YSOh1N9rd39k5HKyDMChSDOsSgrRr0hs XdMA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1765328840; x=1765933640; h=references:to:cc:in-reply-to:date:subject:mime-version:message-id :from:x-gm-gg:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=N+veVBpPvhNS4rONBT1uWN/g0sse3AhDDw69JoJkvA0=; b=nZjQAx+el4UNfJHOlR74WGJ+bVtC0Ci/M33YtvLDArXEkiTXHI42nY/g2dtDOnV1mz t+FSkflFmd9i/C9IQXeSxPcIlfqE2Pr9asvl2SP3wdlAnlgw/pOEFM3pTnRPsHGfLeRr Tg+wq6NHN324pTwJybJGFV+VVJribsKDjCBv/9H/lgfJzqL7lkuOZ84UWxK8Mu6KfcyV L6ArBdvw/A4EciIR/3cI/8p3Rlrb+55pfzuoVgn9UVahNTTL8mPbf0YdfJMrAlljQ0Fe dqsc6gqTEnu+Iyi6gSqbO7+C1YtjMsKLnOHn8eCosmv99PAZnd4AYI/lUV+9rlU6z+p1 4U+A== X-Gm-Message-State: AOJu0YzUKPB3ROQapCiqSFUV8p8NYCyZGmlvY+Dx8mKmHmqS9aTOl5ij p2kT83jAgTh/Cyro6ZkTYh6E5bn7UTBr+RNth+BKBalBST/cLFR4LsU0 X-Gm-Gg: AY/fxX7fDq/fwhH4DPHn//LmLNqw6ld7bqL8OLLsweHh9O9+Uk+lqZLK1GQhzu44Uda A0b8Yb1XIH19etrAKce9lTGqUwoArNb9bpTAcOHUEg3ehFhfHzouHBg6MXwff8QuCzH4d3UJXDV beqb1iVcNH9EdhwW2P5R3LUaYLyY55d5joccBx0h9IERpjpgRlt6fCaJ+6E9gT7DtfiJ8ogtrv/ ZzWQ8K7Oj4aQVEh634jIPmcnEqKez84wn84/tz30sZhRKATlLT2PEGmLDx9WmQPEHGbLD1NOJzU 7vnHv0BhLq6aP7P+s9EL4vdmlpf+QOBDOZ4pvwfSs3sr5wPrBuBOoVCLurDsEX+7uZb2B2bA81u mCvCGD5GOJFZJUNogcXSP0+mAktsZdHU0qdhzzsHvWBMjUprBsGhwW86Z3tFD6thSfZVBsHtuou Yv9VMAtgpAAOopsrhd9IPluVFj+NzUCQEKt+Y= X-Google-Smtp-Source: AGHT+IHBpvnu77aAsWhUqQKa6J3y3LE2f4KQuX4rFEFZBc28kmOIYoZsaXDLWKk7Qv6vU3Vy332s+Q== X-Received: by 2002:a17:902:ef0b:b0:295:f47:75cb with SMTP id d9443c01a7336-29ec231b2dbmr6532965ad.23.1765328840465; Tue, 09 Dec 2025 17:07:20 -0800 (PST) Received: from smtpclient.apple ([203.90.233.89]) by smtp.gmail.com with ESMTPSA id d9443c01a7336-29dae4cfcfasm162020735ad.41.2025.12.09.17.07.19 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Tue, 09 Dec 2025 17:07:19 -0800 (PST) From: weijie JL Message-Id: <12FAFDB8-3BEF-4DD3-8B37-073ACA40C9CB@gmail.com> Content-Type: multipart/alternative; boundary="Apple-Mail=_56C76899-7624-474E-92A2-8DEBF1A0A14B" Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3864.200.81.1.6\)) Subject: Re: BUG #19348: Disk space error when running COPY after upgrading to PostgreSQL 17.7 Date: Wed, 10 Dec 2025 09:07:07 +0800 In-Reply-To: Cc: pgsql-bugs@lists.postgresql.org To: Greg Sabino Mullane References: <19348-7b32e6a211170952@postgresql.org> X-Mailer: Apple Mail (2.3864.200.81.1.6) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Apple-Mail=_56C76899-7624-474E-92A2-8DEBF1A0A14B Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 [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=E5=B9=B412=E6=9C=889=E6=97=A5 22:28=EF=BC=8CGreg Sabino Mullane = =E5=86=99=E9=81=93=EF=BC=9A >=20 > Try a df -hi to check on your inode usage. >=20 > =20 > Cheers, > Greg >=20 > -- > Crunchy Data - https://www.crunchydata.com = > Enterprise Postgres Software Products & Tech Support >=20 --Apple-Mail=_56C76899-7624-474E-92A2-8DEBF1A0A14B Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8
[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=E5=B9=B412=E6=9C=889=E6=97=A5 22:28=EF=BC=8CGreg = Sabino Mullane <htamfids@gmail.com> =E5=86=99=E9=81=93=EF=BC=9A
Try a df -hi to check on your inode usage.

 
Cheers,
Greg

--
<= div>Crunchy Data - https://www.crunchydata.com
Enterprise = Postgres Software Products & Tech = Support


= --Apple-Mail=_56C76899-7624-474E-92A2-8DEBF1A0A14B--