Re: Highly Efficient Custom Sorting

From: Kenneth Marshall <ktm(at)rice(dot)edu>
To: Eliot Gable <egable+pgsql-performance(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Joe Conway <mail(at)joeconway(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Merlin Moncure <mmoncure(at)gmail(dot)com>, Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>, Craig James <craig_james(at)emolecules(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Highly Efficient Custom Sorting
Date: 2010-07-07 19:42:36
Message-ID: 20100707194236.GQ341@aart.is.rice.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> > Eliot Gable <egable+pgsql-performance(at)gmail(dot)com<egable%2Bpgsql-performance(at)gmail(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Robert Haas 2010-07-07 20:49:39 Re: big data - slow select (speech search)
Previous Message Richard Yen 2010-07-07 19:32:17 Re: [Slony1-general] WAL partition overloaded--by autovacuum?