Project

General

Profile

Bug #2126

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

Added by Dominic Cleal over 9 years ago. Updated over 9 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
Database
Target version:
Difficulty:
Triaged:
No
Bugzilla link:
Pull request:
Fixed in Releases:
Found in Releases:

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.

Associated revisions

Revision be21218d (diff)
Added by Amos Benari over 9 years ago

fixes #2126 Large report messages won't fit in PostgreSQL's index_messages_on_value

History

#1 Updated by Ohad Levy over 9 years ago

  • Assignee changed from Ohad Levy to Amos Benari

#2 Updated by Ohad Levy over 9 years ago

  • Target version set to 1.1

#3 Updated by Amos Benari over 9 years ago

  • Status changed from New to Closed
  • % Done changed from 0 to 100

Also available in: Atom PDF