Postgres Pro
Downloads
Home   >   mailing lists

Re: autovacuum and TOAST tables - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: autovacuum and TOAST tables
Date
Msg-id 20081011001456.GI4194@alvh.no-ip.org
Whole thread Raw
In response to Re: autovacuum and TOAST tables  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
Tom Lane wrote:
> Alvaro Herrera <alvherre@commandprompt.com> writes:
> >> Yeah, that seems like the best answer.
>
> > Seems like this patch fixes it.
>
> Um, not for tables that don't have toast tables ...

Right, this seems better.

Note that it needs to open the toast table and grab AccessShare to get
the toast index OID.  I don't think it needs a stronger lock.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Attachment

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Contrib, schema, and load_module
Next
From: "Nikolas Everett"
Date:
Subject: Re: How is random_page_cost=4 ok?