Re: [PERFORM] Lock and pg_stat

2013-05-14 Thread Robert Haas
On Mon, May 13, 2013 at 9:05 AM, Desbiens, Eric wrote: > I tried also: > > select * from pg_class where oid=30352481; > > but didn't got anything You probably want where relfilenode=30352481. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent

[PERFORM] Lock and pg_stat

2013-05-13 Thread Desbiens, Eric
- I have a problem with some files on a postgresql 9.0 on windows: 2013-05-10 12:49:08 EDT ERROR: could not stat file "base/773074/30352481": Permission denied 2013-05-10 12:49:08 EDT STATEMENT: SELECT pg_database_size($1) AS size; I know what does it means: the statistic pooler can`t access