Re: [Solved] SQL Server to PostgreSQL - Mailing list pgsql-general

From Jan Wieck
Subject Re: [Solved] SQL Server to PostgreSQL
Date
Msg-id 200009030903.EAA21252@jupiter.jw.home
Whole thread Raw
In response to Re: [Solved] SQL Server to PostgreSQL  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [Solved] SQL Server to PostgreSQL  (Bruce Momjian <pgman@candle.pha.pa.us>)
List 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 by date:

Previous
From: "Jeff Waugh"
Date:
Subject: Re: Increasing system speed by using -F option
Next
From: Zlatko Calusic
Date:
Subject: Indexes not working (bug in 7.0.2?)