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