"Tuple is too big"

Поиск
Список
Период
Сортировка
От Steve Wolfe
Тема "Tuple is too big"
Дата
Msg-id 002f01bfd64a$3ee8ee80$85755ad1@iboats.com
обсуждение исходный текст
Ответ на Want to run PostgreSQL on new associative memory technology  ("Melchior, Tim" <Melchior@UTMC.Aeroflex.com>)
Список pgsql-general
   After moving a database to a new machine, I tried a vaccum analyze, and
get "ERROR:  Tuple is too big: size 8180, max size 8140".

  I know that there's a limit on the tuple size and all of that - my
question is:  How do I fix it?  Vaccum analyze barfs, as does trying "\d
table name".  I tried it on both machines, and the same thing.

  I suppose that I could write a parser to go through the pg_dump and find
offending fields, but I'm hoping that there's a way for PostgreSQL to fix
it.  If there isn't a way for it to fix data that it's created, that's
scary. : )  It is postgresql 6.5.3.

steve



В списке pgsql-general по дате отправления:

Предыдущее
От: Jeffery Collins
Дата:
Сообщение: Very large table...
Следующее
От: Franck Martin
Дата:
Сообщение: Library database ?