| From: | Gerhard Hintermayer <g(dot)hintermayer(at)inode(dot)at> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | indices - used by which user ? |
| Date: | 2003-05-07 18:23:52 |
| Message-ID: | b9bir6$12bf$1@news.hub.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I have two tables (2000-4000 entries each) owned by the postgres
superuser and built an index on one of them. If I connect to the
database as user postgres and do a natural inner join on the two tables
(the index coloumn) the index is used and my query executes at about 80
ms (verified with explain analyze). If I connect as another user (for
whom access to the two tables is also granted) and do the same query,
the index is not used and the query takes ~ 800 ms. Both cases are under
psql. Additionally, after issuing a \c - <same other user> when
connected as the not postgres user, the index will be used (very strange).
I searched the docs, but found no kind of grant, that works on indices.
Are there any access priveledges on indices or am I missing some other
point ? Ah, nearly forgot - Version 7.3.1
Gerhard
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jon Earle | 2003-05-07 18:33:55 | Re: [GENERAL] PostgreSQL Qs |
| Previous Message | Jonathan Bartlett | 2003-05-07 18:16:54 | Re: PostgreSQL Qs |