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

Wed Jun 17 20:19:54 BRT 2015

nice post on indexes, see below

---------- Forwarded message ----------
From: Postgres Weekly <postgres at cooperpress.com>
Date: Wed, Jun 17, 2015 at 3:59 PM
Subject: This Week's PostgreSQL News (#110)
To: brauliobo at gmail.com


 .
Read this on the Web
<http://postgresweekly.us1.list-manage.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=720fd5e9c8&e=e94a93aae6>
 Postgres Weekly
<http://postgresweekly.us1.list-manage.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=ebfd121e35&e=e94a93aae6>
Issue 110 — June 17, 2015
     Following a SELECT Statement Through Postgres Internals
<http://postgresweekly.us1.list-manage.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=42997bc7b0&e=e94a93aae6>
Here’s a continued very deep dive into what happens under the covers of
Postgres when you run a select statement. If you’ve ever been curious about
the internals of Postgres this is a great primer.
 Pat Shaughnessy
PostgreSQL 9.4.4, 9.3.9, 9.2.13, 9.1.18 & 9.0.22 Released
<http://postgresweekly.us1.list-manage.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=879f7e6a25&e=e94a93aae6>
“Earlier update releases attempted to fix an issue in PostgreSQL 9.3 and
9.4 with ‘multixact wraparound’, but failed to account for issues doing
multixact cleanup during crash recovery. This could cause servers to be
unable to restart after a crash. As such, all users of 9.3 and 9.4 should
apply this update as soon as possible.”
 postgresql.org
How to Stop Worrying and Love Your Postgres Indexes
<http://postgresweekly.us1.list-manage2.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=153885229e&e=e94a93aae6>
Indexes will help make your applications and queries much faster. Here’s a
look both from a high level, as well as some deep dive specifics on
different types of indexes and how to take advantage of them to improve
performance.
 Ju Liu
PostgreSQL Training – Foundations and Advanced
<http://postgresweekly.us1.list-manage2.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=5e80ee3677&e=e94a93aae6>
Bruce Momjian will be teaching foundational and advanced topics needed for
successful PostgreSQL administration. Join Bruce and learn from his tips
and techniques in this live on-line session in July. 20% off promo code
COMB-WEB-01.
 EnterpriseDB    #sponsored
<http://postgresweekly.us1.list-manage1.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=389ce20ac5&e=e94a93aae6>
A Review of H.J. Schönig’s 'Troubleshooting PostgreSQL' Book
<http://postgresweekly.us1.list-manage1.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=40838d6c03&e=e94a93aae6>
 Łukasz Woźniak
faitout: Give Access to Volatile PostgreSQL Databases for Testing
<http://postgresweekly.us1.list-manage.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=010af2ad6d&e=e94a93aae6>
Generates PostgreSQL databases on the fly for a limited time, allowing
people to test their code against an actual PostgreSQL database.
 Fedora Infrastructure   #code
ActiveRecord + PostgreSQL Materialized Views
<http://postgresweekly.us1.list-manage.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=49ee395c14&e=e94a93aae6>
Materialized views can make complex/long-running reports much snappier by
actually writing out a table equivalent of the resulting view. With a
little bit of manoeuvring you can even have your app directly take
advantage of them as highlighted here with ActiveRecord.
 Wolox Engineering
PgCon 2015 Developer Meeting
<http://postgresweekly.us1.list-manage1.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=2598b879db&e=e94a93aae6>
PgCon, the annual conference for Postgres hackers, is now underway. Each
year there’s a variety of talk and coordination on upcoming parts for
Postgres. Take a look at some of the meta issues around release schedules
and coordination for year ahead within their meeting notes.
 postgresql.org
JSON Support in PostgreSQL, MySQL, MongoDB, and SQL Server
<http://postgresweekly.us1.list-manage1.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=3dca5ffeba&e=e94a93aae6>
JSON has been an exciting topic for a few years now in databases. In large
part this is due to the rise of attempting to get more flexibility in the
app dev process my not being constrained to a specific schema. Here’s a
rundown of the support that’s available across a variety of databases.
 Vivid Cortex

Postgres Weekly is curated by Craig Kerstiens
<http://postgresweekly.us1.list-manage.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=fc8612fb3c&e=e94a93aae6>
Read this issue on the Web
<http://postgresweekly.us1.list-manage.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=599f3f549e&e=e94a93aae6>
See our archives
<http://postgresweekly.us1.list-manage2.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=4a72bdb50b&e=e94a93aae6>
Change your email address
<http://postgresweekly.us1.list-manage1.com/profile?u=0618f6a79d6bb9675f313ceb2&id=b3f056442a&e=e94a93aae6>
Stop getting Postgres Weekly
<http://postgresweekly.us1.list-manage2.com/unsubscribe?u=0618f6a79d6bb9675f313ceb2&id=b3f056442a&e=e94a93aae6&c=36ba5db31f>

Published by Cooper Press
<http://postgresweekly.us1.list-manage.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=9a0fb73a0a&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/20150617/76cc3269/attachment-0001.html>