
Hello all,

sometimes I have got a problem with one of my tables.

It has got 25 columns, one unique key and an additional index.
There are about 368.000 rows in this particular table.

Sometimes after running for several days the table is corrupted.

If the tablename is "tablename" and the column-names are "a"-"z"
I can for example do a "select a,b,c from tablename where a like '0101%'"
without problem. But I can't do a "select a,b,c,x" from tablename where a
like '0101%'"

Running a "vacuum tablename" didn't help. Dropping and recreating the
indexes didn't help,
then finally a "vacuum full tablename" did the job and I could do all
selects as usual
again.

I had this the last time about three days ago, using 7.2-1-72.
I updated to 7.2.1 only two days ago. Do you know if this problem is solved
in the
latest release allready?

BTW: Using postgresql for several years I noticed that it was worth dropping
and recreating
the indexes once per week. Do you still recommend this? Before, I had a
major performance-
loss if I didn't recreate the indexes once per week.



Mit freundlichem Gruï¿½

Henrik Steffen
Geschï¿½ftsfï¿½hrer

top concepts Internetmarketing GmbH
Am Steinkamp 7 - D-21684 Stade - Germany
--------------------------------------------------------
http://www.topconcepts.com          Tel. +49 4141 991230
mail: steffen@topconcepts.com       Fax. +49 4141 991233
--------------------------------------------------------
24h-Support Hotline:  +49 1908 34697 (EUR 1.86/Min,topc)
--------------------------------------------------------
System-Partner gesucht: http://www.franchise.city-map.de
--------------------------------------------------------
Handelsregister: AG Stade HRB 5811 - UstId: DE 213645563
--------------------------------------------------------



Wed, 29 May 2002 10:56:56 +0200
"Henrik Steffen" <steffen@city-map.de>
Backend died abnormally
"Henrik Steffen" <steffen@city-map.de> writes:
> sometimes I have got a problem with one of my tables.

If you are getting a backend coredump, please provide a stack backtrace.

			regards, tom lane

Wed, 29 May 2002 08:47:23 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: Backend died abnormally 