Can any one give more input, you can see my top out put, in %MEM its taking
24.1.
Regards,
Itishree
On Thu, May 30, 2013 at 6:15 PM, itishree sukla wrote:
> Thanks for the quick response. Below is the out put of Top Commnd.
>
> 3971 postgres 20 0 8048m 303m 301m S0 0.9 0:04.34
> /usr/
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.
On
Most probably. If your existing connection string specifies something like
"host=localhost port=5432 ..." just remove the host and port parameters and
php will by default try to connect with unix domain socket.
On 5 June 2013 12:02, Emrah Mehmedov wrote:
> Can we modify php connection?
>
>
> O
Can we modify php connection?
On Wed, Jun 5, 2013 at 1:01 PM, Bob Jolliffe wrote:
> Is php connecting through tcp whilst pgadmin is using unix domain socket?
> Probably the query time is the same, but returning the result over tcp
> will be slower.
>
>
> On 5 June 2013 11:18, Emrah Mehmedov w
Is php connecting through tcp whilst pgadmin is using unix domain socket?
Probably the query time is the same, but returning the result over tcp
will be slower.
On 5 June 2013 11:18, Emrah Mehmedov wrote:
> Hello,
>
> I'm using php5.4.12 with extension=php_pgsql.dll enabled but the query
> tha
Hello,
I'm using php5.4.12 with extension=php_pgsql.dll enabled but the query that
i'm trying to execute is faster on PgAdmin app.
SELECT title, ts_rank_cd(vector, query) AS rank FROM links,
to_tsquery('english', 'risk') query WHERE query @@ vector ORDER BY rank
DESC;
I'm not sure, what can i do
