Re: autovacuum multiworkers, patch 5

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: autovacuum multiworkers, patch 5
Date: 2007-04-12 12:42:51
Message-ID: 20070412124251.GA5783@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

ITAGAKI Takahiro wrote:
>
> Alvaro Herrera <alvherre(at)commandprompt(dot)com> wrote:
>
> > > > I manually merged your patch on top of my own. This is the result.
> > > > Please have a look at whether the new code is correct and behaves sanely
> > > > (I haven't tested it).
> >
> > Huh, you are right, it is broken, even in my outgoing mailbox -- I don't
> > know what happened, as the file I have on disk is complete. Here is
> > attached again.
>
> I tested your patch on Linux and Windows. It works well on Linux,
> where we use fork(), but falls into segfault on Windows, where we
> use exec(). Maybe you forgot to initialize the shared memory stuff.
> (I haven't find out where to be fixed, sorry.)

Ok, thanks, this confirms that I have to try the EXEC_BACKEND code path.

> Multiworker and balancing seem to work well after they successfully start up.

Great.

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Merlin Moncure 2007-04-12 12:48:12 Re: Bug about column references within subqueries used in selects
Previous Message NikhilS 2007-04-12 12:38:40 Bug about column references within subqueries used in selects

Browse pgsql-patches by date

  From Date Subject
Next Message Gurjeet Singh 2007-04-12 12:55:14 Re: [HACKERS] [Fwd: Index Advisor]
Previous Message Marko Kreen 2007-04-12 11:17:20 Re: RESET SESSION v3