From: | jwang <john(dot)wang(at)popmanager(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | an indexing problem on postgreSQL |
Date: | 2004-05-03 10:55:23 |
Message-ID: | 1083581724.24056.14.camel@localhost |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
All,
I have an data-driven web application with Java and PostgreSQL. We have
a few tables which hold quite large amount of data. Therefore we put
indexing (B-tree) on them to make query faster. In addition, we are also
doing data synchronization on these tables with another microsoft FoxPro
application in real-time. Normally the indexing works just fine without
data synchronization. But with data synchronization, after a period of
time, the indexing did not take effect on the table so that the
application goes extremely slow.
Does anyone there has an idea why and have a solution to the problem?
Your help is greatly appreciated.
Sincerely,
-John
From | Date | Subject | |
---|---|---|---|
Next Message | Eric Anderson Vianet SAO | 2004-05-03 11:49:03 | \D TO FILE |
Previous Message | T E Schmitz | 2004-05-02 17:09:30 | Re: double left outer join on the same table |