indices - used by which user ?

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: Raw Message | Whole Thread | 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

Responses

Browse pgsql-general by date

  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