| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Marko Kreen <markokr(at)gmail(dot)com>, Jeff Amiel <becauseimjeff(at)yahoo(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Out of Memory - 8.2.4 |
| Date: | 2007-08-29 01:47:00 |
| Message-ID: | 20070829014700.GF22033@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Tom Lane escribió:
> Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> >> Given that the worst-case consequence is extra index vacuum passes,
> >> which don't hurt that much when a table is small, maybe some smaller
> >> estimate like 100 TIDs per page would be enough. Or, instead of
> >> using a hard-wired constant, look at pg_class.reltuples/relpages
> >> to estimate the average tuple density ...
>
> > This sounds like a reasonable compromise.
>
> Do you want to make it happen?
OK, I'll work on it tomorrow.
--
Alvaro Herrera http://www.PlanetPostgreSQL.org/
Hi! I'm a .signature virus!
cp me into your .signature file to help me spread!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-08-29 01:54:23 | Re: Seeking datacenter PITR backup suggestions |
| Previous Message | Tom Lane | 2007-08-29 01:45:29 | Re: Out of Memory - 8.2.4 |