Skip site navigation (1) Skip section navigation (2)

Re: Problems with FTS

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <rauan(at)maemirov(dot)com>,<pgsql-performance(at)postgresql(dot)org>
Subject: Re: Problems with FTS
Date: 2010-12-18 17:56:57
Message-ID: 4D0CA1890200002500038774@gw.wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-performance
Rauan Maemirov  wrote:
 
> EXPLAIN SELECT [...]
 
Please show us the results of EXPLAIN ANALYZE SELECT ...
 
Also, please show us the table layout (including indexes), and
details about your hardware and PostgreSQL configuration.  See this
page for details:
 
http://wiki.postgresql.org/wiki/SlowQueryQuestions
 
> As you can see the query doesn't use index.
 
That means that either the optimizer thinks that the index isn't
usable for this query (due to type mismatch or some such) or that it
thinks a plan without the index costs less to run (i.e., it will
generally run faster).  You haven't told us enough to know whether
that is actually true, much less how to allow PostgreSQL to develop
more accurate costing estimates in your environment if it's currently
wrong about this.
 
-Kevin

Responses

pgsql-performance by date

Next:From: tuanhoanganhDate: 2010-12-18 18:15:33
Subject: PostgreSQL 9.0 x64 bit pgbench TPC very low question?
Previous:From: Kevin GrittnerDate: 2010-12-18 15:53:11
Subject: Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group