Re: [Solved] SQL Server to PostgreSQL

From: Jan Wieck <janwieck(at)Yahoo(dot)com>
To: adam(dot)rossi(at)platinumsolutions(dot)com
Cc: "Ian Turner" <vectro(at)pipeline(dot)com>, "Jan Wieck" <janwieck(at)Yahoo(dot)com>, "Martin Christensen" <knightsofspamalot-factotum(at)mail1(dot)stofanet(dot)dk>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: [Solved] SQL Server to PostgreSQL
Date: 2000-09-03 14:02:51
Message-ID: SAK.2000.09.03.aoractap@acr1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

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(at)Yahoo(dot)com #

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2000-09-03 14:03:08 Re: [Solved] SQL Server to PostgreSQL
Previous Message Jan Wieck 2000-09-03 09:03:31 Re: [Solved] SQL Server to PostgreSQL

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2000-09-03 14:03:08 Re: [Solved] SQL Server to PostgreSQL
Previous Message Jan Wieck 2000-09-03 09:03:31 Re: [Solved] SQL Server to PostgreSQL