[ADMIN] db size and tables size difference

2009-09-24 Thread Isabella Ghiurea
Tom Lane wrote: Isabella Ghiurea isabella.ghiu...@nrc-cnrc.gc.ca 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

Re: [ADMIN] pg_toast record in table pg_class

2009-09-24 Thread Mihail Nasedkin
2009/9/24 Mihail Nasedkin m.nased...@gmail.com: 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