Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Out of Memory - 8.2.4
- 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: Tue, 28 Aug 2007 21:47:00 -0400
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!
- References:
- Out of Memory - 8.2.4
- From: Jeff Amiel
- Re: Out of Memory - 8.2.4
- From: Marko Kreen
- Re: Out of Memory - 8.2.4
- From: Alvaro Herrera
- Re: Out of Memory - 8.2.4
- From: Tom Lane
- Re: Out of Memory - 8.2.4
- From: Alvaro Herrera
- Re: Out of Memory - 8.2.4
- From: Tom Lane
- Out of Memory - 8.2.4
- Prev by Date: Re: Out of Memory - 8.2.4
- Next by Date: Re: Seeking datacenter PITR backup suggestions
- Previous by thread: Re: Out of Memory - 8.2.4
- Next by thread: Re: Out of Memory - 8.2.4
- Indexes: