Re: [Solved] SQL Server to PostgreSQL

Поиск
Список
Период
Сортировка
От Ian Turner
Тема Re: [Solved] SQL Server to PostgreSQL
Дата
Msg-id Pine.LNX.4.21.0009021817420.4481-100000@crafter.house
обсуждение исходный текст
Ответ на Re: [Solved] SQL Server to PostgreSQL  (Jan Wieck <janwieck@Yahoo.com>)
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: PL/Perl compilation error
Следующее
От: Mark Kirkwood
Дата:
Сообщение: RE:7.1 Release date ( Actually 7.1 Upgrade )