Re: HELP? Postgres filling up disk

HT Levine <htlevine(at)ebates(dot)com> writes:
> For example, here is the oid2name dump of a table called users on
> PRODUCTION:
> $ oid2name -d EBPRD1 -t users
> Oid of table users from database "EBPRD1":
> _______________________________
> 17260 = users
> $ ls -l 17260*
> -rw------- 1 postgres postgres 1073741824 Dec 18 17:48 17260
> -rw------- 1 postgres postgres 1073741824 Dec 18 17:48 17260.1
> -rw------- 1 postgres postgres 1073741824 Dec 18 17:48 17260.2
> -rw------- 1 postgres postgres 165445632 Dec 18 17:51 17260.3

> but the same table on the standby DB yields this:

> $ oid2name -d EBPRDS1 -t users
> Oid of table users from database "EBPRDS1":
> _______________________________
> 3828262123 = users
> $ ls -l 3828262123
> -rw------- 1 postgres postgres 1073741824 Dec 18 16:55 3828262123

And? Your transcript does not prove that there's not 3828262123.1 and
so forth ... given that 3828262123 is a full 1Gb, I'd be willing to bet
lunch that 3828262123.1 exists too ...

regards, tom lane