From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | depesz(at)depesz(dot)com |
Cc: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Strange problem with create table as select * from table; |
Date: | 2011-11-06 16:54:37 |
Message-ID: | 3967.1320598477@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
hubert depesz lubaczewski <depesz(at)depesz(dot)com> writes:
> checked lengths of the text/varchar columns in database.
> there are 16 such columns in the table.
> full report of lengths is in
> http://www.depesz.com/various/lengths.report.gz
> it was obtained using:
> select length( "first_text_column" ) as length_1, count(*) from etsy_v2.receipts group by 1 order by 1;
> and so on for every text column, and at the end I also made summary of
> sum-of-lengths.
BTW, that probably doesn't prove a lot since it takes no account of
compression, and different values could be compressible to varying
degrees. It'd be more useful to look at pg_column_size() numbers
to get an idea of whether toasting happened or not.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | stephaneg | 2011-11-06 17:11:10 | Re: installation problems on OSX Lion |
Previous Message | René Fournier | 2011-11-06 16:51:13 | Tuning PostgreSQL for very large database |
From | Date | Subject | |
---|---|---|---|
Next Message | J Smith | 2011-11-06 17:28:33 | unaccent extension missing some accents |
Previous Message | Tomas Vondra | 2011-11-06 15:57:50 | Re: [PATCH] optional cleaning queries stored in pg_stat_statements |