| From: | Rajin Raj <rajin(dot)raj(at)opsveda(dot)com> |
|---|---|
| To: | pgsql-admin(at)lists(dot)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org |
| Subject: | PostgreSQL CHARACTER VARYING vs CHARACTER VARYING (Length) |
| Date: | 2020-04-28 09:22:07 |
| Message-ID: | CAOasRJYCUwMYdd=BL29TupW_iCbvM3YRM01YTB_WYSUEays3CA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-hackers |
Is there any impact of using the character varying without providing the
length while creating tables?
I have created two tables and inserted 1M records. But I don't see any
difference in pg_class. (size, relpage)
create table test_1(name varchar);
create table test_2(name varchar(50));
insert into test_1 ... 10M records
insert into test_2 ... 10M records
vacuum (full,analyze) db_size_test_1;
vacuum (full,analyze) db_size_test_2;
Which option is recommended?
*Regards,*
*Rajin *
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Holger Jakobs | 2020-04-28 09:43:39 | Re: PostgreSQL CHARACTER VARYING vs CHARACTER VARYING (Length) |
| Previous Message | Rui DeSousa | 2020-04-28 07:32:19 | Re: PostgreSQL DB checkpoint error! |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Amit Kapila | 2020-04-28 09:41:27 | Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions |
| Previous Message | Benjamin Schaller | 2020-04-28 08:43:27 | Raw device on PostgreSQL |