Re: Problem with LIKE-Performance

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Tarabas (Manuel Rorarius)" <tarabas(at)tarabas(dot)de>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Problem with LIKE-Performance
Date: 2006-04-18 15:20:20
Message-ID: 13458.1145373620@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Tarabas (Manuel Rorarius)" <tarabas(at)tarabas(dot)de> writes:
> I get the following explain and I am troubled by the very high
> "startup_cost" ... does anyone have any idea why that value is so
> high?

> {SEQSCAN
> :startup_cost 100000000.00

You have enable_seqscan = off, no?

Please refrain from posting EXPLAIN VERBOSE unless it's specifically
requested ...

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2006-04-18 15:33:06 Re: SELECT FOR UPDATE performance is bad
Previous Message REISS Thomas DSIC DESP 2006-04-18 15:17:14 Re: Problem with LIKE-Performance