| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Chris Sutton <chris(at)smoothcorp(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: postgresql meltdown on PlanetMath.org |
| Date: | 2003-03-17 19:26:00 |
| Message-ID: | 7699.1047929160@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Chris Sutton <chris(at)smoothcorp(dot)com> writes:
> On Mon, 17 Mar 2003, Tom Lane wrote:
>> In CVS tip, a whole-database VACUUM VERBOSE gives info about the free
>> space map occupancy, eg
>> INFO: Free space map: 224 relations, 450 pages stored; 3776 total pages needed.
>> Allocated FSM size: 1000 relations + 20000 pages = 178 KB shared mem.
> How do you get this information?
Before CVS tip, you don't.
[ thinks...] Perhaps we could back-port the FSM changes into 7.3 ...
it would be a larger change than I'd usually consider reasonable for a
stable branch, though. Particularly considering that it would be hard
to call it a bug fix. By any sane definition this is a new feature,
and we have a policy against putting new features in stable branches.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Sullivan | 2003-03-17 19:47:38 | Re: postgresql meltdown on PlanetMath.org |
| Previous Message | Neil Conway | 2003-03-17 19:20:10 | Re: postgresql meltdown on PlanetMath.org |