Обсуждение: System tables
Hi ! I've got trivial question : what are system table names ? Do system tables store access statistics ? Regards, Fabian
System tables are all tables starting with pg_. They store everything about your database installation, such as name of the actual databases, tables, attribute types, rules, indexes, what-have-you. Access statistics as in "How many times did table x get accessed since then" are not stored anywhere, at least not where you could make use of it. On Mon, 17 Jan 2000 Fabian.Frederick@prov-liege.be wrote: > > Hi ! > I've got trivial question : what are system table names ? > Do system tables store access statistics ? > > Regards, Fabian > > ************ > > -- Peter Eisentraut Sernanders vaeg 10:115 peter_e@gmx.net 75262 Uppsala http://yi.org/peter-e/ Sweden
> System tables are all tables starting with pg_. They store everything > about your database installation, such as name of the actual databases, > tables, attribute types, rules, indexes, what-have-you. Access statistics > as in "How many times did table x get accessed since then" are not stored > anywhere, at least not where you could make use of it. psql \dS shows you the system tables. -- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026