W dniu 2012-09-06 22:04, Aryan Ariel Rodriguez Chalas pisze:
-Why if I connect to the remote server desktop (using RDP or any Remote Desktop
Application) and run the application using the same internet connection, it runs really
fast when making requests to postgresql; but if I run the applicat
Aryan Ariel Rodriguez Chalas wrote:
> I'm working with an application that connects to a remote server database
> using "libpq" library over
> internet, but making a simple query is really slow even though I've done
> PostgreSQL Tunning and table
> being indexed, so I want to know:
>
> -Why is p
On Thu, Sep 6, 2012 at 6:50 PM, charles_xie wrote:
> Hi，
>Thanks for your advice.i know the basic monitoring skill,because the
> postgresql database is used for the factory production , so I hope they can
> run normal and exert more perfect performance. so i need to be considered
> from the p
Aryan Ariel Rodriguez Chalas wrote:
> Hello,
>
> I'm working with an application that connects to a remote server database
> using "libpq" library over internet, but making a simple query is really slow
> even though I've done PostgreSQL Tunning and table being indexed, so I want
> to know:
Hi，
Thanks for your advice.i know the basic monitoring skill,because the
postgresql database is used for the factory production , so I hope they can
run normal and exert more perfect performance. so i need to be considered
from the point of view ,eg : threading ,locks and so on.
Daniel Farina
Hello,
I'm working with an application that connects to a remote server database using
"libpq" library over internet, but making a simple query is really slow even
though I've done PostgreSQL Tunning and table being indexed, so I want to know:
-Why is postgresql or libpq that slow when working
Also probably some good info to be mined out of postbix.
http://www.zabbix.com/wiki/howto/monitor/db/postbix/monitor_postgres_with_zabbix
On Thu, Sep 6, 2012 at 12:44 PM, Josh Berkus wrote:
> On 9/4/12 12:12 AM, charles_xie wrote:
> > Hi all,
> > i have 5 servers that have been installi
On 9/4/12 12:12 AM, charles_xie wrote:
> Hi all,
> i have 5 servers that have been installing postgresql .In order to
> know the postgresql working status and monitor them ,moreover i don't want
> to use the monitor tools .I want to use the SQL commands to monitoring
> postgresql system
On Tue, Sep 4, 2012 at 12:12 AM, charles_xie wrote:
> Hi all,
> i have 5 servers that have been installing postgresql .In order to
> know the postgresql working status and monitor them ,moreover i don't want
> to use the monitor tools .I want to use the SQL commands to monitoring
> pos
Thank you for your help. At a high-level, I am just updating about 900k
records in the database with new information, and during that update timetable,
I didn't want users to get inconsistent data.
I read about the MVCC and discovered that I didn't necessarily need the LOCK
statement. However
10 matches
Mail list logo
