"Neuber, Dirk" writes:
> One last question. After using vacuumlo the file size of 16385/2613 is
> still the same as before.
> It seems the content has been removed but the file itself hasn't been
> compacted.
> Is there an option or tool which can do this as well ?
Yeah, you still need to apply V
> >> It is : postgres/8.3/main/base/16385/2613
>
> > This is a system catalog, pg_largeobject, which holds
> binary objects. If
> > you use Large Objects, no wonder this table could be really big.
>
> Also worth noting is that there's no automatic deletion mechanism for
> large objects. It coul
Guillaume Lelarge writes:
> Le 10/07/2010 12:43, Neuber, Dirk a écrit :
>>> The exact name of the file might be useful information, too.
>>
>> It is : postgres/8.3/main/base/16385/2613
> This is a system catalog, pg_largeobject, which holds binary objects. If
> you use Large Objects, no wonder t
Le 10/07/2010 12:43, Neuber, Dirk a écrit :
>>> What is it?
>
>> Why don't you tell us?
>
>> The exact name of the file might be useful information, too.
>
> It is : postgres/8.3/main/base/16385/2613
>
This is a system catalog, pg_largeobject, which holds binary objects. If
you use Large Objec
>> What is it?
> Why don't you tell us?
> The exact name of the file might be useful information, too.
It is : postgres/8.3/main/base/16385/2613
Thanks.
Ciao Dirk.
DISCLAIMER:
Unless indicated otherwise, the information contained in this message is
privileged and confidential, and is intend
On Fri, Jul 9, 2010 at 7:31 AM, Henry, Frank wrote:
> Hello everyone,
>
> We had a problem with one of our servers and had noticed that the
> postgres/8.3/main folder had become quite large (>650mb).
> PostgreSQL confirmed this via a query but when I queried the size of the
> tables I was barely r
On Fri, 2010-07-09 at 15:31 +0200, Henry, Frank wrote:
> Hello everyone,
>
> We had a problem with one of our servers and had noticed that the
> postgres/8.3/main folder had become quite large (>650mb).
> PostgreSQL confirmed this via a query but when I queried the size of the
> tables I was barel
Scott Marlowe writes:
> On Fri, Jul 9, 2010 at 7:31 AM, Henry, Frank wrote:
>> What is it?
> Why don't you tell us?
The exact name of the file might be useful information, too.
regards, tom lane
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make
On Fri, Jul 9, 2010 at 7:31 AM, Henry, Frank wrote:
> Hello everyone,
>
> We had a problem with one of our servers and had noticed that the
> postgres/8.3/main folder had become quite large (>650mb).
> PostgreSQL confirmed this via a query but when I queried the size of the
> tables I was barely r
Hello everyone,
We had a problem with one of our servers and had noticed that the
postgres/8.3/main folder had become quite large (>650mb).
PostgreSQL confirmed this via a query but when I queried the size of the
tables I was barely reaching 3mb.
After looking around, I found one file with about
10 matches
Mail list logo
