Re: pgstat wait timeout (by Robert Schnabel)

On 16/12/2009 11:55 PM, Robert Haas wrote:
> On Wed, Dec 16, 2009 at 10:45 AM, Magnus Hagander<magnus@hagander.net>  wrote:
>> On Wed, Dec 16, 2009 at 16:12, Tom Lane<tgl@sss.pgh.pa.us>  wrote:
>>> Alvaro Herrera<alvherre@commandprompt.com>  writes:
>>>> Alexey Luchko wrote:
>>>>> postgres.exe!mdpostckpt+0x181b38
>>>>> postgres.exe!mdpostckpt+0x18bbdb
>>>
>>>> This stack trace seems bogus.  The stats collector should not be calling
>>>> mdpostckpt at all.
>>>
>>> Given the size of the offsets, it's pretty clear that it's not actually
>>> in mdpostckpt at all.  Probably this is a stripped executable and
>>> mdpostckpt is just the nearest global symbol.
>>
>> If that is so, the OP should follow:
>> http://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Windows
>>
>> specifically the part about symbols.
>>
>> Which it certainly looks like :)
>
> We should really take some of the vast quantity of really useful
> information that is in the wiki and try to index it somehow or
> incorporate it into the docs.  I'm always learning about new pages
> that have good stuff on them, but I never seem to stumble across them
> organically.

MediaWiki offers features to make this a lot easier. The categories
feature in particular is great: go to the page:

    Category:Blah

and you'll see a listing of all pages containing a link to
[[Category:Blah]]. The existing list of all categories can be found via
the "special pages" link in the sidebar:

   http://wiki.postgresql.org/wiki/Special:Categories

A "favourite" or "highlight" category would be one way to do what you're
talking about.

--
Craig Ringer