Re: [BUGS] BUG #5774: VACCUM & REINDEX kills production environement

2010-11-29 Thread Balamurugan Mahendran
:22 PM, Heikki Linnakangas < heikki.linnakan...@enterprisedb.com> wrote: > On 29.11.2010 18:48, Balamurugan Mahendran wrote: > >> Thanks, I'll remove it. But I still get down time because of Vacuum(table >> lock). Is there any other better way to do this? >> &

Re: [BUGS] BUG #5774: VACCUM & REINDEX kills production environement

2010-11-29 Thread Balamurugan Mahendran
a On Mon, Nov 29, 2010 at 10:01 PM, Heikki Linnakangas < heikki.linnakan...@enterprisedb.com> wrote: > On 29.11.2010 17:16, Balamurugan Mahendran wrote: > >> This is how I used to do maintenance through cron job. Please advise if i >> need to change my method, Also I used

Re: [BUGS] BUG #5774: VACCUM & REINDEX kills production environement

2010-11-29 Thread Balamurugan Mahendran
This is how I used to do maintenance through cron job. Please advise if i need to change my method, Also I used to run re-index all the time while doing Vacuum (cron job updated twice a week). queryfor Vaccum:VACUUM VERBOSE ANALYZE contactmanagementsystem.brands queryfor Vaccum:VACUUM VERBOSE ANAL

Re: [BUGS] BUG #5773: DEBUG: reaping dead processes DEBUG: server process (PID 10007) was terminated by signal 11: Segme

2010-11-28 Thread Balamurugan Mahendran
Thanks all for your help!! I am not sure that I'll get all my needed function from built-in UUID. I got the source from the below link also this works perfectly fine with 8.3 version(in my understanding). http://ring.nict.go.jp/archives/misc/db/postgresql/projects/gborg/uniqueidentifier/stable/un

Re: [BUGS] BUG #5773: DEBUG: reaping dead processes DEBUG: server process (PID 10007) was terminated by signal 11: Segme

2010-11-27 Thread Balamurugan Mahendran
. #12 0x005dd3ff in PostmasterMain () No locals. #13 0x005810e8 in main () No locals. Current language: auto; currently asm (gdb) Thanks, Bala On Sat, Nov 27, 2010 at 4:36 PM, Balamurugan Mahendran < balamuru...@adaptavant.com> wrote: > I can give you access to my Instance

Re: [BUGS] BUG #5773: DEBUG: reaping dead processes DEBUG: server process (PID 10007) was terminated by signal 11: Segme

2010-11-27 Thread Balamurugan Mahendran
I can give you access to my Instance, if you would like to try. you just need to give me your IP, so that I can white list to allow access. Thanks, Bala On Sat, Nov 27, 2010 at 4:33 PM, Craig Ringer wrote: > On 11/27/2010 06:58 PM, Balamurugan Mahendran wrote: > >> (gdb) bt >>

Re: [BUGS] BUG #5773: DEBUG: reaping dead processes DEBUG: server process (PID 10007) was terminated by signal 11: Segme

2010-11-27 Thread Balamurugan Mahendran
(gdb) bt #0 strlen () at ../sysdeps/x86_64/strlen.S:48 #1 0x in ?? () (gdb) #0 strlen () at ../sysdeps/x86_64/strlen.S:48 #1 0x in ?? () (gdb) Thanks, Bala On Sat, Nov 27, 2010 at 4:25 PM, Craig Ringer wrote: > On 11/27/2010 05:45 PM, Balamurugan Mahend

Re: [BUGS] BUG #5773: DEBUG: reaping dead processes DEBUG: server process (PID 10007) was terminated by signal 11: Segme

2010-11-27 Thread Balamurugan Mahendran
enied. in ../sysdeps/x86_64/strlen.S (gdb) Current language: auto; currently asm Thanks, Bala On Sat, Nov 27, 2010 at 2:55 PM, Craig Ringer wrote: > On 27/11/2010 5:09 PM, Balamurugan Mahendran wrote: > >> Thanks for your immediate reply!!. Happy Thanks Giving day!! >&

Re: [BUGS] BUG #5773: DEBUG: reaping dead processes DEBUG: server process (PID 10007) was terminated by signal 11: Segme

2010-11-27 Thread Balamurugan Mahendran
Thanks for your immediate reply!!. Happy Thanks Giving day!! postg...@acti-db-bala:~$ uname -a Linux acti-db-bala 2.6.16.33-xenU #2 SMP Wed Aug 15 17:27:36 SAST 2007 x86_64 GNU/Linux postg...@acti-db-bala:~$ cat /etc/issue Ubuntu 9.04 \n \l Also I used to compile by the below command ./configu