Re: Database Bloat

On 08/20/12 11:46 AM, elliott wrote:
> envdb=# \d astgtm2_n60e073;
> Table "public.astgtm2_n60e073"
> Column | Type | Modifiers
> --------+---------+-----------
> lat | real |
> lon | real |
> alt | integer |
> Indexes:
> "q3c_astgtm2_n60e073_idx" btree (q3c_ang2ipix(lon, lat)) CLUSTER

so, you DO have an index. what type does this function
q3c_ang2ipix(real,real) return ? googling it suggested a bigint, which
means every 12 byte (real,real,int) row has a corresponding b-tree entry
of 8 bytes plus b-tree stuff. I see you used cluster on this, did you
do the CLUSTER after populating the table, and before checking the
pg_total_relation_size that you reported as 20X your data ?

--
john r pierce N 37, W 122
santa cruz ca mid-left coast