Re: Listen / Notify rewrite - Mailing list pgsql-hackers

From Andrew Chernow
Subject Re: Listen / Notify rewrite
Date
Msg-id 4AFB712D.4080707@esilo.com
Whole thread Raw
In response to Re: Listen / Notify rewrite  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> Premature optimization is the root of all evil ;-).  Unless you've done
> some profiling and can show that this is a hot spot, making it more
> complicated isn't the thing to be doing now.
> 

I'm thinking of how our system uses/abuses notifies, and began wondering 
if several thousand backends listening with a large queue would perform 
decently behind a linear search.  At this point, I have no data either 
way; only an assumption based off being burnt by sequential scans in the 
past ;)

-- 
Andrew Chernow
eSilo, LLC
every bit counts
http://www.esilo.com/


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: NULL-handling in aggregate(DISTINCT ...)
Next
From: Merlin Moncure
Date:
Subject: Re: Listen / Notify rewrite