Re: pgstat wait timeout (by Robert Schnabel)

On Wed, Dec 16, 2009 at 9:03 PM, Craig Ringer
<craig(at)postnewspapers(dot)com(dot)au> wrote:
> On 16/12/2009 11:55 PM, Robert Haas wrote:
>>
>> On Wed, Dec 16, 2009 at 10:45 AM, Magnus Hagander<magnus(at)hagander(dot)net>
>>  wrote:
>>>
>>> On Wed, Dec 16, 2009 at 16:12, Tom Lane<tgl(at)sss(dot)pgh(dot)pa(dot)us>  wrote:
>>>>
>>>> Alvaro Herrera<alvherre(at)commandprompt(dot)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.

I don't think that's it exactly. What I think would be really useful
is a page that is linked off the main page or some other reasonably
prominent place that lists useful resources by topic. I guess the
category interface could do that if it were maintained, but just
"which pages are good" is not quite what I had in mind.

...Robert