| From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Cc: | allenwu1973(at)yahoo(dot)co(dot)jp |
| Subject: | BUG #15491: index on function not being used for full text search when querying through a view |
| Date: | 2018-11-07 08:30:20 |
| Message-ID: | 15491-5bd96f27a237da50@postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 15491
Logged by: Allen Wu
Email address: allenwu1973(at)yahoo(dot)co(dot)jp
PostgreSQL version: 11.0
Operating system: linux
Description:
Hi
I'm trying to implement full text search with PostgreSQL,
I found when using a function create index in conjunction with querying
through a view, will cause postgres not to use the index.
Below are example for each scenario.
When only using expression index, the index is used
https://dbfiddle.uk/?rdbms=postgres_11&fiddle=16ed7a04389ebf71dc5a1fb2daa34058
When only using view, the index is also used
https://dbfiddle.uk/?rdbms=postgres_11&fiddle=e8d50181b8612421773c2da39e45c9fd
view + expression, the index is NOT used
https://dbfiddle.uk/?rdbms=postgres_11&fiddle=19d7b923514f100f6e402b54624cc972
I've avoid using function in my app, but I think this should have worked.
Thank you
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Etsuro Fujita | 2018-11-07 10:03:32 | Re: BUG #15449: file_fdw using program cause exit code error when using LIMIT |
| Previous Message | Amit Langote | 2018-11-07 07:21:53 | Re: BUG #15490: The tablespace of an index defined on a partitioned table does not apply to a newly added partition |