Skip site navigation (1) Skip section navigation (2)

Index row maximum size and crash

From: "Daniel Caune" <daniel(dot)caune(at)ubisoft(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Index row maximum size and crash
Date: 2006-07-27 19:30:19
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin

I try to create an index on character varying(64) column but PostgreSQL
complains that the index row size reaches the maximum limit:

  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


pgsql-admin by date

Next:From: Jeff FrostDate: 2006-07-27 19:35:32
Subject: Re: [SQL] PostgreSQL server terminated by signal 11
Previous:From: Daniel CauneDate: 2006-07-27 19:27:55
Subject: Re: [SQL] PostgreSQL server terminated by signal 11

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group