Re: Mystery SELECT * query
| От | Andrew Puschak |
|---|---|
| Тема | Re: Mystery SELECT * query |
| Дата | |
| Msg-id | CALFZoBvc7Y4X9Bz_9N3DendcRnv=g8GR-S6BMHg+SrfUApf40A@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Mystery SELECT * query (Kevin Grittner <kgrittn@ymail.com>) |
| Ответы |
Re: Mystery SELECT * query
|
| Список | pgsql-novice |
On Mon, Dec 9, 2013 at 6:57 PM, Kevin Grittner <kgrittn@ymail.com> wrote:
Andrew Puschak <apuschak@gmail.com> wrote:The first thing I would look at is whether the software stack on
> 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.
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
Hi Kevin,
I have not had access to the web server yet, the owner works on it with the developer but knowledge is limited there and this was setup years ago. I can see if I can get access or ask the developer but this might not happen. I'm told it might be using ODBC to connect, I'm not familiar with Windows, I'm a linux admin. I'll look up table caching and see if we can find it there.
Thanks for your help,
Andrew
В списке pgsql-novice по дате отправления: