[PERFORM] Need help in setting optimal configuration for a huge database.

2005-10-22 Thread Kishore B
Hi All, I am Kishore doing freelance development of J2EE applications. We switched to use Postgresql recently because of the advantages it has over other commercial databases. All went well untill recently, untill we began working on an application that needs to maintain a huge database. I

Re: [PERFORM] Need help in setting optimal configuration for a huge database.

2005-10-22 Thread Kishore B
, (Current Setting : 48000 (375MB)) sort_memory, (Current setting 2048 kb (2MB)) effective_cache_size (Current setting: 10 (1GB)) On 10/23/05, Steinar H. Gunderson [EMAIL PROTECTED] wrote: [please send replies to the list, not to me directly]On Sun, Oct 23, 2005 at 03:19:39AM +0530, Kishore B

Re: [PERFORM] Need help in setting optimal configuration for a huge database.

2005-10-23 Thread Kishore B
Hi Craig, Thank you very much for your response. It really covered a great point. Thank you, Kishore. On 10/23/05, Craig A. James [EMAIL PROTECTED] wrote: We are facing a* critical situation because of the performance of the **database** .* Even a basic query like select count(*) from

[PERFORM] Need help in setting optimal configuration for a huge database.

2005-10-24 Thread Kishore B
Hi All, I am Kishore doing freelance development of J2EE applications. We switched to use Postgresql recently because of the advantages it has over other commercial databases. All went well untill recently, untill we began working on an application that needs to maintain a huge database. I

[PERFORM] Why Index is not working on date columns.

2005-10-25 Thread Kishore B
Hi All, Thank you very much for your help in configuring the database. Can you guys please take a look at the following query andlet meknow why the index is not considered in the plan? Here is the extract of the condition string of the query that is taking the transaction_date in index

Re: [PERFORM] Why Index is not working on date columns.

2005-10-25 Thread Kishore B
/25/05, Tom Lane [EMAIL PROTECTED] wrote: Kishore B [EMAIL PROTECTED] writes:Can you guys please take a look at the following query and let me know why the index is not considered in the plan?Considered and used are two different things.The two examples you give have the same estimated cost (within

[PERFORM] Why different execution times for different instances for the same query?

2005-10-25 Thread Kishore B
Hi All, We are executing a single query that returned veryfast on the first instance. Butwhen I executed the same queryformultiple times,it is giving strange results. It is not coming back. When I checked with the processes running in the system, Iobserved that multiple instances of postmaster