Re: [PERFORM] Queries within a function

Hi, Try using dynamic sql. Query will be faster in a function regards Ram - Original Message - From: "Mridula Mahadevan" To: "Tom Lane" Cc: Sent: Wednesday, February 03, 2010 2:23 AM Subject: Re: [PERFORM] Queries within a function Tom, I cannot run execute because all these are tem

[PERFORM] Sql result b where condition

Hi all, I have a table emp. using where condition can i get the result prioritized. Take the example below. select ENAME,ORIG_SALARY from employee where (ename='Tom' and orig_salary=2413)or(orig_salary=1234 ) if the fist condition(ename='Tom' and orig_salary=2413) is satified then 10 row

[PERFORM] Array comparison

Hi all, I want to compare the two arrys in sql, The below example is wrong. But i want to know how to do that in postgres 8.2.5 SELECT 'x' WHERE string_to_array('the,quick,ram,fox', ',') any (string_to_array('the,quick,lazy ,fox', ',')) Regards, Ram

[PERFORM] Dynamic sql example

Dear All. Can any one give me dynamic sql in postgres stored procedure using "USING CLAUSE" Regards, Ram

Re: [PERFORM] Query is slow when executing in procedure

Thanks a lot Kretschmer. i will try it . Regards, Ram - Original Message - From: "A. Kretschmer" To: Sent: Tuesday, November 24, 2009 11:45 AM Subject: Re: [PERFORM] Query is slow when executing in procedure In response to ramasubramanian : Dear all, The query is

Re: [PERFORM] Query is slow when executing in procedure

Thanks a lot Pavel . i will try it . - Original Message - From: "Pavel Stehule" To: "ramasubramanian" Cc: Sent: Tuesday, November 24, 2009 11:40 AM Subject: Re: [PERFORM] Query is slow when executing in procedure 2009/11/24 ramasubramanian : Dear all, Th

[PERFORM] Query is slow when executing in procedure

Dear all, The query is slow when executing in the stored procedure(it is taking around 1 minute). when executing as a sql it is taking 4 seconds. basically i am selecting the varchar column which contain 4000 character. We have as iindex on the table. We have analyzed the table also. What cou

[PERFORM] Performance of quer or procedure going down when we are taking the backup

Dear all, Performance of query or procedure going down when we are taking the backup of that schema(it is obvious), But how to increase the performance. Regards, Ram. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscripti

[PERFORM] Trigger on column

Dear all, Can we create a trigger on particular column of a table? Regards, Ram -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance

Re: [PERFORM] Concurrency issue under very heay loads

Hi, Are you using automatic sequence increment in table? - Original Message - From: Raji Sridar (raji) To: pgsql-gene...@postgresql.org ; pgsql-performance@postgresql.org Sent: Thursday, July 16, 2009 10:29 AM Subject: [PERFORM] Concurrency issue under very heay loads Hi,

[PERFORM]

Dear Friends, How to insert or update a file in a table using the query in postgres CREATE TABLE excel_file_upload ( user_id integer, excel_file bytea } example insert into excel_file_upload values(1,file1) file1 can be any file *.doc,*.xls How i can do this(with out using java or an

[PERFORM] Bytea updation

Dear Friends, How to insert or update a file in a table using the query in postgres CREATE TABLE excel_file_upload ( user_id integer, excel_file bytea } example insert into excel_file_upload values(1,file1) file1 can be any file *.doc,*.xls How i can do this(with out using java or

[PERFORM] Trigger is taking time to fire

Hi All, I am having a trigger in table, If i update the the table manually it is not taking time(say 200ms per row), But if i update the table through procedure the trigger is taking time to fire(say 7 to 10 seconds per row). How can i make the trigger to fire immediately ? Regards, Ram

[PERFORM] Trigger is taking time to fire

Hi All, I am having a trigger in table, If i update the the table manually it is not taking time(say 200ms per row), But if i update the table through procedure the trigger is taking time to fire(say 7 to 10 seconds per row). How can i make the trigger to fire immediately? Regards, Ram

Re: [PERFORM] Problem with 11 M records table

Hi , Set this parameter in psotgresql.conf set enable_seqscan=off; And try: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Marlowe Sent: Tuesday, May 13, 2008 11:32 PM To: idc danny Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] Proble