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: Neil Conway <neilc(at)samurai(dot)com>
Cc: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>,"Marc G(dot) Fournier" <scrappy(at)hub(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>,pgsql-committers(at)postgresql(dot)org
Subject: Re: pgsql-server/ /configure /configure.in rc/incl ...
Date: 2003-03-11 04:56:10
Message-ID: 20030311045610.GF79234@perrin.int.nxad.com (view raw or flat)
Thread:
Lists: pgsql-committerspgsql-performance
> > It would be nice to have this support there, however Tom was
> > correct in saying it really only applies to network apps that are
> > handling thousands of connections, all really, really fast.
> > Postgres doesn't.  I say you'd have to do the work, then do the
> > benchmarking to see if it makes a difference.
> 
> ... and if it doesn't make a significant difference, I'd oppose
> including it in the mainline source. Performance optimization is one
> thing; performance "optimization" that doesn't actually improve
> performance is another :-)

::sigh:: Well, I'm not about to argue one way or another on this
beyond saying: kqueue is better than select/poll, but there are much
bigger, much lower, and much easier pieces of fruit to pick off the
optimization tree given the cost/benefit for the amount of network IO
PostgreSQL does.  That said, what was the performance gain of moving
from select() to poll()?  It wasn't the biggest optimization in
PostgreSQL history, nor the smallest, but it was a step forward.  -sc

-- 
Sean Chittenden

In response to

Responses

pgsql-performance by date

Next:From: Tom LaneDate: 2003-03-11 05:06:14
Subject: Re: pgsql-server/ /configure /configure.in rc/incl ...
Previous:From: Christopher Kings-LynneDate: 2003-03-11 04:53:01
Subject: Re: pgsql-server/ /configure /configure.in rc/incl ...

pgsql-committers by date

Next:From: Tom LaneDate: 2003-03-11 05:06:14
Subject: Re: pgsql-server/ /configure /configure.in rc/incl ...
Previous:From: Christopher Kings-LynneDate: 2003-03-11 04:53:01
Subject: Re: pgsql-server/ /configure /configure.in rc/incl ...

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