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

From Jan Wieck
Subject Re: [Solved] SQL Server to PostgreSQL
Date
Msg-id SAK.2000.09.03.aoractap@acr1
Whole thread Raw
In response to Re: [Solved] SQL Server to PostgreSQL  (Tom Lane <tgl@sss.pgh.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: "Davide G. Borin"
Date:
Subject: PostgreSQL slow on Reiserfs?
Next
From: Michael Labhard
Date:
Subject: Error building JDBC Driver