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 over 11 years ago. Updated about 11 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
 #1

Updated by Ohad Levy about 11 years ago

  • Assignee changed from Ohad Levy to Amos Benari
Actions
Copy link
 #2

Updated by Ohad Levy about 11 years ago

  • Target version set to 1.1
Actions
Copy link
 #3

Updated by Amos Benari about 11 years ago

  • Status changed from New to Closed
  • % Done changed from 0 to 100
Actions
Copy link

Also available in: Atom PDF