Re: [JDBC] unlink large objects

2001-06-09 Thread Philip Crotwell
Hi I was vacuuming, but as the owner of the database. When I do that there are messages that should have clued me in, lke NOTICE: Skipping "pg_largeobject" --- only table owner can VACUUM it >From now on I will vacuum as user postgres, but I wonder if there is a need for individual users to b

Re: [JDBC] unlink large objects

2001-06-08 Thread Tom Lane
Philip Crotwell <[EMAIL PROTECTED]> writes: > I poked around in the database directory and found a file named 16948 that > is 960Mb or almost all of the space on my partition. That is pg_largeobject. Vacuuming should recover the lost space; are you sure you've vacuumed it?