Re: [PATCHES] TODO Item - Add system view to show free space map

2005-10-27 Thread Mark Kirkwood
Christopher Kings-Lynne wrote: Want to host it on pgfoundry until 8.2 is released? Absolutely - I'll let it run the gauntlet of freedback to fix the silly mistakes I put in :-), then do patches for 8.1 and 8.0 (maybe 7.4 and 7.3 as well - if it rains a lot). cheers Mark

Re: [PATCHES] TODO Item - Add system view to show free space map

2005-10-27 Thread Christopher Kings-Lynne
Want to host it on pgfoundry until 8.2 is released? Mark Kirkwood wrote: This patch implements a view to display the free space map contents - e.g : regression=# SELECT c.relname, m.relblocknumber, m.blockfreebytes FROM pg_freespacemap m INNER JOIN pg_class c

Re: [PATCHES] TODO Item - Add system view to show free space map

2005-10-27 Thread Mark Kirkwood
Jim C. Nasby wrote: Shouldn't the DDL in pg_freespacemap.sql.in be wrapped in a transaction? Specifically I'm considering the case of the script stopping before the REVOKEs. That's nice, (probably should have done it in pg_buffercache )! ---(end of broadcast)---

Re: [PATCHES] TODO Item - Add system view to show free space map contents

2005-10-27 Thread Jim C. Nasby
Shouldn't the DDL in pg_freespacemap.sql.in be wrapped in a transaction? Specifically I'm considering the case of the script stopping before the REVOKEs. -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.comwork: 512-231-6117 vcard: htt

[PATCHES] TODO Item - Add system view to show free space map contents

2005-10-27 Thread Mark Kirkwood
This patch implements a view to display the free space map contents - e.g : regression=# SELECT c.relname, m.relblocknumber, m.blockfreebytes FROM pg_freespacemap m INNER JOIN pg_class c ON c.relfilenode = m.relfilenode LIMIT 10; relname |

Re: [PATCHES] A script to make some bug report easier

2005-10-27 Thread Qingqing Zhou
On Thu, 27 Oct 2005, Tom Lane wrote: > > Does that actually work? On most of the platforms I use, gdb doesn't > get far with only a core file, you have to tell it which executable file > to reference. Yeah, it works. There is a command in the script like: file ./postgres > Worse, many d

Re: [PATCHES] A script to make some bug report easier

2005-10-27 Thread Tom Lane
Qingqing Zhou <[EMAIL PROTECTED]> writes: > I wrote a small script to make PostgreSQL bug report easier. It prints the > uname, pg_config and try to backtrace all core dumps in data directory. Does that actually work? On most of the platforms I use, gdb doesn't get far with only a core file, you

Re: [PATCHES] [HACKERS] expanded \df+ display broken in beta4

2005-10-27 Thread Bruce Momjian
Bruce Momjian wrote: > Michael Paesold wrote: > > Bruce Momjian wrote: > > > Michael Paesold wrote: > > > > > >>Tom Lane wrote: > > >> > > >>>"Michael Paesold" <[EMAIL PROTECTED]> writes: > > >>> > > Robert Treat wrote: > > > > >ISTM even a GUC to enable/disable would have been better

[PATCHES] A script to make some bug report easier

2005-10-27 Thread Qingqing Zhou
I wrote a small script to make PostgreSQL bug report easier. It prints the uname, pg_config and try to backtrace all core dumps in data directory. Also, it provides a mode which you can interact with gdb. Put this shell script together in PG bin directory with other executables. It does not cover