Hi All,
We are executing a single query that returned very fast on the first instance. But when I executed the same query for multiple times, it is giving strange results. It is not coming back.
When I checked with the processes running in the system, I observed that multiple instances of pos
.
On 10/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.T
Hi All,
Thank you very much for your help in configuring the database.
Can you guys please take a look at the following query and let me know 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 con
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.
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
9:39AM +0530, Kishore B wrote:
> *You definitely want to upgrade this if you can.>> > Memory : 2 GB> *> We can move upto 12 GB if need to be.I was referring to your PostgreSQL version, not your RAM. More RAM is almost
always an improvement, but for your data set, 2GB sounds quit
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.
