| From: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
|---|---|
| To: | Viktor Bojovi* <viktor(dot)bojovic(at)gmail(dot)com>, <pgsql-admin(at)postgresql(dot)org>,<pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: function based index problem |
| Date: | 2011-08-31 21:53:52 |
| Message-ID: | 4E5E672002000025000409E7@gw.wicourts.gov |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-sql |
Viktor Bojovi*<viktor(dot)bojovic(at)gmail(dot)com> wrote:
> i don't know why it doesn't use index scan.
Because it thinks your query will return 81226 rows. We need more
information to make many suggestions beyond "make sure the table has
been analyzed".
http://wiki.postgresql.org/wiki/SlowQueryQuestions
Also, it's not considered good form to post an issue to more than
one PostgreSQL list. This is probably most appropriate on the
pgsql-performance list, so if you want to follow up with more detail
to get more detailed suggestions, it would be best to abandon this
thread and start a new one on that list.
-Kevin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Johnston | 2011-08-31 22:09:03 | Re: [SQL] function based index problem |
| Previous Message | Kevin Grittner | 2011-08-31 21:42:53 | Re: Segmentation fault |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Johnston | 2011-08-31 22:09:03 | Re: [SQL] function based index problem |
| Previous Message | Viktor Bojović | 2011-08-31 21:27:29 | function based index problem |