[EMAIL PROTECTED] writes:
> While exploring this problem, I've noticed that one of the frequent insert
> processes creates a few temporary tables to do post-processing. Is it
> possible that the stats collector is getting bloated with stats from these
> short-lived temporary tables? During period
> Benjamin Minshall <[EMAIL PROTECTED]> writes:
>> Tom Lane wrote:
>>> How many tables are visible in the pg_stats views?
>
>> There are about 15 databases in the cluster each with around 90 tables.
>> A count of pg_stats yields between 500 and 800 rows in each database.
>
> Sorry, I was imprecis
Benjamin Minshall <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> How many tables are visible in the pg_stats views?
> There are about 15 databases in the cluster each with around 90 tables.
> A count of pg_stats yields between 500 and 800 rows in each database.
Sorry, I was imprecise. The v
Tom Lane wrote:
Benjamin Minshall <[EMAIL PROTECTED]> writes:
Seems the problem may be related to a huge global/pgstat.stat file.
Under 8.1.5 it was about 1 MB; now it's 90 MB in 8.2.3.
Yoi. We didn't do anything that would bloat that file if it were
storing the same information as before. W
Benjamin Minshall <[EMAIL PROTECTED]> writes:
> Seems the problem may be related to a huge global/pgstat.stat file.
> Under 8.1.5 it was about 1 MB; now it's 90 MB in 8.2.3.
Yoi. We didn't do anything that would bloat that file if it were
storing the same information as before. What I'm betting
Tom Lane wrote:
Benjamin Minshall <[EMAIL PROTECTED]> writes:
Tom Lane wrote:
Can you gather some info about what it's doing?
strace'ing the stats collector might prove interesting, also if you have
built it with --enable-debug then oprofile results would be helpful.
I will gather some strace
Benjamin Minshall <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> Can you gather some info about what it's doing?
>> strace'ing the stats collector might prove interesting, also if you have
>> built it with --enable-debug then oprofile results would be helpful.
> I will gather some strace info la
Tom Lane wrote:
OK, I was trying to correlate it with post-8.2.0 patches but evidently
that's the wrong tree to bark up. No, this isn't an expected behavior.
I talked with a co-worker and discovered that we went from 8.1.5 to
8.2.2, ran a few hours then went to 8.2.3 after the patch was rele
Benjamin Minshall <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> Benjamin Minshall <[EMAIL PROTECTED]> writes:
>>> Since upgrading to 8.2.3 yesterday, the stats collector process has had
>>> very high CPU utilization; it is consuming roughly 80-90% of one CPU.
>>> The server seems a lot more sl
Tom Lane wrote:
Benjamin Minshall <[EMAIL PROTECTED]> writes:
Since upgrading to 8.2.3 yesterday, the stats collector process has had
very high CPU utilization; it is consuming roughly 80-90% of one CPU.
The server seems a lot more sluggish than it was before. Is this normal
operation for 8.2
Hi,
One of our database server is getting some very high response times and I´m
wondering what can be responsible for this issue.
A strange behaviour in this server is the saturation number iostat is
giving, an average of 20% for only 140 wkB/s or can I consider them normal
numbers?
It is a Fedo
Benjamin Minshall <[EMAIL PROTECTED]> writes:
> Since upgrading to 8.2.3 yesterday, the stats collector process has had
> very high CPU utilization; it is consuming roughly 80-90% of one CPU.
> The server seems a lot more sluggish than it was before. Is this normal
> operation for 8.2 or someth
[EMAIL PROTECTED] wrote:
> Hi all,
>
> I'm fairly new to SQL, so this is probably a dumb way to form this
> query, but I don't know another.
>
> I want to see the usernames of all the users who have logged on
> today. "users" is my table of users with id's and username's.
> "session_stats" is m
Greetings,
Since upgrading to 8.2.3 yesterday, the stats collector process has had
very high CPU utilization; it is consuming roughly 80-90% of one CPU.
The server seems a lot more sluggish than it was before. Is this normal
operation for 8.2 or something I should look into correcting?
stat
14 matches
Mail list logo
