| From: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Mystery SELECT * query |
| Date: | 2014-01-20 14:23:25 |
| Message-ID: | lbjbgg$qm4$1@ger.gmane.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Andrew Puschak, 09.12.2013 22:07:
> 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. I have pgBadger set up and logging turned up which is how I
> found the query.
>
> The developer says the query is not in his code and gave me the
> source code. It's pasqual. I see the other queries but I don't see
> the select * either in the code. He also added logging of the queries
> and the SELECT * FROM is missing. Is it possible another query
> creates the select * such as the two queries before it shown below?
Maybe a "clever" ORM that re-selects any row that is touched by a DML statement in order to re-retrieve computed columns or generated IDs?
I don't know if there are any Pascal ORMs around, but I know that some ORMs in the Java world to crazy things like that.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Puschak | 2014-01-20 15:16:58 | Re: Mystery SELECT * query |
| Previous Message | Andrew Puschak | 2014-01-20 13:27:32 | Re: Mystery SELECT * query |