| 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: | Whole Thread | Raw Message | 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 |