Re: Vacuum and Large Objects - Mailing list pgsql-general

From Radosław Smogura
Subject Re: Vacuum and Large Objects
Date
Msg-id c137649d2d0f24c11f31e3a4faeaca57@mail.softperience.eu
Whole thread Raw
In response to Re: Vacuum and Large Objects  (Guillaume Lelarge <guillaume@lelarge.info>)
List pgsql-general
On Fri, 06 Jan 2012 08:51:24 +0100, Guillaume Lelarge wrote:
> On Fri, 2012-01-06 at 07:12 +0100, Stefan Keller wrote:
>> Hi Igor
>> 2011/12/16 Igor Neyman <ineyman@perceptron.com> wrote: > But I
>> think,
>> your problem is right here:
>> >
>> > " running VACUUM FULL  pg_largeobject"
>> >
>> > If you are running "VACUUM FULL ..." on the table, you should
>> follow it with the "REINDEX TABLE ...", at least on PG versions prior
>> to 9.0.
>>
>> I'm pretty sure that VACUUM FULL builds new indexes. That's at least
>> of how I understand the docs, especially the first "tip" here
>> http://www.postgresql.org/docs/9.0/static/routine-vacuuming.html
>>
>
> Before 9.0, VACUUM FULL required a REINDEX afterwards if you want to
> keep decent performances.
>
> With 9.0, it is no longer required because the new VACUUM FULL
> doesn't
> bloat the index anymore.
>
> So, in a sense, you were both right :) The documentation you're
> referring to is the 9.0 manual. And Igor specified that one need to
> REINDEX after VACUUM FULL for any release prior to 9.0. Both right.
>
>
> --
> Guillaume
> http://blog.guillaume.lelarge.info
> http://www.dalibo.com
> PostgreSQL Sessions #3: http://www.postgresql-sessions.org

Not quite true. I have develop server "PostgreSQL 9.0.5, compiled by
Visual C++ build 1500, 64-bit", after clearing LO and vacumming
accessing db stats from pgadmin gives permission denied on rel xxxx and
in fact this file gets wrong permissions. REINDEX resolves problem.

Regards,
Radek


pgsql-general by date:

Previous
From: Radosław Smogura
Date:
Subject: Re: Binary Large Objects (LOB/BLOB) in Hibernate and JDBC: Unresolved issues
Next
From: ChoonSoo Park
Date:
Subject: Re: How to code lo_creat & lo_write & lo_read in non-blocking mode