Postgres Pro
Downloads
Home   >   mailing lists

Re: Problem with LIKE-Performance - Mailing list pgsql-performance

From Tom Lane
Subject Re: Problem with LIKE-Performance
Date
Msg-id 13458.1145373620@sss.pgh.pa.us
Whole thread Raw
In response to Problem with LIKE-Performance  ("Tarabas (Manuel Rorarius)" <tarabas@tarabas.de>)
Responses Re: Problem with LIKE-Performance
List pgsql-performance
Tree view 
"Tarabas (Manuel Rorarius)" <tarabas@tarabas.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

pgsql-performance by date:

Previous
From: "Tarabas (Manuel Rorarius)"
Date:
Subject: Re: Problem with LIKE-Performance
Next
From: Tom Lane
Date:
Subject: Re: SELECT FOR UPDATE performance is bad