an indexing problem on postgreSQL

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

Browse pgsql-sql by date

  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