postgres instability?

From: Peter Vazsonyi <neko(at)kredit(dot)sth(dot)szif(dot)hu>
To: pgsql-admin(at)hub(dot)org
Subject: postgres instability?
Date: 2000-05-23 09:58:47
Message-ID: Pine.LNX.4.10.10005231112250.18625-100000@kredit.sth.szif.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi!

We use postgresql-6.5.2, on i386-linux (Rh.6.1), from 4-5 Xterminal, the
apllications, and postgres runs on the same machine.
there are approximately 30-40 inserts|updates /min.
The performance is pertty well... but there are many backend crash
(~10/day) ;(
And after a crash some dust remains: uninitialized pages in tables, wrong
indices..., and this dust generate a crash again. (if i not run a vacuum)
I tried, to dump-initdb-restart, but it doesn't help.
We use many user-defined functions (some C, but mostly plpgsql)
this under test circumstances (on another machine) works fine, and i trust
in postgres stability.

So:
Meet somebody with similar things?
How can i find the reasons posteriorly?
Can be the cause of the random backend smash broken hardware?
Other advices?

Thanks...

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Eisentraut 2000-05-23 13:03:41 Re: [PORTS] Re: [BUGS] port v7.0 to SGI-IRIX-6.5.7/64
Previous Message Loïc TREGOUËT 2000-05-23 07:42:03 select distinct inet bug