Re: optimizing a cpu-heavy query - Mailing list pgsql-general

From Joel Reymont
Subject Re: optimizing a cpu-heavy query
Date
Msg-id B7BDD4F5-48B8-4409-8174-19C299871573@gmail.com
Whole thread Raw
In response to Re: optimizing a cpu-heavy query  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: optimizing a cpu-heavy query
List pgsql-general
Tom,

On Apr 26, 2011, at 5:00 PM, Tom Lane wrote:

> For another couple orders of magnitude, convert the sub-function to C code.  (I don't think you need
> a whole data type, just a function that does the scalar product.)

That's a 30x speedup, from 12 minutes down to 38s. Thanks Tom!

--------------------------------------------------------------------------
- for hire: mac osx device driver ninja, kernel extensions and usb drivers
---------------------+------------+---------------------------------------
http://wagerlabs.com | @wagerlabs | http://www.linkedin.com/in/joelreymont
---------------------+------------+---------------------------------------




pgsql-general by date:

Previous
From: Toby Corkindale
Date:
Subject: Re: Poor performance of btrfs with Postgresql
Next
From: Toby Corkindale
Date:
Subject: Re: tuning on ec2