2008/12/26 Gerhard Wiesinger :
> Hello Pavel,
>
> Works fine.
>
> Any ideas how to optimzize the function calls to one for the output
> parameters (multiple select from pgstattuple where only one part is used)?
postgres=# select schemaname, tablename, table_len, dead_tuple_count
from (select (pgs
Hello Pavel,
Works fine.
Any ideas how to optimzize the function calls to one for the output
parameters (multiple select from pgstattuple where only one part is used)?
I've included some selects which might be usefull for others, too.
Thnx.
Ciao,
Gerhard
--
http://www.wiesinger.com/
-
Hello
look on contrib module pg_stat_tuple
http://www.postgresql.org/docs/8.3/interactive/pgstattuple.html
regards
Pavel Stehule
2008/12/25 Gerhard Wiesinger :
> Hello!
>
> Is there some information in meta tables available about the number of pages
> currently unused, row versions of tables and
Hello!
Is there some information in meta tables available about the number of
pages currently unused, row versions of tables and indices which are
unused?
I'm asking because I want to measure how efficient HOT is working and
whether vacuum should be run or not saving diskspace (I know this i
