Re: How to find greatest record before known values fast - Mailing list pgsql-general

From Andrus
Subject Re: How to find greatest record before known values fast
Date
Msg-id E76BD55BA17A47CA8748841291256F2E@dell2
Whole thread Raw
In response to Re: How to find greatest record before known values fast  (Merlin Moncure <mmoncure@gmail.com>)
Responses Re: How to find greatest record before known values fast  (Merlin Moncure <mmoncure@gmail.com>)
Re: How to find greatest record before known values fast  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Hi!

Thank you for explanations.

>  the char type pads out the fields on disk.

It looks like you wrote that char takes more disk space.

from

http://www.pgcon.org/2013/schedule/attachments/269_tour-of-postgresql-data-types.pdf

page 28:

Unlike    many
databases,    char(n)    is    NOT    stored    as    afixed-sizedfield
in    Postgres.    It    is    treated    exactly    the    sameas
varchar(n)except    for    being    padded

So char type does not take more space than varchar.

Andrus.



pgsql-general by date:

Previous
From: Vick Khera
Date:
Subject: Re: Really strange foreign key constraint problem blocking delete
Next
From: Merlin Moncure
Date:
Subject: Re: How to find greatest record before known values fast