| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net> |
| Cc: | Neil Conway <neilc(at)samurai(dot)com>, PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org> |
| Subject: | Re: pg_avd |
| Date: | 2003-02-18 18:54:10 |
| Message-ID: | 200302181854.h1IIsAn17947@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-patches |
Matthew T. O'Connor wrote:
> > - using some of the ideas from contrib/pgstattuple (i.e. looking at the
> > amount of "dead space" in the relation) could be an interesting
> > enhancement.
>
> I did a little looking at this a while ago, it wasn't clear to me that
> pgstattuple was any faster than just doing a vacuum.
Someone reported that pg_stattuple is faster than COUNT(*), so it might
be faster than VACUUM. Actually, it is a loadable function, so it has
direct access to the backend area, while libpq does not. It might also
be interesting to create a function that can return the free space map
size for a relation. That would allow you to know when there is little
free space available for a table getting a lot of inserts.
Of course, I am just throwing out ideas, and they may not be good ones. :-)
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2003-02-18 19:04:47 | Re: postgres error reporting |
| Previous Message | Bruce Momjian | 2003-02-18 18:49:24 | Re: pg_avd |