From: Kenneth Marshall <ktm@rice.edu>
To: Eliot Gable <egable+pgsql-performance@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Joe Conway <mail@joeconway.com>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: Merlin Moncure <mmoncure@gmail.com>
Cc: Craig Ringer <craig@postnewspapers.com.au>
Cc: Craig James <craig_james@emolecules.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Highly Efficient Custom Sorting
Date: Wed, 7 Jul 2010 14:42:36 -0500
Message-ID: <20100707194236.GQ341@aart.is.rice.edu> (raw)
In-Reply-To: <AANLkTinXIAgV0feBOY9znKyt35nB3CzrUKr3ynnykEF9@mail.gmail.com>
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>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: ktm@rice.edu, egable+pgsql-performance@gmail.com, tgl@sss.pgh.pa.us, mail@joeconway.com, robertmhaas@gmail.com, mmoncure@gmail.com, craig@postnewspapers.com.au, craig_james@emolecules.com
Subject: Re: Highly Efficient Custom Sorting
In-Reply-To: <20100707194236.GQ341@aart.is.rice.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox