nyuuzyou/wikis huggingface dataset:
Logging Difficult Queries

If you want to find the queries that are taking the longest on your system, you can do that by setting log_min_duration_statement to a positive value representing how many milliseconds the query has to run before it's logged. In PostgreSQL 8.4+, you can use pg_stat_statements for this purpose as well, without needing an external utility.
Some utilities that can help sort through this data are:
* pgFouine. Its documentation has some more tips on log_min_duration_statement and related logging parameters
* pgBadger. Its documentation also includes advice on log_min_duration_statement and related logging parameters
* PQA
* EPQA
* pgsi - see introduction
If you are using these tools, you might even consider a period where set the minimum duration to 0 and therefore get all statements logged. This is will be intensive on the logging side, but running that data through one of the tools will give you a lot of insight into what your server is doing.
One thing that can cause queries to pause for several seconds is a checkpoint. If you periodically see many queries all taking several seconds all finishing around the same time, consider Logging Checkpoints and seeing if those times line up, and if so tune appropriately.
== auto-explain ==
In PostgreSQL, the Auto-Explain contrib module allows saving explain plans only for queries that exceed some time threshold. Seeing the bad plans can help determine why queries are slow, instead of just that they are slow. See Waiting for 8.4 - auto-explain for an example.
Category:FAQCategory:AdministrationCategory:Performance
Logging Difficult Queries/ja

システムにおいてもっとも長い時間がかかる問い合わせを見つけたければ、log_min_duration_statementを正数に設定することで実現可能です。PostgreSQL 8.4から、この目的のためにpg_stat_statementsを使用することもできます。これは他のユーティリティを必要としません。
指定時間（ミリ秒単位）で終わらなかった問い合わせがログに残ります。
このデータを通して分類を補助することができるツールがいくつか存在します。
* pgFouine. この文書にはlog_min_duration_statementや関連するログに関するパラメータについてのティップスが多く記載されています。
* PQA
* EPQA
* pgsi - introduction参照
これらのツールを使用するのであれば、最小時間を0にする、つまりすべての文を記録する期間を検討することすらできます。
これは記録という観点では激しいものですが、これらのツールの1つでデータを実行することで、サーバが何を行っているかについて詳しく洞察することができます。
問い合わせを数秒休止させてしまう可能性があるものの一つはチェックポイントです。
周期的に多くの問い合わせがすべて数秒かかり、ほぼ同じ時間に完了するようであれば、Logging Checkpointsを検討し、これらの時間がそろっているかどうか確認してください。また該当する場合は適切に調整してください。、
== auto-explain ==
PostgreSQLでは、Auto-Explain contribモジュールにより、ある時間閾値を超える問い合わせのみに対してexplainした結果を保存することができます。悪い計画を確認することは、単に低速というだけではなく、低速な問い合わせの原因を判定する手助けとなります。例としてWaiting for 8.4 - auto-explainを参照してください。
Category:FAQCategory:AdministrationCategory:PerformanceCategory:Japanese
Logging Difficult Queries/ru

Чтобы найти наиболее медленные запросы в вашей системе, можно воспользоваться настройкой log_min_duration_statement, установив значение, выраженное в миллисекундах, по истечению которого запрос попадает в лог. Начиная с версии PostgreSQL 8.4 также можно воспользоваться pg_stat_statements не прибегая к сторонним инструментам.
Некоторые утилиты анализа данных лога:
* pgBadger - см. Статьи
* pgFouine. В его документации даются несколько подсказок по log_min_duration_statement и ему подобным параметрам
* PQA
* EPQA
* pgsi - см. Введение
При применении этих инструментов можно выставить минимальное значение в ноль для фиксации всех запросов. Это приведет к интенсивному логгированию, однако, позволит получить полную картину происходящего на сервере.
Контрольные точки могут останавливать запросы до нескольких секунд. Если наблюдаются запросы, выполняющиеся по несколько секунд и при этом завершающиеся в одно и то же время, обратитесь к логгированию контрольных точек. Если выяснится, что они выстраиваются в очередь, стоит поиграться с настройками.
== auto-explain ==
Для PostgreSQL существует модуль Auto-Explain, сохраняющий планы выполнения запросов, превышающих заданный временной порог при выполнении. Полученные планы могут помочь в обнаружении причин медленного выполнения проблемных запросов. См. Waiting for 8.4 - auto-explain, например.
Category:FAQ
Category:Administration
Category:Performance
Category:Russian
Logical Decoding Plugins

