Re: [PERFORM] PHP Postgres query slower then PgAdmin

2013-06-23 Thread Marcin Mańk
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

Re: [PERFORM] PHP Postgres query slower then PgAdmin

2013-06-23 Thread Tom Kincaid
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