Chris Campbell wrote: > On Jan 19, 2006, at 06:51, Magnus Hagander wrote: > > >In most cases you're going to see extremely few reads compared to > >writes > >on pg_stats, right? So why not have the backends connect to the stats > >process (or perhaps use UDP, or use the pipe, or whatever) and > >fetch the > >data when needed. So when nobody fetches any data, there is no > >overhead > >(except for the stats process adding up values, of course). > > Do the stats need to persist across postmaster restarts (or crashes)?
After a crash we forcibly _delete_ the stat file. OTOH, on clean shutdown it would be quite possible to write it (which would be the only time at which the file is written). -- Alvaro Herrera http://www.advogato.org/person/alvherre Licensee shall have no right to use the Licensed Software for productive or commercial use. (Licencia de StarOffice 6.0 beta) ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
