Re: Benchmarking Function - Mailing list pgsql-performance

From David Wheeler
Subject Re: Benchmarking Function
Date
Msg-id E6E6A4F5-1A54-41D2-B6C3-9E9BDBDB8D13@kineticode.com
Whole thread Raw
In response to Re: Benchmarking Function  (Josh Berkus <josh@agliodbs.com>)
List pgsql-performance
On May 21, 2006, at 12:23, Josh Berkus wrote:

> Well, per our conversation the approach doesn't really work.   EXECUTE
> 'string' + generate_series seems to carry a substantial and
> somewhat random
> overhead, between 100ms and 200ms -- enough to wipe out any
> differences
> between queries.

Per our conversation I eliminated the EXECUTE 'string' +
generate_series. Check it out.

   http://theory.kineticode.com/computers/databases/postgresql/
benchmarking_functions.html

(Temporary URL; justatheory.com seems to have disappeared from DNS...

Best,

David

pgsql-performance by date:

Previous
From: Brendan Duddridge
Date:
Subject: Re: Performs WAY better with enable_seqscan = off
Next
From: Scott Marlowe
Date:
Subject: Re: utilizing multiple disks for i/o performance