Logical decoding provides the ability to stream modifications made via SQL to external consumers.
To be able to use logical decoding you need to install a plugin into postgresql to transform the WAL internal representation to a format the client can use.
=== JSON format plugins ===
==== wal2json ====
https://github.com/eulerto/wal2json
JSON output plugin for changeset extraction
 "change": [
 	{
 		"kind": "insert",
 		"schema": "public",
 		"table": "table_with_pk",
 		"columnnames": ["a", "b", "c"],
 		"columntypes": ["int4", "varchar", "timestamp"],
 		"columnvalues": [1, "Backup and Restore", "2015-08-27 16:46:35.818038"]
 	}]
==== decoding-json ====
https://github.com/leptonix/decoding-json
This plugin receives the changes from WAL and decodes them to JSON.
 {"type":"transaction.begin","xid":"2010561","committed":"2015-04-22 19:23:35.714443+00"}
 {"type":"table","name":"abc","change":"INSERT","data":{"a":6,"b":7,"c":42}}
 {"type":"table","name":"abc","change":"UPDATE","key":{"a":6,"b":7},"data":{"a":6,"b":7,"c":13}}
==== decoder_json ====
https://github.com/ildus/decoder_json
Uses libjansson for json generation rather than native postgresql code
==== jsoncdc ====
https://github.com/instructure/jsoncdc
Written in rust
==== wal2mongo ====
Translates changesets into a format consumable directly by MongoDB
https://github.com/HighgoSoftware/wal2mongo
=== Protobuf Format Plugins ===
==== decoderbufs ====
https://github.com/xstevens/decoderbufs
decoderbufs is a PostgreSQL logical decoder output plugin to deliver data as Protocol Buffers.
==== postgres-decoderbufs ====
https://github.com/debezium/postgres-decoderbufs
A fork of xstevens/decoderbufs for use as a debezium connector
=== Avro Format Plugins ===
==== Bottled Water ====
https://github.com/confluentinc/bottledwater-pg
Streams into Kafka. No longer supported.
=== SQL Format Plugins ===
==== decoder_raw ====
https://github.com/michaelpq/pg_plugins/tree/master/decoder_raw
This output plugin for logical replication generates raw queries based
on the logical changes it finds. Those queries can be consumed as they
are by any remote source.
=== Miscellaneous Plugins ===
==== test_decoding ====
contrib/test_decoding is example code for a logical decoding output plugin. It describes itself as "doesn't do anything especially useful, but can serve as a starting point for developing your own decoder".
People have written code to parse the output from this plugin, but that doesn't make it a good idea:
* https://github.com/davecramer/LogicalDecode - java
* https://github.com/lisael/pylogicaldecoding - python
* https://github.com/kibae/pg-logical-replication - node.js
==== osm-logical ====
https://github.com/zerebubuth/osm-logical
Toy code for use with openstreetmaps. Looks to be based on test_decoding.
==== pglogical ====
https://www.2ndquadrant.com/en/resources/pglogical/
pglogical is a logical replication system, implemented as a postgresql extension
==== transicator ====
https://github.com/apigee-labs/transicator
transicator reads from a single logical decoding connection and replicates change out to many (thousands) of intermittently connected clients via a REST API
Logo

