Fwd: This Week's PostgreSQL News (#95)

Wed Mar 4 08:31:56 BRT 2015

interesting stuff
---------- Forwarded message ----------
From: Postgres Weekly <postgres at cooperpress.com>
Date: Wed, Mar 4, 2015 at 8:15 AM
Subject: This Week's PostgreSQL News (#95)
To: brauliobo at gmail.com


 .
Read this on the Web
<http://postgresweekly.us1.list-manage.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=d8f3048385&e=e94a93aae6>
 Postgres Weekly
<http://postgresweekly.us1.list-manage.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=b1a559f393&e=e94a93aae6>
Issue 95 — March 4, 2015
     The History of Replication in PostgreSQL
<http://postgresweekly.us1.list-manage.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=f42a5e59a2&e=e94a93aae6>
A lack of replication support in Postgres was a key reason for people
picking MySQL over Postgres until about 5 years ago. Since then, Postgres
has come a long way with replication and here’s a look at how it all came
together.
 Peter Eisentraut
Document Storage Gymnastics with Postgres
<http://postgresweekly.us1.list-manage2.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=6093772034&e=e94a93aae6>
For single-node deployments Postgres is now a clear winner when it comes to
document storage (versus MongoDB). This deep dive looks at how to take
advantage of Postgres’ document storage, how to use indexes for
optimization and also highlights cases where Postgres particularly excels.
 Rob Conery
Resolve Database Performance Issues Quickly
<http://postgresweekly.us1.list-manage1.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=b116bee553&e=e94a93aae6>
AppDynamics' self-learning platform allows you to analyze actual database
performance and detect anomalies automatically. It takes the guesswork out
of defining optimal performance. Installs in Minutes. Start Free Monitoring
<http://postgresweekly.us1.list-manage.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=3fa4bb446a&e=e94a93aae6>
  sponsored     AppDynamics
<http://postgresweekly.us1.list-manage1.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=997428ca23&e=e94a93aae6>
PoWA 2: Finding the Missing Index
<http://postgresweekly.us1.list-manage2.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=6e782af263&e=e94a93aae6>
The first major update to the Postgres workload analyzer (PoWA) includes
the ability to identify missing indexes your app would benefit from.
 Postgresql.org
Tree Structure Query with PostgreSQL
<http://postgresweekly.us1.list-manage.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=c8ddb37742&e=e94a93aae6>
Hierarchical structures are common in apps but don’t lend themselves to
simple representations in relational databases. Fortunately, Postgres has a
few tools to make things a bit smoother for you.
 Trường TX
Is PostgreSQL Your Next JSON Database?
<http://postgresweekly.us1.list-manage.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=1f0132688c&e=e94a93aae6>
A look at how JSON in Postgres can work well for you.
 Compose
It’s Time To Get Over That Stored Procedure Aversion You Have
<http://postgresweekly.us1.list-manage.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=746777eed3&e=e94a93aae6>
A provoking opinion piece. “Stored Procedures are not inherently bad –
you’ve been told this because someone thinks you’re not capable of thinking
for yourself.”
 Rob Conery
PostgreSQL Performance Tuning
<http://postgresweekly.us1.list-manage2.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=4f7e9295d5&e=e94a93aae6>
This older post is still very relevant if you’re running Postgres on your
own hardware. The short version is that Postgres generally works well out
of the box, but if you’re configuring your own system there are some useful
things to pay attention to.
 Bruce Momjian
Job: Software Engineer @ Blue Apron (New York, NY)
<http://postgresweekly.us1.list-manage1.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=0faad0a22b&e=e94a93aae6>
If you're passionate about food and building supply chain and warehouse
management systems from the ground up, give us a look. Our team's at 16
developers and growing...quickly.
  sponsored     Blue Apron

Postgres Weekly is curated by Craig Kerstiens
<http://postgresweekly.us1.list-manage.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=0272f3ab58&e=e94a93aae6>
Read this issue on the Web
<http://postgresweekly.us1.list-manage1.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=292766a8d6&e=e94a93aae6>
See our archives
<http://postgresweekly.us1.list-manage.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=1da325d367&e=e94a93aae6>
Change your email address
<http://postgresweekly.us1.list-manage.com/profile?u=0618f6a79d6bb9675f313ceb2&id=b3f056442a&e=e94a93aae6>
Stop getting Postgres Weekly
<http://postgresweekly.us1.list-manage.com/unsubscribe?u=0618f6a79d6bb9675f313ceb2&id=b3f056442a&e=e94a93aae6&c=3914059f86>

Published by Cooper Press
<http://postgresweekly.us1.list-manage2.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=70d88cffbd&e=e94a93aae6>
Office 30, Lincoln Way, Louth, LN11 0LS, UK


-- 
"Lute pela sua ideologia. Seja um com sua ideologia. Viva pela sua
ideologia. Morra por sua ideologia" P.R. Sarkar

EITA - Educação, Informação e Tecnologias para Autogestão
http://cirandas.net/brauliobo
http://eita.org.br

"Paramapurusha é meu pai e Parama Prakriti é minha mãe. O universo é meu
lar e todos nós somos cidadãos deste cosmo. Este universo é a imaginação da
Mente Macrocósmica, e todas as entidades estão sendo criadas, preservadas e
destruídas nas fases de extroversão e introversão do fluxo imaginativo
cósmico. No âmbito pessoal, quando uma pessoa imagina algo em sua mente,
naquele momento, essa pessoa é a única proprietária daquilo que ela
imagina, e ninguém mais. Quando um ser humano criado mentalmente caminha
por um milharal também imaginado, a pessoa imaginada não é a propriedade
desse milharal, pois ele pertence ao indivíduo que o está imaginando. Este
universo foi criado na imaginação de Brahma, a Entidade Suprema, por isso
a propriedade deste universo é de Brahma, e não dos microcosmos que também
foram criados pela imaginação de Brahma. Nenhuma propriedade deste mundo,
mutável ou imutável, pertence a um indivíduo em particular; tudo é o
patrimônio comum de todos."
Restante do texto em
http://cirandas.net/brauliobo/blog/a-problematica-de-hoje-em-dia
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listas.softwarelivre.org/pipermail/noosfero-dev/attachments/20150304/bdac76de/attachment-0001.html>