Re: 8.3devel slower than 8.2 under read-only load - Mailing list pgsql-hackers

From Gregory Stark
Subject Re: 8.3devel slower than 8.2 under read-only load
Date
Msg-id 874pf8dhwt.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: 8.3devel slower than 8.2 under read-only load  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: 8.3devel slower than 8.2 under read-only load  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
"Simon Riggs" <simon@2ndquadrant.com> writes:

> I've written up my suggestion as a 5 line patch, with measured
> performance improvement of about 40% for the varchar case. 

A 5-line patch which improves performance by 40% for any case sounds amazing,
but how fragile is that gain? The kind of thing which would be worryign is if
runing a query which uses both varchar and some other ambiguous operator
causes it to lose all its gain.

--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com Ask me about EnterpriseDB's RemoteDBA services!


pgsql-hackers by date:

Previous
From: Bernd Helmle
Date:
Subject: maintenance_work_mem memory constraint?
Next
From: Tom Lane
Date:
Subject: Re: 8.3devel slower than 8.2 under read-only load