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 . please suggest any SQL COMMANDS to work
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.
On Tue, Sep 4, 2012 at 12:12 AM, charles_xie xqwyy...@163.com 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
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 .
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 j...@agliodbs.com wrote:
On 9/4/12 12:12 AM, charles_xie wrote:
Hi all,
i have 5 servers that have
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
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
Aryan Ariel Rodriguez Chalas wimo...@yahoo.com 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
On Thu, Sep 6, 2012 at 6:50 PM, charles_xie xqwyy...@163.com 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