From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
---|---|
To: | Gerhard Wiesinger <lists(at)wiesinger(dot)com> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: pg_buffercache - A lot of "unnamed" relfilenodes? |
Date: | 2009-09-26 21:39:36 |
Message-ID: | dcc563d10909261439v50fb04f0i6fbd969ac04512cc@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Sat, Sep 26, 2009 at 1:23 PM, Gerhard Wiesinger <lists(at)wiesinger(dot)com> wrote:
> On Sat, 26 Sep 2009, Tom Lane wrote:
>
>> Gerhard Wiesinger <lists(at)wiesinger(dot)com> writes:
>>>
>>> Research on the pg_bufferache showed that a lot of pages don't have any
>>> assigned relfilenodesin pg_class, even when they are dirty (in this case
>>> inserts are done).
>>
>> There should never be any buffered pages for nonexistent tables. The
>> method you are using will only show relnames for pages belonging to
>> tables of the current database ... maybe there are a lot of dirty pages
>> for other databases in the cluster? Or maybe the tables are newly
>> created (not committed) and so you can't see their pg_class rows yet?
>>
>
> OK, this is a visibility problem of the databases. Is it possible to GRANT
> visibility for e.g. one user to all databases for pg_class?
It's not a question of granting it, it's just not there in the other
databases. you could join on a dblink'd result set I guess.
From | Date | Subject | |
---|---|---|---|
Next Message | Krzysztof Barlik | 2009-09-26 22:53:48 | Re: Column names in rowsets returned from function |
Previous Message | InterRob | 2009-09-26 21:30:00 | Re: stored procedure: RETURNS record |