ok,
you calculate headline() 19861 times, while you need only 20.
Use subselect and will be surprized
Oleg
On Thu, 2 Oct 2008, Matthew Terenzio wrote:
Thanks Tom, Sorry if that last post went over multiple times. I was getting
a mailing failure (or so I thought)
here is EXPLAIN ANALYZE . I re
"Matthew Terenzio" <[EMAIL PROTECTED]> writes:
> here is EXPLAIN ANALYZE . I really need to work on my skills at analyzing
> these:
> Limit (cost=105505.78..105505.83 rows=20 width=655) (actual
> time=74806.973..74807.037 rows=20 loops=1)
>-> Sort (cost=105505.78..10.44 rows=19861 width
Thanks Tom, Sorry if that last post went over multiple times. I was getting
a mailing failure (or so I thought)
here is EXPLAIN ANALYZE . I really need to work on my skills at analyzing
these:
Limit (cost=105505.78..105505.83 rows=20 width=655) (actual
time=74806.973..74807.037 rows=20 loops=1)
"Matthew Terenzio" <[EMAIL PROTECTED]> writes:
> There are less than 20,000 records being searched here, but the query takes
> several minutes.
> I know this may not be enough info, but would one suggest I optimize the
> query or put my attention towards other areas.
What does EXPLAIN ANALYZE show
There are less than 20,000 records being searched here, but the query takes
several minutes.
I know this may not be enough info, but would one suggest I optimize the
query or put my attention towards other areas.
SELECT id,date,headline as head,headline(body,q),rank(vectors,q),timestamp
FROM sto