Home > mailing lists

Re: query planning different in plpgsql? - Mailing list pgsql-performance

From	Grzegorz Jaśkiewicz
Subject	Re: query planning different in plpgsql?
Date	October 23, 2009 12:56:45
Msg-id	2f4958ff0910230856h384391fhb4caf2409c724a98@mail.gmail.com Whole thread Raw
In response to	Re: query planning different in plpgsql? (Scott Mead <scott.lists@enterprisedb.com>)
Responses	Re: query planning different in plpgsql?
List	pgsql-performance

On Fri, Oct 23, 2009 at 4:49 PM, Scott Mead <scott.lists@enterprisedb.com> wrote:

Do you not have an index on last_snapshot.domain_id?

that, and also try rewriting a query as JOIN. There might be difference in performance/plan.

--
GJ

From: Jeff Davis
Date: 23 October 2009, 12:55:42
Subject: Re: Queryplan within FTS/GIN index -search.

From: Jeff Davis
Date: 23 October 2009, 13:05:36
Subject: Re: Queryplan within FTS/GIN index -search.