Re: Getting all tables into memory

On Thu, 2008-01-24 at 10:46 -0500, Bill Moran wrote:
> In response to Robert Fitzpatrick <lists(at)webtent(dot)net>:
>
> > How can I tell if PgSQL is using memory or not and
> > how much?
>
> Well, top is helpful. Also, consider installing the pg_buffercache addon
> so you can see how much of your shared_buffers is being used.

Well, all of it I guess from looking below? Again, just learning here...

maia=# select count(*) from pg_buffercache;
count
-------
64000
(1 row)
maia=# select count(*) from pg_buffercache where relfilenode is null;
count
-------
0
(1 row)
maia=# SELECT c.relname, count(*) AS buffers
FROM pg_class c INNER JOIN pg_buffercache b
ON b.relfilenode = c.relfilenode INNER JOIN pg_database d
ON (b.reldatabase = d.oid AND d.datname = current_database())
GROUP BY c.relname
ORDER BY 2 DESC LIMIT 10;
relname | buffers
-------------------------+---------
bayes_token | 16684
bayes_token_idx1 | 10264
maia_sa_rules | 8501
pg_toast_70736 | 5898
maia_mail | 4361
maia_sa_rules_triggered | 3913
maia_mail_recipients | 3603
bayes_token_pkey | 3199
maia_stats | 2545
token_idx | 2442
(10 rows)

Thanks again for any insight?

--
Robert