The PostgreSQL logo is an elephant, known as "Slonik". Multiple versions of the logo are available.
Use of the logo is subject to our Trademark Policy.
== 3-color elephant == 
Image:PostgreSQL logo.3colors.svg| SVG
Image:PostgreSQL logo.3colors.120x120.png| PNG 120x120
Image:PostgreSQL logo.3colors.540x557.png| PNG 540x557
Adobe Illustrator Format
== Single-color elephant ==
===1 color black===
Image:PostgreSQL Logo.1 Color Black.png‎| PNG
===1 color blue===
Image:PostgreSQL_logo.1color_blue.svg‎ | SVG 
Image:PostgreSQL_logo.1color_blue.300x300.png‎| PNG 300x300
===1 color white===
Image:PostgreSQL_logo.1color_white.svg‎| SVG
Image:PostgreSQL_logo.1color_white.120x120.png‎| PNG 120x120
== 'favicon' ==
The logo is also available as a favicon : http://wiki.postgresql.org/favicon.ico
Alternate location for the .ico file: 
== Why elephant? ==
In the email thread postgreSQL and history of relational databases, Oleg Bartunov states that the logo idea probably originated from a PostgreSQL logo thread on the pgsql-hackers mailing list. Quote:
@see http://dba.stackexchange.com/q/35325/20510
Category:Advocacy
Luhn algorithm

Luhn algorithm implementation by 
in pure SQL (PostgreSQL function dialect, but
should be easily adapted to other DBMSs).
Note that this implementation is purely
arithmetic; it avoids string manipulation entirely.
See: http://en.wikipedia.org/wiki/Luhn_algorithm
CREATE OR REPLACE FUNCTION luhn_verify(int8) RETURNS boolean AS $$
-- Take the sum of the
-- doubled digits and the even-numbered undoubled digits, and see if
-- the sum is evenly divisible by zero.
SELECT
 -- Doubled digits might in turn be two digits. In that case,
 -- we must add each digit individually rather than adding the
 -- doubled digit value to the sum. Ie if the original digit was
 -- `6' the doubled result was `12' and we must add `1+2' to the
 -- sum rather than `12'.
 MOD(SUM(doubled_digit / INT8 '10' + doubled_digit % INT8 '10'), 10) = 0
FROM
-- Double odd-numbered digits (counting left with
-- least significant as zero). If the doubled digits end up
-- having values
-- > 10 (ie they're two digits), add their digits together.
(SELECT
 -- Extract digit `n' counting left from least significant
 -- as zero
 MOD( ( $1::int8 / (10^n)::int8 ), 10::int8)
 -- Double odd-numbered digits
 * (MOD(n,2) + 1)
 AS doubled_digit
 FROM generate_series(0, floor(log( $1 ))::integer) AS n
) AS doubled_digits;
$$ LANGUAGE 'SQL'
IMMUTABLE
STRICT;
COMMENT ON FUNCTION luhn_verify(int8) IS 'Return true iff the last digit of the
input is a correct check digit for the rest of the input according to Luhns
algorithm.';
CREATE OR REPLACE FUNCTION luhn_generate_checkdigit(int8) RETURNS int8 AS $$
SELECT
 -- Add the digits, doubling even-numbered digits (counting left
 -- with least-significant as zero). Subtract the remainder of
 -- dividing the sum by 10 from 10, and take the remainder
 -- of dividing that by 10 in turn.
 ((INT8 '10' - SUM(doubled_digit / INT8 '10' + doubled_digit % INT8 '10') %
 INT8 '10') % INT8 '10')::INT8
