On 4/2/15 2:18 PM, TonyS wrote:
On Wed, April 1, 2015 5:50 pm, Tom Lane-2 [via PostgreSQL] wrote:
TonyS [hidden email]
/user/SendEmail.jtp?type=nodenode=5844517i=0 writes:
The analyze function has crashed again while the overcommit entries
were as above. The last bit of the
On Wed, April 1, 2015 5:50 pm, Tom Lane-2 [via PostgreSQL] wrote:
TonyS t...@exquisiteimages.com writes:
The analyze function has crashed again while the overcommit entries
were as above. The last bit of the PostgreSQL log shows: MdSmgr: 41934848
total in 14 blocks; 639936 free (0 chunks);
On Wed, 1 Apr 2015 04:33:07 -0700 (MST)
TonyS t...@exquisiteimages.com wrote:
On Wed, April 1, 2015 12:18 am, Tom Lane-2 [via PostgreSQL] wrote:
TonyS t...@exquisiteimages.com writes:
Running analyze verbose; and watching top, the system starts out
using no swap data and about 4GB of
On Wed, April 1, 2015 12:18 am, Tom Lane-2 [via PostgreSQL] wrote:
TonyS t...@exquisiteimages.com writes:
Running analyze verbose; and watching top, the system starts out
using no swap data and about 4GB of cached memory and about 1GB of used
memory. As it runs, the amount of used RAM
On Wed, April 1, 2015 8:48 am, Bill Moran [via PostgreSQL] wrote:
Running analyze verbose; and watching top, the system starts out
using no swap data and about 4GB of cached memory and about 1GB of
used memory. As it runs, the amount of used RAM climbs, and
eventually the used swap memory
...@postgresql.org] On Behalf Of Bill Moran
Sent: 01 April 2015 13:48
To: TonyS
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Would like to know how analyze works technically
On Wed, 1 Apr 2015 04:33:07 -0700 (MST)
TonyS t...@exquisiteimages.com wrote:
On Wed, April 1, 2015 12
: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Would like to know how analyze works technically
On Wed, 1 Apr 2015 04:33:07 -0700 (MST)
TonyS t...@exquisiteimages.com wrote:
On Wed, April 1, 2015 12:18 am, Tom Lane-2 [via PostgreSQL] wrote:
TonyS t...@exquisiteimages.com writes
TonyS t...@exquisiteimages.com wrote:
The postgresql log has these entries at the crash point:
2015-04-01 06:24:37 EDT LOG: server process (PID 1384) was terminated by
signal 9: Killed
2015-04-01 06:24:38 EDT DETAIL: Failed process was running: analyze verbose;
That was almost certainly
On Wed, 1 Apr 2015 06:26:36 -0700 (MST)
TonyS t...@exquisiteimages.com wrote:
On Wed, April 1, 2015 8:48 am, Bill Moran [via PostgreSQL] wrote:
Running analyze verbose; and watching top, the system starts out
using no swap data and about 4GB of cached memory and about 1GB of
used
Farjad
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of TonyS
Sent: 01 April 2015 14:46
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Would like to know how analyze works technically
On Wed, April 1, 2015 9:25 am
On Wed, April 1, 2015 9:35 am, Kevin Grittner-5 [via PostgreSQL] wrote:
TonyS t...@exquisiteimages.com wrote:
The postgresql log has these entries at the crash point:
2015-04-01 06:24:37 EDT LOG: server process (PID 1384) was terminated
by signal 9: Killed 2015-04-01 06:24:38 EDT DETAIL:
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of TonyS
Sent: Wednesday, April 01, 2015 12:15 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Would like to know how analyze works technically
On Wed, April 1, 2015 9:35 am, Kevin
...@postgresql.org] On Behalf Of FarjadFarid(ChkNet)
Sent: 01 April 2015 17:14
To: 'TonyS'; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Would like to know how analyze works technically
Because your system had crashed. I would check everything from bottom up.
The duration of operation
On Wed, April 1, 2015 12:30 pm, Igor Neyman [via PostgreSQL] wrote:
TonyS [hidden email]/user/SendEmail.jtp?type=nodenode=5844292i=0
wrote:
name,current_setting,source autovacuum,off,configuration file
synchronous_commit,off,configuration file TimeZone,localtime,configuration
file
On Wed, 1 Apr 2015 10:47:32 -0700 (MST)
TonyS t...@exquisiteimages.com wrote:
On Wed, April 1, 2015 12:30 pm, Igor Neyman [via PostgreSQL] wrote:
TonyS [hidden email]/user/SendEmail.jtp?type=nodenode=5844292i=0
wrote:
name,current_setting,source autovacuum,off,configuration file
TonyS t...@exquisiteimages.com writes:
The analyze function has crashed again while the overcommit entries were
as above. The last bit of the PostgreSQL log shows:
MdSmgr: 41934848 total in 14 blocks; 639936 free (0 chunks); 41294912 used
ident parser context: 0 total in 0 blocks; 0 free
On Wed, April 1, 2015 9:35 am, Kevin Grittner-5 [via PostgreSQL] wrote:
TonyS t...@exquisiteimages.com wrote:
The postgresql log has these entries at the crash point:
2015-04-01 06:24:37 EDT LOG: server process (PID 1384) was terminated
by signal 9: Killed 2015-04-01 06:24:38 EDT DETAIL:
I have loaded data for a database conversion I am working on and I have
created the indexes I believe I will need.
My current design uses a schema for each client that will access the
database. I am using schema because there is one set of global tables that I
need to query with the tables within
TonyS t...@exquisiteimages.com writes:
Running analyze verbose; and watching top, the system starts out using no
swap data and about 4GB of cached memory and about 1GB of used memory. As it
runs, the amount of used RAM climbs, and eventually the used swap memory
increases to 100% and after
19 matches
Mail list logo