Re: Highly Efficient Custom Sorting

[Eliot Gable <egable+pgsql-performance@xxxxxxxxx>]

Thanks again for all the input and suggestions from people. I have this sorting algorithm re-implemented in C now and it is somewhere <2ms to run it now; though it is difficult to get a more accurate measure. There may be some additional optimizations I can come up with, but for now, this will work very well compared to the alternative methods.

On Tue, Jul 6, 2010 at 6:21 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:

Eliot Gable <egable+pgsql-performance@xxxxxxxxx> writes:
> Do I need to somehow force the server to unload and then re-load this .so
> file each time I build a new version of it? If so, how do I do that?

Start a new database session.

                       regards, tom lane

-- 
Eliot Gable

"We do not inherit the Earth from our ancestors: we borrow it from our children." ~David Brower 

"I decided the words were too conservative for me. We're not borrowing from our children, we're stealing from them--and it's not even considered to be a crime." ~David Brower

"Esse oportet ut vivas, non vivere ut edas." (Thou shouldst eat to live; not live to eat.) ~Marcus Tullius Cicero