On Wed, Jun 5, 2013 at 1:15 PM, Emrah Mehmedov
wrote:
> [ull text search]
> I notice something in CMD, first time query is executing same time like from
> php all the time, but on the rest of the time that i will execute the query
> is faster from cmd, php is keeping the same execution time.
> i a
Just rule out something weird;
Can you determine if you are getting the same query plan in both cases? Use
"explain analyze" from the command line and turn on auto.explain via
postgresql.conf to log what the plan is for the php case.
Tom Kincaid
EnterpriseDB
www.enterprisedb.com
On Wed, Jun 5