Le mercredi 16 décembre 2009 à 06:18:45, Gurjeet Singh a écrit : > 2009/12/15 Guillaume Lelarge <guillaume@xxxxxxxxxxxx> > > > Le mardi 15 décembre 2009 à 00:04:47, Evan Rempel a écrit : > > > Is there a command/tool that will report on how FULL a table is > > > getting? If there is, how intrusive is it? How computationally heavy is > > > it? > > > > > > We have a database that is approx 100 million rows with > > > approx 2 million insert/updates per day. Each day old data > > > is purged from the database. The end result is a mostly static > > > footprint with regards to disk space used, but I would like to > > > know how much room is usable inside the tables as well as the > > > OS file system (that part is easy). > > > > pgstattuple contrib module give such an information. But it requires an > > exclusive lock on the table it's looking at, so it's quite intrusive. For > > more > > details, the 8.4 documentation is interesting: > > http://www.postgresql.org/docs/8.4/interactive/pgstattuple.html > > That doc specifically says that it takes only a read lock. > Ouch, I always thought it took an exclusive lock. Sorry. -- Guillaume. http://www.postgresqlfr.org http://dalibo.com -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
