On Dienstag, 31. Juli 2007 Paul J Stevens wrote: > > # CREATE INDEX dbmail_headervalue_3 ON > > dbmail_headervalue(headervalue); FEHLER: Indexzeile benötigt 26104 > > Bytes, Maximalgröße ist 8191 > > > > Anybody got an idea what to do now? > > Nothing? In mysql you can do a index on the first x characters of a > field. I'm sure something similar is possible in pgsql, but I haven't > had time to figure it out yet. For now, just comment the line > involved. > > btw, FTI is not an option for the headervalue field.
OK, now that I know FTI, what do you want to tell me with the whole sentence? a) "is not an option" in the way of "must be done" b) "is not an option" in the way of "isn't used anyway" I wanted to create all indices that were missing, this one can't be created. While I thought it's because some headervalue lines are too long, that's obviously wrong: # UPDATE dbmail_headervalue set headervalue=substr(headervalue,0,8191) where length(headervalue) > 8191; UPDATE 4 # SELECT id from dbmail_headervalue where length(headervalue) > 8190; (0 Zeilen) # CREATE INDEX dbmail_headervalue_3 ON dbmail_headervalue(headervalue); FEHLER: Indexzeile benötigt 26104 Bytes, Maximalgröße ist 8191 Looks like there are too many similar headervalue entries to fit in the index, maybe we've got too much data? What to do now? mfg zmi -- // Michael Monnerie, Ing.BSc ----- http://it-management.at // Tel: 0676/846 914 666 .network.your.ideas. // PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import" // Fingerprint: EA39 8918 EDFF 0A68 ACFB 11B7 BA2D 060F 1C6F E6B0 // Keyserver: www.keyserver.net Key-ID: 1C6FE6B0
signature.asc
Description: This is a digitally signed message part.
_______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
