Re: [PERFORM] Custom operator class costs

2011-04-18 Thread Robert Haas
On Wed, Mar 16, 2011 at 10:10 AM, Ben Beecher wrote: > Hey! > I'm having some trouble optimizing a query that uses a custom operator class. > #Postgres has given me a solution for natural sort - > http://www.rhodiumtoad.org.uk/junk/naturalsort.sql > > I'm trying to run it over a huge table - when

[PERFORM] Custom operator class costs

2011-03-16 Thread Ben Beecher
Hey! I'm having some trouble optimizing a query that uses a custom operator class. #Postgres has given me a solution for natural sort - http://www.rhodiumtoad.org.uk/junk/naturalsort.sql I'm trying to run it over a huge table - when running it on demand, the data needs to be dumped to memory and s