Skip site navigation (1) Skip section navigation (2)

Re: FSM search modes

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Simon Riggs" <simon(at)2ndQuadrant(dot)com>, "decibel" <decibel(at)decibel(dot)org>
Cc: "Itagaki Takahiro" <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>, "pgsql-hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: FSM search modes
Date: 2009-09-30 22:13:04
Message-ID: 4AC391A0020000250002B4FD@gw.wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-hackers
decibel <decibel(at)decibel(dot)org> wrote: 
 
> *any* step that improves dealing with table bloat is extremely
> welcome, as right now you're basically stuck rebuilding the table.
 
+1
 
Although, possibly more irritating than actually rebuilding it is
evaluating borderline bloat situations to determine if they will "work
themselves out" over time or whether you need to bite the bullet to do
aggressive maintenance.  Having some way for routine vacuums (or any
other routine process, currently available or that could be scheduled)
to "nibble away" at moderate bloat without significant performance or
usability impact would make life easier for at least *some* DBAs.
 
-Kevin

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2009-09-30 22:50:46
Subject: Re: Unicode UTF-8 table formatting for psql text output
Previous:From: Tom LaneDate: 2009-09-30 21:32:25
Subject: Re: Unicode UTF-8 table formatting for psql text output

Privacy Policy | About PostgreSQL
Copyright © 1996-2013 The PostgreSQL Global Development Group