Thank you so much for the script.
~deepak
On Jan 22, 2011, at 10:18 AM, Greg Smith wrote:
> DM wrote:
>> RAM = 16GB, what value should i set for shmall?
>
> Given that PostgreSQL rarely sees increasing improvement as shared_buffers
> goes over 50% of RAM, I just use that figure for the shmal
My guess is some one moved the data folder or the directory got deleted
(/var/lib/pgsql/9.0/data/.../...1663/16384/16564). Without server restart. I am
sure some experts gonna answer this very well.
Thanks
Deepak
On Jul 30, 2011, at 2:01 AM, Deniz Atak wrote:
> Hi,
>
> I am using postgresql
I am not sure how big your table is one way we implemented here was we selected
the clean rows and outputted it to a csv file. And the rows affected we had to
load from the backup, luckily we had the clean backup.
Ex: assume you have 1,2,3,4,5100 rows and the corrupted is between 60-70. I
o
