On 01/23/2011 04:38 AM, Andrus Moor wrote:
Scott,
Thank you.
I know you're running windows, but if you can get bash working on it,
here's a simple bash script I wrote that when it detects too many
people connected creates a table called pg_stat_bk_20110120140634
(i.e. date and time) so I can t
Scott,
Thank you.
I know you're running windows, but if you can get bash working on it,
here's a simple bash script I wrote that when it detects too many
people connected creates a table called pg_stat_bk_20110120140634
(i.e. date and time) so I can then look over what was in
pg_stat_activity w
I know you're running windows, but if you can get bash working on it,
here's a simple bash script I wrote that when it detects too many
people connected creates a table called pg_stat_bk_20110120140634
(i.e. date and time) so I can then look over what was in
pg_stat_activity when things were acting
Andy,
Then answer these questions:
Does ram using increase over the week?
Server was re-started yesterday and there was little use after restart.
server is idle. Task Manager shows now
PF Usage 1.22 GB
Physical Memory (K)
Total 4191872
Avail 348 (last 4 vary)
System cache 35676xx (last
On 01/22/2011 03:00 AM, Andrus Moor wrote:
Andy,
How to automatically re-start postgres service in every night ? Or is it
better to switch to 32bit server?
Neither. You need to fix the problem.
How to configure postgres so that freeze issue can addressed ?
E.q. if query runs more that 60 se
Andy,
How to automatically re-start postgres service in every night ? Or is it
better to switch to 32bit server?
Neither. You need to fix the problem.
How to configure postgres so that freeze issue can addressed ?
E.q. if query runs more that 60 seconds, postgres dumps its status and long
To add to this.
Is there a backup being done? Maybe not pg_dump but some Windows backup
program?
Yes yes... or antivirus full scan kicking off?
There is no antivirus installed.
Windows scheduler contains only one task which runs pg_dump at 2:00 every
morning.
Dump takes few minutes to run
On 1/21/2011 9:43 AM, Andrus wrote:
Andy,
Does PG start swapping to disk?
Earlier I used Stack builder to optimize Postgres as dedicated server.
MS SQL server was installed afterwards.
In this case message
"System is out of virtual memory". Windows is increasing the swap file
size. During thi
Andy,
Does PG start swapping to disk?
Earlier I used Stack builder to optimize Postgres as dedicated server. MS
SQL server was installed afterwards.
In this case message
"System is out of virtual memory". Windows is increasing the swap file size.
During this memory requests from applicatio
In response to "Andrus" :
> PostgreSQL 9.0.1, compiled by Visual C++ build 1500, 64-bit
> is installed in Windows 2008 server and servers 23 users in LAN 10 hours per
> work day.
>
> Approx once per week server stops responding: Users are waiting 4 minutes
> for query to complete but nothing ha
On 1/21/2011 9:21 AM, Adrian Klaver wrote:
On Friday 21 January 2011 7:13:23 am Andy Colson wrote:
On 1/21/2011 7:16 AM, Andrus wrote:
PostgreSQL 9.0.1, compiled by Visual C++ build 1500, 64-bit
is installed in Windows 2008 server and servers 23 users in LAN 10 hours
per work day.
Approx once
On Friday 21 January 2011 7:13:23 am Andy Colson wrote:
> On 1/21/2011 7:16 AM, Andrus wrote:
> > PostgreSQL 9.0.1, compiled by Visual C++ build 1500, 64-bit
> > is installed in Windows 2008 server and servers 23 users in LAN 10 hours
> > per work day.
> >
> > Approx once per week server stops resp
On 1/21/2011 7:16 AM, Andrus wrote:
PostgreSQL 9.0.1, compiled by Visual C++ build 1500, 64-bit
is installed in Windows 2008 server and servers 23 users in LAN 10 hours
per work day.
Approx once per week server stops responding: Users are waiting 4
minutes for query to complete but nothing happe
PostgreSQL 9.0.1, compiled by Visual C++ build 1500, 64-bit
is installed in Windows 2008 server and servers 23 users in LAN 10 hours per
work day.
Approx once per week server stops responding: Users are waiting 4 minutes
for query to complete but nothing happens.
If postgres service is re-st
14 matches
Mail list logo
