postgresql.leopard.in.ua
Работа с PostgreSQL: настройка и масштабирование
http://postgresql.leopard.in.ua/html
Работа с PostgreSQL: настройка и масштабирование. А Ю Васильев aka leopard. Creative Commons Attribution-Noncommercial 4.0 International. Не используйте настройки по умолчанию. Используйте актуальную версию сервера. Стоит ли доверять тестам производительности. Журнал транзакций и контрольные точки. Диски и файловые системы. Перенос журнала транзакций на отдельный диск. Утилиты для тюнинга PostgreSQL. Оптимизация БД и приложения. Поддержание базы в порядке. Перенос логики на сторону сервера. Размер и стат...
blog.taadeem.net
pgBadger is moving fast
http://blog.taadeem.net/english/2012/11/12/pgbadger-is-moving-fast
My name's Damien Clochard and I work at Dalibo. A French PostgreSQL company. I'm also the executive editor of PG Magazine,. President of the French Speaking PostgreSQL Association. PgBadger is moving fast. November 12th, 2012. Thanks to this community support, the project goes at a very fast pace! Today Gilles Darold released pgBadger 2.2. This new version comes with a bunch of exciting new features:. New parameters : For instance with. You can now ignore a user in the generated reports. With. Ie it’s ju...
pgfoundry.org
pgFoundry: pgFouine: Project Home
http://pgfoundry.org/projects/pgfouine
Search the entire project. PgFouine: Project Home pgFoundry. PgFouine is a PostgreSQL log analyzer written in PHP. It is based on PQA, the Practical Query Analyzer written in Ruby. PgFouine aims to be able to parse huge logs and to have a nice and useful HTML output. No tag defined for this project. GNU General Public License (GPL). View list of RSS feeds. Available for this project. February 24, 2010. PgFouine 0.9.90. February 5, 2007. View All Project Files. View the 2 Member(s).
postgresql.kr
PostgreSQL 서버 로그 실시간 감시 :PostgreSQL KR
http://postgresql.kr/blog/pglog_realtime_auditing.html
PostgreSQL 서버 로그 실시간 감시. 작성일:2014-05-16 18:01, 수정일: 2014-11-17 09:53. Http:/ postgresql.kr/blog/pglog realtime auditing.html. PostgreSQL의 서버 로그에 대한 기능이 막강한 것은 써본 사람은 대부분 동의할 것입니다. 일반적으로 서버 로그는 일반 텍스트 파일에 저장하고, 로그를 분석해야 하는 상황에서는 대부분 유닉스 텍스트 파일 도구(cat, grep, sed, perl, awk .)들을 이용해서 분석합니다. 즉, 이런 텍스트 파일 분석하는 도구들을 잘 다루는 이들에게는 전혀 불편함을 느끼지 못하지만, 그렇지 않은 경우는 텍스트 파일로 되어 있는 로그를 어떻게 분석해야 할지 막막하기만 합니다. 이런저런 문제들 때문에, PostgreSQL 쪽에서는 서버 로그 분석 도구들이 여러 오픈 프로젝트로 진행되었거나 진행되고 있습니다. 가장 대표적인 것은 pgbadger. 현재까지 찾은 그 대처안들은.
reusablecoder.blogspot.com
Reusable Coder: April 2013
http://reusablecoder.blogspot.com/2013_04_01_archive.html
Tuesday, April 2, 2013. Database Optimization: Query Performance vs. Request Performance. When it comes time to optimize your web application's database performance, there are (at least) two types of tools you can leverage. You can use an analysis tool like pgFouine. Which is focused on individual query performance, or a tool like Scout. Which is focused on request performance. PgFouine is fantastic at isolating any single. But what if the top N queries are all taking roughly the same amount of time?
top-performance.blogspot.com
Scale Hacking: Cloud Computing, Software and System Performance: April 2014
http://top-performance.blogspot.com/2014_04_01_archive.html
Scale Hacking: Cloud Computing, Software and System Performance. News, Personal view and perspective of the software performance field, cloud computing and industry based on my experience. Internet Systems Architecture Consulting. Apr 25, 2014. Don't Forget Choosing the Right CDN for that! Fact #1: More and More Sites are using SSL to Secure Their Users' Transactions. Everybody requires security and privacy these days. If you don't believe it, take a look at. Presentation and search page. A common soluti...