| From: | Alexei Vladishev <alex(at)gobbo(dot)caves(dot)lv> |
|---|---|
| To: | pgsql-admin(at)postgreSQL(dot)org |
| Subject: | Strange behaviour |
| Date: | 1998-09-10 06:12:52 |
| Message-ID: | Pine.LNX.3.96.980910085619.10583A-100000@gobbo.caves.lv |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Greetings,
I have an aplication which do pretty much updates/selects on table TABLE.
(about 3-6 updates/selects in a sec.). The TABLE has an unique index, lets
call it INDEX. It seems than everything works OK. But after 4-7 hours I
get the following errors from the application - PGresult is null, Backend
died... After a couple of days of investigation I understood that the
problem is in indexe, because it dies on SELECT * FROM TABLE WHERE
zzz=33; and zzz is the unique key of the table. After dropping index and
recreating one problem disappers.
Is there a patch to heal postgres ? Can anyone help me ?
Thanks
I am running Postgresql 6.3.2+Btree patch on Intel Linux 2.0.32 (RedHat
5.0).
Yours sincerely,
Alexei Vladishev
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lorenzo Huerta | 1998-09-10 13:27:38 | Re: [ADMIN] Strange behaviour |
| Previous Message | John Palmer | 1998-09-07 15:26:24 | Help ... |