Date: Wed, 7 Jul 2010 14:42:36 -0500
From: Kenneth Marshall <ktm@rice.edu>
To: Eliot Gable <egable+pgsql-performance@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Joe Conway <mail@joeconway.com>,
	Robert Haas <robertmhaas@gmail.com>, Merlin Moncure <mmoncure@gmail.com>,
	Craig Ringer <craig@postnewspapers.com.au>,
	Craig James <craig_james@emolecules.com>, pgsql-performance@postgresql.org
Subject: Re: Highly Efficient Custom Sorting
Message-ID: <20100707194236.GQ341@aart.is.rice.edu>
References: <AANLkTimaUPkOn6OkCspsZ7iTiY9S6MFTrKTgFXKckl2u@mail.gmail.com>
	<AANLkTikn4wgydmzY79aH2UrLAXPPrMVw8Uu-fNLjCEZk@mail.gmail.com>
	<AANLkTiln7OejssTCZzsnbvYnXOyJL_v5CkEhZ9asHy6X@mail.gmail.com>
	<AANLkTik51nNmr6E_fu5lJtwCmvRhl3frzoMsgvB1-qf2@mail.gmail.com>
	<AANLkTikLPKC8ebtLs6qxR85A4aPnH5klOwljROl4D2eu@mail.gmail.com>
	<4C338B61.60409@joeconway.com>
	<AANLkTikJZvJ3v5nzLRSvXdVL3WUKOd6_qfUU4Re5Qp93@mail.gmail.com>
	<AANLkTini3gqeePTScOPmmtSUTpKlQgVX4zFux4yvwQfg@mail.gmail.com>
	<18550.1278454884@sss.pgh.pa.us>
	<AANLkTinXIAgV0feBOY9znKyt35nB3CzrUKr3ynnykEF9@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <AANLkTinXIAgV0feBOY9znKyt35nB3CzrUKr3ynnykEF9@mail.gmail.com>
User-Agent: Mutt/1.5.16 (2007-06-09)

Hi Eliot,

Would you mind posting your code for reference. It is nice to
have working examples when trying to figure out how it all fits
together.

Regards,
Ken

On Wed, Jul 07, 2010 at 03:23:12PM -0400, Eliot Gable wrote:
> 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@sss.pgh.pa.us> wrote:
> 
> > Eliot Gable <egable+pgsql-performance@gmail.com<egable%2Bpgsql-performance@gmail.com>>
> > 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