From: | Philip Molter <philip(at)datafoundry(dot)net> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Changing optimizations |
Date: | 2001-07-05 18:56:17 |
Message-ID: | 20010705135617.B12723@datafoundry.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thu, Jul 05, 2001 at 02:24:07PM -0400, Tom Lane wrote:
: Philip Molter <philip(at)datafoundry(dot)net> writes:
: > Is there anything I should specifically be looking for?
:
: The only guess I have at the moment is that maybe the stacommonval
: (most common value) of the 'deleted' or 'running' column matches the
: query in one state and not the other. But please, just send along the
: output, even if you don't understand what it means.
When the system changes behavior, I'll send the one before and the one
after (it's running hourly right now).
: Come to think of it, the same stats for perceptType would be interesting
: to look at too.
Added, although perceptType never changes (no database operations are
performed on that table outside of SELECTs).
* Philip Molter
* DataFoundry.net
* http://www.datafoundry.net/
* philip(at)datafoundry(dot)net
From | Date | Subject | |
---|---|---|---|
Next Message | Jan Wieck | 2001-07-05 19:00:59 | Re: pgsql and sql-relay |
Previous Message | Tom Lane | 2001-07-05 18:24:07 | Re: Changing optimizations |