Hi Dmitriy,
pg_largeobject is already empty, I have lo_unlink()'ed everything
from it, but it still takes up the same disk space and memory for
the free page maps. I'm looking at the best way to reclaim the
disk/memory from this otherwise empty table.
Normal VACUUM didn't help and I'd like some a
Hey Tamas,
2011/7/25 Tamas Vincze
> Is it safe?
>
> This table is around 500GB and because of performance reasons
> I slowly moved all large objects to regular files on a NetApp
> share.
>
> Now it shows 0 records:
>
> # select count(*) from pg_largeobject;
> count
> ---
> 0
> (1 row)
>
Is it safe?
This table is around 500GB and because of performance reasons
I slowly moved all large objects to regular files on a NetApp
share.
Now it shows 0 records:
# select count(*) from pg_largeobject;
count
---
0
(1 row)
but disk space and RAM by the free space map is still occu
