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...
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 |