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
On Wed, April 1, 2015 12:18 am, Tom Lane-2 [via PostgreSQL] wrote:
>
>
> TonyS 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
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 u
essage-
> From: pgsql-general-ow...@postgresql.org
> [mailto:pgsql-general-ow...@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
>
>
&g
On Wed, April 1, 2015 9:35 am, Kevin Grittner-5 [via PostgreSQL] wrote:
>
>
> TonyS 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-0
On Wed, April 1, 2015 12:30 pm, Igor Neyman [via PostgreSQL] wrote:
>>
>> TonyS <[hidden email]>
>> wrote:
>>
>>
>
> name,current_setting,source autovacuum,off,configuration file
> synchronous_commit,off,configuration file TimeZone,localtime,configur
On Wed, April 1, 2015 9:35 am, Kevin Grittner-5 [via PostgreSQL] wrote:
>
>
> TonyS 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-0
On Wed, April 1, 2015 5:50 pm, Tom Lane-2 [via PostgreSQL] wrote:
>
>
> TonyS 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
I am in the process of porting some routines from using FoxPro to PostgreSQL
9.3.6.
While the long term goal is to entirely rewrite everything in the system, in
order to get items transferred as soon as possible I am having to try to
convert some of the modules in place. For the most part, this ha
