[ADMIN] Index error on recovery

Hi The details given below is for a test server, that I brought back up from the base (after running a day worth wals and by giving recovery_target_time before starting the recovery). The recovery went fine and the DB came online as expected. But I see that although trivial select queries seem to

Re: [ADMIN] Index error on recovery

No, all my index B-Tree Index Thanks Manoj K P 2011/12/18 杨晓青 > is your index a hash index? xlog does not include the changes on hash > index,your must rebuild hash index after recovery from xlog. > > > 2011/12/16 K P Manoj > >> Hi >> >> The details give

Re: [ADMIN] Index error on recovery

Hi Could any one else give any pointers, or is there something obviously missing in this request / thread ?. Index "IND_tbl_1_ObjId" and "IND_tbl_1_Act_ObjId" are B-Tree Index. Thanks Manoj 2011/12/19 K P Manoj > No, all my index B-Tree Index > > Thanks >

Re: [ADMIN] PostgreSQL's share_buffer calculation using shmget() versus kernel.shmmax

Hi , You are mentioned SHMMAX larger value is no harm for the database , can i keep this value as 100% of RAM ? Right now we have two cluster in this server , one is having 8 GB and other 2 GB shared buffer . But i am facing some issue , OS cache is filled frequently once i run some query o

[ADMIN] pgsql-admin@postgresql.org, K P Manoj has invited you to open a Gmail account

I've been using Gmail and thought you might like to try it out. Here's an invitation to create an account. You're Invited to Gmail! K P Manoj has invited you to open a Gmail account. Gmail is Google's free email service, built on the idea that email can be intuitive