[GENERAL] Is there any way to measure disk activity for each query?

Hello! I'm wondering, if there any way to measure how much disk-io were generated by a query? -- Best Regards, Oleg

Re: [GENERAL] Postgresql + corrupted disk = data loss. (Need help for database recover)

gres to read this files?* 3 декабря 2011 г. 18:10 пользователь Tomas Vondra написал: > On 2.12.2011 09:16, Oleg Serov wrote: > > Hello! > > > > i've don't try to do reindex. There was enough space. > > Not sure whether you tried to reindex or not. And what do y

Re: [GENERAL] Postgresql + corrupted disk = data loss. (Need help for database recover)

Hello! i've don't try to do reindex. There was enough space. And i have a full data-directory backup, when i've stop server, before start. 2011/12/2 Venkat Balaji > > 2011/12/2 Oleg Serov > >> And, i'm an idiot. >> >> My DB version: >>

Re: [GENERAL] Postgresql + corrupted disk = data loss. (Need help for database recover)

And, i'm an idiot. My DB version: PostgreSQL 8.4.9 on x86_64-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-51), 64-bit 2011/12/2 Oleg Serov > Hello, i have a problem. > > I've got a production server, working fine. Then i've got strange

[GENERAL] Postgresql + corrupted disk = data loss. (Need help for database recover)

Hello, i have a problem. I've got a production server, working fine. Then i've got strange error: > ERROR: right sibling's left-link doesn't match: block 147 links to 407 instead of expected 146 in index "order_status_key"' And decidet to backup all server. So i shut-down VPS with server and back