Project

General

Profile

Actions
Copy link

Bug #2126

closed

Large report messages won't fit in PostgreSQL's index_messages_on_value

Added by Dominic Cleal almost 12 years ago. Updated almost 12 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Amos Benari
Category:
Database
Target version:
1.1
Difficulty:
Triaged:
Bugzilla link:
Pull request:
Fixed in Releases:
Found in Releases:
Red Hat JIRA:

Description

When converting a SQLite database to PostgreSQL, I was unable to import messages from my reports:

PG::Error: ERROR:  index row size 3352 exceeds maximum 2712 for index "index_messages_on_value" 
HINT:  Values larger than 1/3 of a buffer page cannot be indexed.
Consider a function index of an MD5 hash of the value, or use full text indexing.

The message contained large file diffs.

Actions
Copy link

Also available in: Atom PDF