Re: [PERFORM] CPU cost of operators

2009-10-01 Thread Matthew Wakeling
On Wed, 30 Sep 2009, Robert Haas wrote: Er, wait... if you set the 'COST' parameter for the backing function, does that work? Ah, right. I was looking at CREATE OPERATOR, not CREATE FUNCTION. Thanks, Matthew -- Bashir: The point is, if you lie all the time, nobody will believe you, even

Re: [PERFORM] CPU cost of operators

2009-09-30 Thread Tom Lane
Robert Haas writes: > Er, wait... if you set the 'COST' parameter for the backing function, > does that work? It's supposed to... regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http:/

Re: [PERFORM] CPU cost of operators

2009-09-30 Thread Robert Haas
On Wed, Sep 30, 2009 at 4:13 PM, Robert Haas wrote: > On Wed, Sep 30, 2009 at 1:12 PM, Matthew Wakeling wrote: >> >> Episode umpteen of the ongoing saga with my GiST indexes. >> >> For some reason, GiST uses loads of CPU. I have a query that runs entirely >> out of cache, and it takes ages. This

Re: [PERFORM] CPU cost of operators

2009-09-30 Thread Robert Haas
On Wed, Sep 30, 2009 at 1:12 PM, Matthew Wakeling wrote: > > Episode umpteen of the ongoing saga with my GiST indexes. > > For some reason, GiST uses loads of CPU. I have a query that runs entirely > out of cache, and it takes ages. This much I have tried to fix and failed so > far. > > What I wou

[PERFORM] CPU cost of operators

2009-09-30 Thread Matthew Wakeling
Episode umpteen of the ongoing saga with my GiST indexes. For some reason, GiST uses loads of CPU. I have a query that runs entirely out of cache, and it takes ages. This much I have tried to fix and failed so far. What I would now like to do is to tell postgres about it, so that the EXPLAI