Alex Rivera | Logout

PostgreSQL Big Text Column Performance

Asked 2011-09-05T16:19:19.360
11

I am storing sent emails in a RDBMS including the to address, from address, and email body.

The body can really be any arbitrary amount of text, and I won't ever care to search on it.

Are there any performance issues I should worry about when having a potentially large column that isn't used too often in one of my most frequently accessed tables (Emails) ?

(This project is written in Rails)

postgresql rails-postgresql
Edit
Report

1 Answer

10

No, you don't need to worry about that.

Technically there is no difference in storage between a e.g. varchar(5) and a text column.

Quote from the manual

there is no performance difference among these three types, apart from increased storage space when using the blank-padded type

The three types mentioned there are char, varchar and text. Where char is the "blank-padded type".

answered 2011-09-05T16:55:32.907

Your Answer