Re: [HACKERS] what could cause this PANIC on enterprise 7.3.4 db?

2003-11-10 Thread Andriy Tkachuk
TED]:~>date Mon Nov 10 10:49:50 EET 2003 [10:49]/2:[EMAIL PROTECTED]:~>uname -sr Linux 2.4.18-5custom On Fri, 7 Nov 2003, Tom Lane wrote: > Andriy Tkachuk <[EMAIL PROTECTED]> writes: > > Nov 5 20:22:42 monstr postgres[16071]: [3] PANIC: open of > > /usr/local/pgsq

Re: [HACKERS] what could cause this PANIC on enterprise 7.3.4 db?

2003-11-07 Thread Andriy Tkachuk
sorry , guys, for my english i meant "enterprise db" in subj, not enterprice :) On Fri, 7 Nov 2003, Andriy Tkachuk wrote: > Usually db works fine & stable months, but couple days ago > it was PANIC, and i have no ideas why this happen. > > Nov 5 20:22:30 monst

[HACKERS] what could cause this PANIC on enterprice 7.3.4 db?

2003-11-07 Thread Andriy Tkachuk
x27;ve used to check it at night time from cron like this: cat /dev/hda > /dev/null), so i have no idea why pg didn't find this file (see error from log). Does someone? system is: Linux 2.4.18-5 (RH) Thank you, Andriy Tkachuk. -- http://www.imt.com.ua --

[HACKERS] query speed depends on lifetime of frozen db?

2002-09-28 Thread Andriy Tkachuk
Hi hackers. There is ineresting behavior of some select query mentioned in $subj. In working db this query takes: real3m10.219s user0m0.074s sys 0m0.074s it's interesting that vacuum or analyze or reinex not helpfull, BUT if dump this db and create it again (whith another name mabe