| From: | Reece Hart <reece(at)harts(dot)net> |
|---|---|
| To: | josh(at)agliodbs(dot)com |
| Cc: | sfpug(at)postgresql(dot)org |
| Subject: | Re: 8.1.4 planner index selection |
| Date: | 2006-06-21 05:24:26 |
| Message-ID: | 1150867466.17555.15.camel@whoville.site |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | sfpug |
On Mon, 2006-06-19 at 15:56 -0700, Josh Berkus wrote:
> How large is that mutli-colum index? Disk size? How much RAM do you
> have?
The table is 4.4GB per pg_relation_size. The pahmm_redundant_feature
index is around 2.7GB. df -h /srv says 500G 326G 175G 66%. The
box has 32GB of RAM.
The table probably has some deletes in it in case that's relevant, but
I'd guess no more than 25% of the rows were deleted once and it may be
0%. (I can't remember whether I did a bulk delete before or after the
dump/restore for 8.1 migration.)
-Reece
P.S. I went from 7.4.5 to 8.1.2 (IIRC) and skipped 8.0.x, so I don't
know what the 8.0.x series would have done.
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fred Moyer | 2006-06-22 05:12:52 | Re: Meeting details for June 22 South Bay meeting up |
| Previous Message | Reece Hart | 2006-06-21 05:11:36 | Re: 8.1.4 planner index selection |