Re: text fields and performance for ETL - Mailing list pgsql-docs

From Tom Lane
Subject Re: text fields and performance for ETL
Date
Msg-id 137264.1635961048@sss.pgh.pa.us
Whole thread Raw
In response to RE: text fields and performance for ETL  (Grega Jesih <Grega.Jesih@actual-it.si>)
Responses Re: text fields and performance for ETL  (Grega Jesih <Grega.Jesih@actual-it.si>)
List pgsql-docs
Grega Jesih <Grega.Jesih@actual-it.si> writes:
>> The goal in our docs is to point out that using an arbitrary length specification is not required in PostgreSQL.

> Well perhaps yours. But there are pro-tools (I refer to SSIS in this context) that provide a very fast dataflow in
casethere is a known record size. 

That's a matter for those tools to document, not us, because it's their
performance characteristics that you are talking about, not ours.

I'll just point out in passing, though, that "fixed record size" for text
strings is an illusion as soon as you have to deal with non-ASCII data.
So I'm skeptical that such optimizations are worth much anymore.

            regards, tom lane



pgsql-docs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: text fields and performance for ETL
Next
From: Grega Jesih
Date:
Subject: Re: text fields and performance for ETL