| From: | Gerhard Wiesinger <lists(at)wiesinger(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pg_buffercache - A lot of "unnamed" relfilenodes? |
| Date: | 2009-09-26 19:23:00 |
| Message-ID: | alpine.LFD.2.00.0909262121050.31728@bbs.intern |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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?
Thnx.
Ciao,
Gerhard
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2009-09-26 19:40:50 | Re: |
| Previous Message | Tom Lane | 2009-09-26 18:57:34 | Re: INSERT... RETURNING with a function |