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

From Ian Turner
Subject Re: [Solved] SQL Server to PostgreSQL
Date
Msg-id Pine.LNX.4.21.0009021817420.4481-100000@crafter.house
Whole thread Raw
In response to Re: [Solved] SQL Server to PostgreSQL  (Jan Wieck <janwieck@Yahoo.com>)
Responses Re: [Solved] SQL Server to PostgreSQL  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: [Solved] SQL Server to PostgreSQL  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

>     From  7.1  on  the  system  will  try  to  compress all types
>     internally stored as variable length (char(), varchar(), text
>     and  some  more). So the real amount of bytes for a char(188)
>     will be "at maximum 192 - probably less".

Don't variable-length records incur a performance overhead? In this case,
ought I be able to specify the length for a record if I know ahead of time
it will be the same in every case? :o

Ian Turner
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.1 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE5sabgfn9ub9ZE1xoRAhayAKCwMjh/5tYlg8zZiAimJlgFSfCLsQCghBce
Gxx6X8sSwIACIHvdbxBsgGQ=
=bogc
-----END PGP SIGNATURE-----


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: PL/Perl compilation error
Next
From: Mark Kirkwood
Date:
Subject: RE:7.1 Release date ( Actually 7.1 Upgrade )