Hi,
I try to create an index on character varying(64) column but PostgreSQL
complains that the index row size reaches the maximum limit:
CREATE INDEX IDX_GSLOG_EVENT_ARCHIVE_GAME_CLIENT_VERSION
ON GSLOG_EVENT_ARCHIVE(GAME_CLIENT_VERSION);
ERROR: index row requires 198468548 bytes, maximum size is 8191
I was curious to know the maximum length I have for this column:
select max(game_client_version) from gslog_event_archive;
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
The server crashes again! Sniff! :-( Seems that the database is
corrupted somewhere, no?
--
Daniel CAUNE
Ubisoft Online Technology
(514) 490 2040 ext. 3613
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
