"Josh Berkus" <josh@agliodbs.com> wrote > > While I'm waiting to figure out how to get the size of the toast table, at > > least I can provide the speed of query with/without assumed compression on > > the 6K text columns. > > Check out the table_size view in the newsysviews project. Andrew computed the > regular, toast, and index sizes as a query. >
Will pg_total_relation_size_oid()/pg_total_relation_size_name() do the job? Regards, Qingqing ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend