| From: | Marcin Mańk <marcin(dot)mank(at)gmail(dot)com> |
|---|---|
| To: | Emrah Mehmedov <emrah(dot)mehmedov(at)x3mlabs(dot)com> |
| Cc: | Bob Jolliffe <bobjolliffe(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: PHP Postgres query slower then PgAdmin |
| Date: | 2013-06-23 19:57:53 |
| Message-ID: | CAK61fk7tVCsN0Y4Fr+y+=g+M0izbJnZwTK_ejTWyyd5D+V+PyQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Wed, Jun 5, 2013 at 1:15 PM, Emrah Mehmedov
<emrah(dot)mehmedov(at)x3mlabs(dot)com> 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 also change the connection string (i remove host and port) and nothing
> changed.
The first query using a text search config loads the dictionaries, so
it is slower, and that's why the following queries are faster. I think
your PHP persistent connections don't work too well.
Regards
Marcin Mańk
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Abhijit Menon-Sen | 2013-06-24 04:43:50 | Re: [PERFORM] In progress INSERT wrecks plans on table |
| Previous Message | Tom Kincaid | 2013-06-23 17:35:15 | Re: PHP Postgres query slower then PgAdmin |