"Gnanakumar" writes:
> Does PostgreSQL establish working UDP sockets on some specific defined port
> or it chooses the port randomly?
The stats collector socket is opened on whatever port bind() chooses to
assign.
regards, tom lane
--
Sent via pgsql-admin mailing list (
>> Does stats collector process need any other special
>> resource/privilege/operations/port to start?
> If I understand correctly, it uses UDP. I don't think PostgreSQL
> uses UDP outside of that.
Still I'm not able to resolve/fix this statistics collector (not
starting/working) in one of our
"Gnanakumar" wrote:
> Does stats collector process need any other special
> resource/privilege/operations/port to start?
If I understand correctly, it uses UDP. I don't think PostgreSQL
uses UDP outside of that.
-Kevin
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Statistics Collector not collecting server activities
"Gnanakumar" wrote:
> As you said, I notice the following in postmaster log:
> 2010-04-08 17:30:41 ISTLOG: could not receive test message on
> socket for statistics
"Gnanakumar" wrote:
> As you said, I notice the following in postmaster log:
> 2010-04-08 17:30:41 ISTLOG: could not receive test message on
> socket for statistics collector: Connection refused
> 2010-04-08 17:30:41 ISTLOG: disabling statistics collector for
> lack of working socket
>
> What
l.org
Subject: Re: [ADMIN] Statistics Collector not collecting server activities
"Gnanakumar" writes:
> I'm also seeing a weird thing. If I do 'show stats_start_collector;'
inside
> psql, it says 'off'.
Yeah, this is the expected state if the collector
"Gnanakumar" writes:
> I'm also seeing a weird thing. If I do 'show stats_start_collector;' inside
> psql, it says 'off'.
Yeah, this is the expected state if the collector fails to start for
some reason. Look into the postmaster log for a startup-time message
indicating why; but again, I'll bet
I'm also seeing a weird thing. If I do 'show stats_start_collector;' inside
psql, it says 'off'.
I've also restarted my server many times after making all the changes.
As per 8.2 doc,
http://www.postgresql.org/docs/8.2/interactive/runtime-config-statistics.htm
l, stats_start_collector is o
"Gnanakumar" writes:
>> But still, if I query after performing heavy DML operations, I'm always
>> getting zero, even though there are INSERT/UPDATE/DELETE.
Is the stats collector actually running according to "ps"? If not, look
in the postmaster log to see why it failed (problems creating the
c
an this for the entire tables in the database.
-Original Message-
From: Guillaume Lelarge [mailto:guilla...@lelarge.info]
Sent: Wednesday, March 31, 2010 5:57 PM
To: gna...@zoniac.com
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Statistics Collector not collecting server activities
L
Le 31/03/2010 12:51, Gnanakumar a écrit :
> After restarting PostgreSQL, I can see the following parameters are set to
> ON:
> mydb=# show stats_start_collector;
> stats_start_collector
> ---
> on
> (1 row)
>
> mydb=# show stats_start_collector;
> stats_start_collector
> ---
gna...@zoniac.com
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Statistics Collector not collecting server activities
Le 31/03/2010 11:14, Gnanakumar a écrit :
> OK. I'll try that way.
>
> But, as per 8.2 doc, by default it is ON. So if I comment with just '#'
> i
Le 31/03/2010 11:14, Gnanakumar a écrit :
> OK. I'll try that way.
>
> But, as per 8.2 doc, by default it is ON. So if I comment with just '#'
> infront of the parameter, and restart PostgreSQL, this change will not be
> reflected, which means it should work with default value ON?
Yes, you're ri
[mailto:guilla...@lelarge.info]
Sent: Wednesday, March 31, 2010 2:35 PM
To: gna...@zoniac.com
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Statistics Collector not collecting server activities
Le 31/03/2010 10:58, Gnanakumar a écrit :
> Im also seeing a weird thing. If I do show sta
Le 31/03/2010 10:58, Gnanakumar a écrit :
> I’m also seeing a weird thing. If I do ‘show stats_start_collector;’ inside
> psql, it says ‘off’.
>
> I’ve also restarted my server many times after making all the changes.
>
> As per 8.2 doc,
> http://www.postgresql.org/docs/8.2/interactive/runtime-c
default.
-Original Message-
From: Guillaume Lelarge [mailto:guilla...@lelarge.info]
Sent: Wednesday, March 31, 2010 1:02 PM
To: gna...@zoniac.com
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Statistics Collector not collecting server activities
Le 31/03/2010 08:41, Gnanakumar a
Le 31/03/2010 08:41, Gnanakumar a écrit :
> Hi,
>
>
>
> Even though I've enabled statistics collector in our server, it is not
> collecting statistics, and because of this autovacuum is also not running as
> expected.
>
>
>
> PostgreSQL version 8.2
>
>
>
> Parameters enabled related to
Hi,
Even though I've enabled statistics collector in our server, it is not
collecting statistics, and because of this autovacuum is also not running as
expected.
PostgreSQL version 8.2
Parameters enabled related to this are:
# - Query/Index Statistics Collector -
#stats_command_str
18 matches
Mail list logo
