Andrew Puschak <apuschak@gmail.com> wrote:
> I've inherited a web service on a Windows server that connects to
> a Postgres database. There is a "SELECT * FROM" query below that
> runs a long time and appears to happen whenever there is a web
> service update. I'd like to eliminate or limit it but I have to
> find it first.
The first thing I would look at is whether the software stack on
your web server includes some sort of table cache which is being
invalidated by each update.
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company