Re: [Solved] SQL Server to PostgreSQL

Поиск
Список
Период
Сортировка
От Jan Wieck
Тема Re: [Solved] SQL Server to PostgreSQL
Дата
Msg-id 200009030903.EAA21252@jupiter.jw.home
обсуждение исходный текст
Ответ на Re: [Solved] SQL Server to PostgreSQL  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [Solved] SQL Server to PostgreSQL  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-general
Tom Lane wrote:
> Now that you mention it, though, doesn't TOAST break heapam's assumption
> that char(n) is fixed length?  Seems like we'd better either remove that
> assumption or mark char(n) nontoastable.  Any opinions which is better?

    Is  the  saved overhead from assuming char(n) is fixed really
    that big that it's worth NOT to gain  the  TOAST  advantages?
    After  the  GB  benchmarks  we  know  that we have some spare
    performance to waste for such things :-)


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #



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

Предыдущее
От: "Jeff Waugh"
Дата:
Сообщение: Re: Increasing system speed by using -F option
Следующее
От: Zlatko Calusic
Дата:
Сообщение: Indexes not working (bug in 7.0.2?)