From: | Patrik Kudo <kudo(at)pingpong(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Two large files instead of one? |
Date: | 2002-08-28 09:43:50 |
Message-ID: | 3D6C9B56.70003@pingpong.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi!
I have a database in production with a lot of large objects happening. A
while ago we noticed that the database directory contained two files
with the name of the pg_largeobject oid, of which one had the sufix
".1". Is this a valid file? Is the table paged when reaching a certain
size or is it some kind of lost transaction/sort file? I noticed that
the timestamp of the file both are from today so I guess they should
both be there... I just want to make sure =)
More info:
select version();
version
---------------------------------------------------------------------
PostgreSQL 7.2.1 on i386-portbld-freebsd4.4, compiled by GCC 2.95.3
select relname from pg_class where oid = 16404;
relname
----------------
pg_largeobject
# ls -l|sort +4 -n |tail -n2
-rw------- 1 pgsql pgsql 465461248 Aug 28 09:20 16404.1
-rw------- 1 pgsql pgsql 1073741824 Aug 28 01:08 16404
Any info appreciated.
Best regards,
Patrik Kudo
From | Date | Subject | |
---|---|---|---|
Next Message | Juan Garcia Garcia | 2002-08-28 09:45:21 | Configuring field length behaviour |
Previous Message | Martijn van Oosterhout | 2002-08-28 09:12:58 | Re: Data files became huge with no apparent reason |