Skip site navigation (1) Skip section navigation (2)

Re: Benchmarking Function

From: David Wheeler <david(at)kineticode(dot)com>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Benchmarking Function
Date: 2006-05-21 22:45:14
Message-ID: (view raw, whole thread or download thread mbox)
Lists: 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. 

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



In response to

pgsql-performance by date

Next:From: Scott MarloweDate: 2006-05-22 15:14:51
Subject: Re: utilizing multiple disks for i/o performance
Previous:From: Brendan DuddridgeDate: 2006-05-21 20:01:14
Subject: Re: Performs WAY better with enable_seqscan = off

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group