FROM (SELECT
 -- Extract digit `n' counting left from least significant\
 -- as zero
 MOD( ($1::int8 / (10^n)::int8), 10::int8 )
 -- double even-numbered digits
 * (2 - MOD(n,2))
 AS doubled_digit
 FROM generate_series(0, floor(log( $1 ))::integer) AS n
) AS doubled_digits;
$$ LANGUAGE 'SQL'
IMMUTABLE
STRICT;
COMMENT ON FUNCTION luhn_generate_checkdigit(int8) IS 'For the input
value, generate a check digit according to Luhns algorithm';
CREATE OR REPLACE FUNCTION luhn_generate(int8) RETURNS int8 AS $$
SELECT 10 * $1 + luhn_generate_checkdigit($1);
$$ LANGUAGE 'SQL'
IMMUTABLE
STRICT;
COMMENT ON FUNCTION luhn_generate(int8) IS 'Append a check digit generated
according to Luhns algorithm to the input value. The input value must be no
greater than (maxbigint/10).';
CREATE OR REPLACE FUNCTION luhn_strip(int8) RETURNS int8 AS $$
SELECT $1 / 10;
$$ LANGUAGE 'SQL'
IMMUTABLE
STRICT;
COMMENT ON FUNCTION luhn_strip(int8) IS 'Strip the least significant digit from
the input value. Intended for use when stripping the check digit from a number
including a Luhns algorithm check digit.';
Category:SQL
LWESF2007

== Linux World Expo August 7-9 2007 ==
PostgreSQL will have a booth (together with SF Perlmongers) and a BOF at LWE-SF, attended by PostgreSQL luminaries like Bruce Momjian and Josh Berkus. Come hang out and chat with us: it'll be fun!
== Birds-of-a-Feather & Dinner/Party ==
When: Tuesday August 7, 6-7pm
What: PostgreSQL 8.3 Update: Beta features, performance & testing 
Where: Room 305, Moscone Center
Who: Bruce Momjian & Josh Berkus
Dinner/Party: Buca Di Beppo, 1 block from Moscone Center, 7:30PM. Wine & garlicky food.
You MUST RSVP if going to dinner, and bring $25 in cash in case we don't have sponsorship for the dinner.
== PostgreSQL Booth ==
We will be in the .ORG pavillion as usual, but this year we'll be sharing our booth with some members of the Perl community so it will be a joint PostgreSQL/Perl booth. The booth will be for 3 days, from Tuesday August 7 to Thursday August 9th. We will also need load-in help on Sunday.
* Sunday Load-in (8/5 2pm): Josh Berkus, Joe Brenner, Steve Atkins & Laura, Brian Hamlin
* Tuesday, 8/7 9am to 1pm: Josh Berkus, Robert Hodges, Bruce Momjian, Prerna Mamgain
* Tuesday, 8/7 1pm to 5pm: Josh Berkus, Neil Conway, Robert Hodges, Joe Brenner, Robert Noyes, Prerna Mamgain
* Wednesday, 8/8, 9:30am to 1pm: Josh Berkus, Bruce Momjian, Quinn Weaver
* Wednesday, 8/8, 1pm to 5pm: Josh Berkus, Joe Brenner, Quinn Weaver
* Thursday, 8/9, 9:30am to 1pm: Josh Berkus, Bruce Momjian, Githogori
* Thursday, 8/9, 1pm to 6pm: Josh Berkus, Paul Rivers, Githogori
* Thursday 8/9 6pm Booth pick-up: Paul Rivers
Volunteers will be given a PostgreSQL t-shirt and asked to wear it, except for the Perlmongers who can wear Perl t-shirts. I will also buy lunch for any volunteers who stay all day.
Other needs:
Demo: We need a demo of cool stuff using PostgreSQL & Perl! Please help!
== Corporate Presence ==
The Open Solutions Alliance will have a huge pavillion at LWE & the Next Generation Data Center. This includes the following PostgreSQL companies:
* EnterpriseDB
* Hyperic
* SourceForge
* Unisys
== Contact ==
Githogori Nyangara-Murage ( githogori -- at -- siliconbazaar -- dot -- com )
Josh Berkus ( josh -- at -- agliodbs -- dot -- com )
Category:PostgreSQL Events
Mailing List Creation Policies

== Overview ==
This is meant to document our existing way of creating and maintaining mailing lists. It is not an exhaustive resource, but should highlight the important ways that we keep our community involved and aware of mailing lists that are created, used and archived by the postgresql.org infrastructure teams.
== Announcing the creation of a list ==
When a new list is created, we should announce that it was done on pgsql-www@lists.postgresql.org.
Mailing lists are archived and displayed at http://www.postgresql.org/list/
Category:Community
Mailman to PGLister Migration

== Mailman to PGLister migration ==
The following bash script can be used and adapted to migrate subscribers and archives from Mailman to PGLister and PGArchives. Lists must be manually created beforehand.
 # Script to import subscribers and email archives from mailman to pglister.
 # Lists must already be created in pglister.
 # Here is where to find some options in mailman administrative interface for each list:
 # - Subscription policy:
 # Privacy options -> "What steps are required for subscription?"
 # - Members view membership:
 # Privacy options -> "Who can view subscription list?"
 # - Moderation level:
 # Privacy options -> Sender filter -> "By default, should new list member postings be moderated?"
 
 ORIGIN="" # server hosting mailman
 TARGET="" # server hosting pglister
 PUBLIC_LISTS="" # space-separate list of public lists to import
 PRIVATE_LISTS="" # space-separate list of private lists to import
 DOMAIN="" # fqdn used for lists
 DJANGO_USER="list"
 PYTHON_VENV_PGLISTER="/srv/pglister/local/web/pglister/bin/python"
 PYTHON_VENV_PGARCHIVES="/srv/pgarchives/local/django/bin/python"
 PYTHON_VENV_PGARCHIVES_PRIVATE="/srv/pgarchives-private/local/django/bin/python"
 PGARCHIVES_PATH="/srv/pgarchives/local/"
 PGARCHIVES_PRIVATE_PATH="/srv/pgarchives-private/local/"
 PGLISTER_PATH="/srv/pglister/local/"
 
 function import_list() {
 listname_full="$1"
 listname=$(echo "$listname_full" | tr '[:upper:]' '[:lower:]')
 echo "Loading subscribers from $listname_full"
 ssh $ORIGIN /var/lib/mailman/bin/list_members -f -n -o "$listname"_nomail.txt "$listname_full"
 ssh $ORIGIN /var/lib/mailman/bin/list_members -f -o "$listname"_mail.txt "$listname_full"
 scp $ORIGIN:"$listname"_nomail.txt $TARGET:lists/
 scp $ORIGIN:"$listname"_mail.txt $TARGET:lists/
 ssh $TARGET sudo -u $DJANGO_USER $PYTHON_VENV_PGLISTER $PGLISTER_PATH/bin/load_subscribers.py -l "$listname"@$DOMAIN -a -f lists/"$listname"_nomail.txt --nomail
 ssh $TARGET sudo -u $DJANGO_USER $PYTHON_VENV_PGLISTER $PGLISTER_PATH/bin/load_subscribers.py -l "$listname"@$DOMAIN -a -f lists/"$listname"_mail.txt
 echo "Loading archives from $listname_full"
 scp $ORIGIN:/var/lib/mailman/archives/private/"$listname".mbox/"$listname".mbox $TARGET:lists/
 if [ "$2" == "public" ]
 then
 ssh $TARGET sudo -u $DJANGO_USER $PYTHON_VENV_PGARCHIVES $PGARCHIVES_PATH/loader/load_message.py -m lists/"$listname".mbox -l "$listname"
 else
 ssh $TARGET sudo -u $DJANGO_USER $PYTHON_VENV_PGARCHIVES_PRIVATE $PGARCHIVES_PRIVATE_PATH/loader/load_message.py -m lists/"$listname".mbox -l "$listname"
 fi
 }
 
 for i in $PUBLIC_LISTS
 do
 import_list "$i" public
 done
 
 for i in $PRIVATE_LISTS
 do
 import_list "$i" private
 done
Main Page/es

__NOTOC__
= ¡Bienvenido al wiki de PostgreSQL! =
Este wiki contiene la documentación, guías, how-tos, consejos y trucos relacionados con PostgreSQL en Español. También sirve como un área de colaboración para contribuyentes de PostgreSQL.
Visite también el índice de material en español.
== Documentación de Usuario ==
* Preguntas Frecuentes
=== Artículos, guías y documentación ===
* Como colaborar con PostgreSQL: Revisión de parches
* Conversión de datos a PostgreSQL
* Desarrollo con PostgreSQL
* Artículos sobre PostgreSQL
* Herramientas para PostgreSQL
* Guias de instalacion detalladas
* Mantenimiento y Administracion de Bases de Datos
* Optimizacion del Rendimiento PostgreSQL 
* Presentaciones y Charlas relacionadas con PostgreSQL
=== Documentación Oficial ===
* Manuales de PostgreSQL
* Libros de PostgreSQL
== Videos ==
* Peru: PostgreSQL Day 2007
* Argentina: PostgreSQL Day 2008
* Argentina: PostgreSQL Day 2012
== Notas de Liberacion ==
* Actualización de Seguridad del 4 de Abril de 2013
== Sin Clasificar ==
* Trabajando con Eclipse
== Informacion para Colaboradores ==
Usted puede encontrar muchos usuarios y desarrolladores de PostgreSQL en #postgresql en Libera. Y una lista de nicks de IRC con sus respectivos
nombres del mundo real se puede encontrar aqui.
* Próximos eventos
* Información de Desarrollo
* Fomento
== Cuentas de Usuario ==
* Todas las actividades en este sitio debe seguir las Políticas del Proyecto PostgreSQL.
* Con el fin de modificar o crear documentos en el sitio, necesitarás una Cuenta de la Comunidad de PostgreSQL. Esta es la misma cuenta utilizada a la hora de presentar noticias o eventos en www.postgresql.org, o añadir comentarios a la versión interactiva de la documentación oficial.
Category:Español
Main Page/he

__NOTOC__
ברוכים הבאים ל PostgreSQL Wiki!
wiki זה מכיל תיעוד למשתמש, הוראות ביצוע, וטריקים וטיפים הקשורים ל PostgreSQL. הוא משמש גם כאזור שיתוף פעולה עבור התורמיםהתומכים ב PostgreSQL.
התיעוד למשתמש
	 שאלות נפוצות
מאמרים המיוצרים על ידי הקהילה, מדריכים ותיעוד
	 מאמרים ומדריכים כלליים
	 מדריכים PostgreSQL
	 מדריכי התקנה מפורטים
 המרת ממסדי נתונים אחרים ל PostgreSQL
	 השוואה עם מערכות מסדי נתונים אחרות
 ניהול ותחזוקת Database
	 פיתוח ב PostgreSQL
 אופטימיזציה של ביצועים PostgreSQL
	 שקופיות ומצגות קשורים ל PostgreSQL
תיעוד באתר הראשי
	מדריכי PostgreSQL
	ספרי PostgreSQL
מידע לתורמים
	אתה יכול למצוא משתמשים של PostgreSQL רבים ומפתחים בשיחת צ'אט ב- #postgresql ב- Libera. רשימת IRC nick names עם שמות האמיתים שלהם ניתן למצוא כאן
	 אירועים קרובים
 מידע לפיתוח
 Advocacy
חשבונות משתמשים
	כל הפעילות באתר זה צריכה להיות כפופה ל מדיניות פרויקט PostgreSQL
	כדי לערוך או ליצור תוכן באתר, תצטרך חשבון בקהילה. זה אותו חשבון השתמש לצורך הגשת החדשות או אירועים ב www.postgresql.org
הערה: עקב פעילות הספאם האחרונה הרשאות "editor" מוענקות באופן ידני מעת לעתה. אם רק יצרת חשבון חדש בקהילה או אם לחשבון הנוכחי השלך היו הרשאות "editor" תבקש או ב PostgreSQL -www Mailinglist או ב PostgreSQL IRC Channel (כוון את בקשתך ל 'pginfra') לעזרה. נא לרשום שם חשבון בקהילה בבקשות אלה.
Category:Hebrew
Main Page/ja

== 日本語トピック ==
* よくある質問と回答（FAQ） - FAQの和訳
=== コミュニティにより作成されたアーティクル、ガイド、文書 ===
* データベースの管理とメンテナンス - データベースの管理や運用管理に便利なSQLのサンプルなどが記載されています。
* 性能最適化 - 主に性能改善や性能に関する調査方法に関する記載がされています。
=== 日本語カテゴリ ===
*日本語カテゴリ 日本語に翻訳された全文書の一覧です。上記アーティクル以外にも様々な文書が和訳されています。
== 日本のコミュニティ開発の情報 ==
* Japan PostgreSQL Developer
== 外部サイト ==
* 日本PostgreSQLユーザ会 - Japan PostgreSQL Users Group
* PostgreSQL文書 - Documentation in Japanese
* Let's Postgres - JPUG portal site
== 日本語文献 ==
* Wikipedia.ja/PostgreSQL
* PostgreSQLウォッチ (ITPro)
* PostgreSQL Information Page
* PostgreSQL Notes for Japanese
== 日本語全文検索 ==
Japanese full-text search
* textsearch-ja
* Sylph-Searcher
* pg_bigm
Category:Japanese
Main Page/pt

== Comunidade Brasileira ==
* Site da comunidade Brasileira : http://www.postgresql.org.br
* Planeta PostgreSQL Brasil (blogs e artigos sobre PostgreSQL): http://planeta.postgresql.org.br
* PGBR (evento nacional de PostgreSQL): http://pgbr.postgresql.org.br
== Documentos em Português do Brasil ==
=== Tradução da documentação oficial ===
* Perguntas Frequentes
* Manual PostgreSQL 8 (versão on-line no projeto pgdocptbr)
* Manual PostgreSQL 8.2 - Referência (versão on-line no projeto pgdocptbr)
* Tutorial do PostgreSQL 8 (versão em PDF)
* Manual PostgreSQL 8 (versão em PDF)
=== Artigos traduzidos ===
* Dicas de Performance em aplicações com PostgreSQL por Josh Berkus, traduzido por Fábio Telles Rodriguez
* Checklist de Performance do PostgreSQL 8.0 por Josh Berkus, traduzido por Fábio Telles Rodriguez
* 10 dicas para um PGDay por Selena Deckelmann, traduzido e adaptado por Dickson S. Guedes
=== Artigos da Comunidade Brasileira e Apresentações em Eventos ===
==== Introdução ====
* Introdução e Histórico por Diogo Biazus
* Comparando o Oracle com o PostgreSQL semelhanças, vantagens do Oracle, vantagens do PostgreSQL por Fábio Telles Rodriguez
* Meu PostgreSQL não conecta por Rodrigo Hjort
* 10 Dicas para começar a usar o PostgreSQL por Fábio Telles Rodriguez
==== Geral ====
* PostgreSQL Prático por Ribamar FS
* Produza Sequências Com a Função Generate_Series()! por Cláudio Bezerra Leopoldino
* PostgreSQL, discos & Cia por Fábio Telles Rodriguez
* Trabalhando com logs por Fábio Telles Rodriguez
* Aprenda a trabalhar com as configurações do PostgreSQL por Fábio Telles Rodriguez
* Trabalhando com datas no PostgreSQL inserindo e exibindo, aritmética, funções por Fábio Telles Rodriguez
* Brincando com funções de janelas (Window Functions) por Fábio Telles Rodriguez
==== Ferramentas ====
* Edição de SQL e Funções no PSQL por Cláudio Bezerra Leopoldino
* Ferramentas para o PostgreSQL por Diogo Biazus
* Replicação no PostgreSQL por Euler Taveira
* Hot Standby e Streaming Replication por Euler Taveira
* Começando com o Londiste (Replicação Multi-Master Assíncrona) por João Cosme Junior
==== Funcionalidades ====
* XML PostgreSQL por Diogo Biazus
==== Segurança ====
* Segurança contra injeção de SQL no PostgreSQL por Fábio Telles Rodriguez
==== Desempenho ====
* Particionamento de tabelas quando, como, detalhes, automatizando por Fábio Telles Rodriguez
* Acelerando a importação de dados no PostgreSQL por Fábio Telles Rodriguez
==== Monitoramento ====
* Monitorando o PostgreSQL, por Euler T. Oliveira onde você pode ter uma visão geral sobre o assunto
* Monitorando o PostgreSQL com ptop, por Dickson S. Guedes, onde você pode ter um exemplo prático
Category:Português