Postgres Pro
Downloads
Home   >   mailing lists

Re: text search: tablescan cost for a tsvector - Mailing list pgsql-performance

From Robert Haas
Subject Re: text search: tablescan cost for a tsvector
Date
Msg-id CA+TgmoZgQBeu2KN305hwDS+aXW7YP0YN9vZwBsbWA8Unst+cew@mail.gmail.com
Whole thread Raw
In response to text search: tablescan cost for a tsvector  ("Marc Mamin" <M.Mamin@intershop.de>)
List pgsql-performance
Tree view 
On Mon, Feb 6, 2012 at 6:05 AM, Marc Mamin <M.Mamin@intershop.de> wrote:
> without analyze: http://explain.depesz.com/s/6At
> with analyze:    http://explain.depesz.com/s/r3B

I think this is the same issue complained about here:

http://archives.postgresql.org/message-id/4ED68EEC.9030906@krogh.cc

And here:

http://archives.postgresql.org/message-id/CANxtv6XiuiqEkXRJU2vk=xKAFXrLeP7uVhgR-XMCyjgQz29EFQ@mail.gmail.com

The problem seems to be that the cost estimator doesn't know that
detoasting is expensive.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-performance by date:

Previous
From: Stefan Keller
Date:
Subject: Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
Next
From: Robert Haas
Date:
Subject: Re: How to improve insert speed with index on text column