pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Alvaro Herrera <alvherre@commandprompt.com>
To: Merlin Moncure <mmoncure@gmail.com>
Cc: Eliot Gable <egable+pgsql-performance@gmail.com>
Cc: Craig Ringer <craig@postnewspapers.com.au>
Cc: Craig James <craig_james@emolecules.com>
Cc: pgsql-performance <pgsql-performance@postgresql.org>
Subject: Re: Highly Efficient Custom Sorting
Date: Sat, 03 Jul 2010 22:47:51 -0400
Message-ID: <1278211564-sup-9529@alvh.no-ip.org> (raw)
In-Reply-To: <AANLkTilrdEpHeuRfS1E9n6YnJiQ-YtWW_EUI1-c3yNy4@mail.gmail.com>
References: <AANLkTikrA8M3cncIHkFqsJ78TzCnQdriE0GjvK8XjB9E@mail.gmail.com>
	<4C2D574E.5030308@postnewspapers.com.au>
	<4767.1278043730@sss.pgh.pa.us>
	<AANLkTimZISmcXkPN059pz5bx-TXKVOnm6iuJ4y4qQedu@mail.gmail.com>
	<4C2E1587.70001@emolecules.com>
	<4C2E9606.8050903@postnewspapers.com.au>
	<AANLkTimaUPkOn6OkCspsZ7iTiY9S6MFTrKTgFXKckl2u@mail.gmail.com>
	<AANLkTikn4wgydmzY79aH2UrLAXPPrMVw8Uu-fNLjCEZk@mail.gmail.com>
	<AANLkTiln7OejssTCZzsnbvYnXOyJL_v5CkEhZ9asHy6X@mail.gmail.com>
	<AANLkTilrdEpHeuRfS1E9n6YnJiQ-YtWW_EUI1-c3yNy4@mail.gmail.com>

Excerpts from Merlin Moncure's message of sáb jul 03 18:53:46 -0400 2010:

> What about my suggestion doesn't work for your requirements?  (btw,
> let me disagree with my peers and state pl/perl is lousy for this type
> of job, only sql/and pl/sql can interact with postgresql variables
> natively for the most part).

IIRC the other reason pl/perl sucks for this kind of thing is that it
forces a subtransaction to be created before the function call, which is
expensive.  (I might be misremembering and what actually causes a
subtransaction is a SPI call inside a PL/Perl function, which wouldn't
apply here.)



view thread (22+ messages)  latest in thread

Message-ID: <1278211564-sup-9529@alvh.no-ip.org>
Permalink:  ../1278211564-sup-9529@alvh.no-ip.org/
Also on:    postgresql.org/message-id/1278211564-sup-9529@alvh.no-ip.org

 · 

reply
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: alvherre@commandprompt.com, mmoncure@gmail.com, egable+pgsql-performance@gmail.com, craig@postnewspapers.com.au, craig_james@emolecules.com
  Subject: Re: Highly Efficient Custom Sorting
  In-Reply-To: <1278211564-sup-9529@alvh.no-ip.org>

* 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