

> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us] 
> Sent: 21 May 2002 16:33
> To: Dave Page
> Cc: pgsql-hackers@postgresql.org
> Subject: Re: [HACKERS] More schema queries 
> 
> 
> > What I cannot do is get it to show me anything useful.
> 
> It sounds like gdb does not have access to debugging symbol tables.
> 
> Firstly, did you compile with -g (configure --enable-debug)?

Yes, but when I read this I realised that I forget to 'make clean'
before rebuilding. Having done that I then found that gdb eats about
100Mb of memory and 50% of cpu without actually displaying itself until
killed 10 minutes later. I tried this twice - I guess that gdb under
cygwin has trouble with large exe's as my machine should handle it
(PIII-M 1.13GHz, 512Mb).

> Secondly, did you point gdb at the postgres executable when 
> you started it?

Yes, I added a 60 second wait to the appropriate part of initdb (-W 60).
I could also get a stack trace which showed that I had broken in
RangeVarGetCreationNamespace as intended.

Regards, Dave.

Tue, 21 May 2002 17:07:22 +0100
"Dave Page" <dpage@vale-housing.co.uk>
Re: More schema queries 
"Dave Page" <dpage@vale-housing.co.uk> writes:
> Yes, but when I read this I realised that I forget to 'make clean'
> before rebuilding. Having done that I then found that gdb eats about
> 100Mb of memory and 50% of cpu without actually displaying itself until
> killed 10 minutes later. I tried this twice - I guess that gdb under
> cygwin has trouble with large exe's as my machine should handle it
> (PIII-M 1.13GHz, 512Mb).

That's annoying.  gdb is quite memory-hungry when dealing with big
programs, but as long as you're not running out of memory or swap it
should work.  AFAIK anyway.  I remember having to compile only parts
of a big program with debug support, years ago on a machine that was
pretty small and slow by current standards.

If you can't get gdb to work then another possibility is the low-tech
approach: add some debugging printf's to RangeVarGetCreationNamespace.

			regards, tom lane

Tue, 21 May 2002 13:29:16 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: More schema queries 