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

Re: Strangely Variable Query Performance

From: Steve <cheetah(at)tanabi(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Strangely Variable Query Performance
Date: 2007-04-12 22:24:48
Message-ID: Pine.GSO.4.64.0704121822090.17955@kittyhawk.tanabi.org (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patchespgsql-performance
> [ itch... ]  That code is just completely wrong, because the contents
> of a TEXT datum aren't guaranteed null-terminated.  It'd be better to
> invoke bttextcmp and negate its result.
>
> That's not relevant to your immediate problem, but if you've noticed
> any strange behavior with your text_revop indexes, that's the reason...

 	The indexes have all worked, though I'll make the change anyway. 
Documentation on how to code these things is pretty sketchy and I believe 
I followed an example on the site if I remember right. :/

Thanks for the info though :)


Steve

In response to

pgsql-performance by date

Next:From: SteveDate: 2007-04-12 22:41:33
Subject: Re: Strangely Variable Query Performance
Previous:From: Tom LaneDate: 2007-04-12 22:22:49
Subject: Re: Strangely Variable Query Performance

pgsql-hackers by date

Next:From: Neil ConwayDate: 2007-04-12 22:38:54
Subject: Re: [COMMITTERS] pgsql: RESET SESSION, plus related newDDL commands.
Previous:From: Jim NasbyDate: 2007-04-12 22:24:20
Subject: Re: So are we calling it: Feature Freeze?

pgsql-patches by date

Next:From: SteveDate: 2007-04-12 22:41:33
Subject: Re: Strangely Variable Query Performance
Previous:From: Tom LaneDate: 2007-04-12 22:22:49
Subject: Re: Strangely Variable Query Performance

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