Skip site navigation (1) Skip section navigation (2)

Re: pgsql-server/ /configure /configure.in rc/incl ...

From: Sean Chittenden <sean(at)chittenden(dot)org>
To: "Marc G(dot) Fournier" <scrappy(at)hub(dot)org>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>,Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>,pgsql-committers(at)postgresql(dot)org
Subject: Re: pgsql-server/ /configure /configure.in rc/incl ...
Date: 2003-03-11 04:11:33
Message-ID: 20030311041133.GC79234@perrin.int.nxad.com (view raw or flat)
Thread:
Lists: pgsql-committerspgsql-performance
> > Heh, kqueue is _the_ reason to use FreeBSD.
> >
> > http://www.kegel.com/dkftpbench/Poller_bench.html#results
> >
> > I've toyed with the idea of adding this because it is monstrously more
> > efficient than select()/poll() in basically every way, shape, and
> > form.
> 
> I would personally be interested in seeing patches ... what would be
> involved?

Whoa!  Surprisingly, much less than I expected!!!  A small shim would
have to be put in place to abstract away returning valid file
descriptors that are ready to be read()/write().  What's really cool,
is there are only a handful of places that'd have to be updated (as
far as I can tell):

src/backend/access/transam/xact.c
src/backend/postmaster/pgstat.c
src/backend/postmaster/postmaster.c
src/backend/storage/lmgr/s_lock.c
src/bin/pg_dump/pg_dump.c
src/interfaces/libpq/fe-misc.c

Then it'd be possible to have clients/servers switch between kqueue,
poll, select, or whatever the new flavor of alerting from available IO
fd's.  I've added it to my personal TODO list of things to work on.
If someone beats me to it, cool, it's just something that one day I'll
get to (hopefully).  -sc

-- 
Sean Chittenden

In response to

Responses

pgsql-performance by date

Next:From: Christopher Kings-LynneDate: 2003-03-11 04:17:46
Subject: Re: pgsql-server/ /configure /configure.in rc/incl ...
Previous:From: Kevin BrownDate: 2003-03-11 03:44:36
Subject: Re: Index / Performance issues

pgsql-committers by date

Next:From: Christopher Kings-LynneDate: 2003-03-11 04:17:46
Subject: Re: pgsql-server/ /configure /configure.in rc/incl ...
Previous:From: Marc G. FournierDate: 2003-03-11 02:50:59
Subject: Re: pgsql-server/ /configure /configure.in rc/incl ...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group