[GENERAL] Postgres crash during Stored procedure execution

2012-06-05 Thread Jayashankar K B
Hi, We are facing one database crash issue because of stored procedures. When the stored procedure with a set of values is executed the first time, it works fine. If the same stored procedure is executed with same set of values once more, the database crashes with the error WARNING: terminati

Re: [GENERAL] Postgres process is crashing continously in 9.1.1

2012-05-22 Thread Jayashankar K B
...@postgresql.org] On Behalf Of Chris Angelico Sent: Tuesday, May 22, 2012 3:10 PM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] Postgres process is crashing continously in 9.1.1 On Tue, May 22, 2012 at 4:51 PM, Jayashankar K B wrote: > On writing into this table, a stored procedure

Re: [GENERAL] Postgres process is crashing continously in 9.1.1

2012-05-21 Thread Jayashankar K B
: Re: [GENERAL] Postgres process is crashing continously in 9.1.1 On 05/21/12 11:05 PM, Jayashankar K B wrote: > board with Coldfire controller. what is this board? Coldfire is the embedded 68k-like Freescale processor? what operating system is this under? what sort of storage does t

Re: [GENERAL] Postgres process is crashing continously in 9.1.1

2012-05-21 Thread Jayashankar K B
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Jayashankar K B Sent: Tuesday, May 22, 2012 11:27 AM To: pgsql-general@postgresql.org Subject: [GENERAL] Postgres process is crashing continously in 9.1.1 Hi, We are using Postgres 9.1.1 on a board with Coldfire controller. The postgres

[GENERAL] Postgres process is crashing continously in 9.1.1

2012-05-21 Thread Jayashankar K B
Hi, We are using Postgres 9.1.1 on a board with Coldfire controller. The postgres processes are crashing and restarting upon executing a particular instruction and it keeps repeating. Even when we tried with Postgres 9.1.3, same problem happens. It works fine until the FINANCIALTRANSACTIONID rea

[GENERAL] Significance of Postgres (version 9.1.1) Compilation parameters - Performance

2012-05-02 Thread Jayashankar K B
Hi All, Could anyone explain me the significance of the following compile time parameters ? 1. --disable-integer-datetimes 2. --disable-float4-byval 3. --disable-float8-byval Do they have any effect on performance of postgres w.r.t speed of database insert/select, amount of CPU u

Re: [GENERAL] Re: [PERFORM] Disable-spinlocks while compiling postgres 9.1 for ARM Cortex A8

2012-02-26 Thread Jayashankar K B
Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: 25 February 2012 PM 12:54 To: Jayashankar K B Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Re: [PERFORM] Disable-spinlocks while compiling postgres 9.1 for ARM Cortex A8 Jayashankar K B writes: > I tried to apply the patch

[GENERAL] Re: [PERFORM] Disable-spinlocks while compiling postgres 9.1 for ARM Cortex A8

2012-02-24 Thread Jayashankar K B
do. Please let me know what I am doing wrong and what I should be doing. Thanks and Regards Jayashankar -Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: 24 February 2012 AM 09:20 To: Jayashankar K B Cc: pgsql-general@postgresql.org; pgsql-performa...@postgresql.

[GENERAL] Re: [PERFORM] Disable-spinlocks while compiling postgres 9.1 for ARM Cortex A8

2012-02-23 Thread Jayashankar K B
Regards Jayashankar -Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: 24 February 2012 AM 09:20 To: Jayashankar K B Cc: pgsql-general@postgresql.org; pgsql-performa...@postgresql.org Subject: Re: [PERFORM] Disable-spinlocks while compiling postgres 9.1 for ARM Cortex A8

[GENERAL] Disable-spinlocks while compiling postgres 9.1 for ARM Cortex A8

2012-02-23 Thread Jayashankar K B
Hi All, I am trying to compile Postgres Source code for ARM cortex A8 architecture. While compiling, I got an error message which read "selected processor does not support `swpb r4,r4,[r3]' " One of the Postgres forums at the location "http://postgresql.1045698.n5.nabble.com/BUG-6331-Cross-compi

[GENERAL] Postgres 9.1 package for i.MX51X processor from Freescale

2012-02-19 Thread Jayashankar K B
Hi, Is there a ready postgres 9.1 Package for the i.MX51X processor (ARM Cortex architecture) available or do I need to compile the Postgres source myself ? I need it for a board having the i.MX51 processor and Linux (a variant of Debian distribution based on Linux kernel 2.6.35). If I need to c

[GENERAL] Postgres 9.1 package for i.MX51X processor from Freescale

2012-02-17 Thread Jayashankar K B
Hi, Anybody with any ideas on using Postgres on ARM CORTEX A8 based processors.. ? Thanks! Jay From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Jayashankar K B Sent: 16 February 2012 PM 04:00 To: pgsql-general@postgresql.org Subject: [GENERAL

[GENERAL] Postgres 9.1 package for i.MX51X processor from Freescale

2012-02-15 Thread Jayashankar K B
Hi, Is there a ready postgres 9.1 Package for the i.MX51X processor (ARM Cortex architecture) available or do I need to compile the Postgres source myself ? I need it for a board having the i.MX51 processor and Linux (one of the latest versions of kernel - yet to decide the exact version). If I

Re: [GENERAL] Regarding licensing of Postgresql

2011-12-05 Thread Jayashankar K B
rg Subject: Re: [GENERAL] Regarding licensing of Postgresql On 12/05/11 12:23 AM, Jayashankar K B wrote: > > Now we have a doubt about licensing. > > What is the licensing process if we want to use postgresql with our > proprietary software? > Could anyone please throw some light

[GENERAL] Regarding licensing of Postgresql

2011-12-05 Thread Jayashankar K B
Hi, We are planning to use Postgres 9.1 in our commercial product having a coldfire m68k architecture based controller on Linux platform. Since ready installer was not present for this architecture, we cross compiled the source code and it is working fine now, though we are yet to do Full-fledge