Re: [PERFORM] High CPU load on Postgres Server during Peak times!!!!

For 'idle in transaction' issues, you have to fix your code. I faced this issue couple of months back. How good is your exception handling? Are you rollingback/comitting your transactions while exceptions are thrown, during the course of db operations? Honestly I wouldn't go for these scripts w

Re: [PERFORM] [ADMIN] Installation Error of postgresql-8.1.5 with perl.

I can avoid this kind of error. Thanks & regard Praveen kumar. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance

[PERFORM] Installation Error of postgresql-8.1.5 with perl.

* [all] Error 2 Please tell me how I can avoid this kind of error. Thanks & regard Praveen kumar. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance

[PERFORM] Nls sorting in Postgresql-8.3.3

advance. Praveen Malik.

Re: [PERFORM] Trigger is not firing immediately

Yes , I am sure it is not trigger recursion. - Original Message - From: "Pavel Stehule" <[EMAIL PROTECTED]> To: "Praveen" <[EMAIL PROTECTED]> Cc: ; <[EMAIL PROTECTED]> Sent: Monday, July 14, 2008 3:03 PM Subject: Re: [PERFORM] Trigger is not firing

Re: [PERFORM] Trigger is not firing immediately

o: Sent: Monday, July 14, 2008 12:18 PM Subject: Re: [PERFORM] Trigger is not firing immediately am Mon, dem 14.07.2008, um 12:04:49 +0530 mailte Praveen folgendes: Hi All, I am having a trigger in table, If I update the the table manually trigger is firing immediately(say 200ms per

[PERFORM] Trigger is not firing immediately

trigger fire immediately while updating the table through procedure ? Regards, Praveen

Re: [PERFORM] Insert performance vs Table size

ailto:[EMAIL PROTECTED] Sent: 27 June 2005 14:05 To: Praveen Raja Cc: pgsql-performance@postgresql.org Subject: RE: [PERFORM] Insert performance vs Table size Hi, At 13:50 27/06/2005, Praveen Raja wrote: >Just to clear things up a bit, the scenario that I'm interested in is a >table wit

Re: [PERFORM] Insert performance vs Table size

ize of the table play a role in determining insert performance (and I mean only insert performance)? -Original Message- From: Jacques Caron [mailto:[EMAIL PROTECTED] Sent: 27 June 2005 13:40 To: Praveen Raja Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] Insert performance vs Tabl

[PERFORM] Insert performance vs Table size

Hi all I'm wondering if and how the size of a table affects speed of inserts into it? What if the table has indexes, does that alter the answer? Thanks ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[PERFORM] very large table

Hi   I’m trying to move an existing solution from MySQL to PostgreSQL. As it is now the solution has 4 tables where data in inserted by an application. At regular intervals (10min) data from these tables is consolidated and moved to another table for reporting purposes. There exist many i