Re: Mystery SELECT * query
От
Kevin Grittner
Тема
Re: Mystery SELECT * query
Дата
Msg-id
1386633462.75161.YahooMailNeo@web162904.mail.bf1.yahoo.com
Ответ на
Mystery SELECT * query (Andrew Puschak)
Список
Дерево обсуждения
Mystery SELECT * query Andrew Puschak <apuschak@gmail.com>
Re: Mystery SELECT * query Kevin Grittner <kgrittn@ymail.com>
Re: Mystery SELECT * query Andrew Puschak <apuschak@gmail.com>
Re: Mystery SELECT * query Andrew Puschak <apuschak@gmail.com>
Re: Mystery SELECT * query Thomas Kellerer <spam_eater@gmx.net>
Re: Mystery SELECT * query Andrew Puschak <apuschak@gmail.com>
Re: Mystery SELECT * query Sameer Kumar <sameer.kumar@ashnik.com>
Re: Mystery SELECT * query Andrew Puschak <apuschak@gmail.com>
Andrew Puschak 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
В списке pgsql-novice по дате отправления
