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
/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
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
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
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
, (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
