[ADMIN] db size and tables size difference

2009-09-24 Thread Isabella Ghiurea
Tom Lane wrote: Isabella Ghiurea writes: > The issue may be with pg_size_pretty() results, I don't have details > knowledge of this function. I doubt it, that's a pretty simple function ... but if you don't trust it, just remove the pg_size_pretty call and look directly at the output of th

Re: [ADMIN] pg_toast record in table pg_class

2009-09-24 Thread Mihail Nasedkin
2009/9/24 Mihail Nasedkin : > Hi. > > I accidentally deleted pg_toast record from pg_class table that belongs to > regular table (reltoastrelid). > > Now [select * from table_name] not work: > ERROR:  could not open relation with OID [oid_of_pg_toast_table] > > Is it possible to restore corruption?