[ANNOUNCE] PGCon 2016: 17-21 May

[Dan Langille]

Hello,

The dates for PGCon 2016 have been determined.

Join us in Ottawa for the 10th annual PGCon May 17-21 as users and developers 
from around the world gather for what has become a traditional gathering of the 
PostgreSQL community.

There will be two days of tutorials on Tuesday and Wednesday.  The best of the 
best will be available to help you learn great things about PostgreSQL and its 
tools.

On Wednesday, there will be a Developer Unconference (a User Unconference will 
follow on Saturday).  The Unconference first appeared at PGCon 2013 and was a 
instant success.  At PGCon 2016, there will be two days of Unconference, one 
preceding the conference, and one following the conference.  There will be many 
people who attend both sessions.

For Thursday and Friday, the submitted talks will be presented as everyone 
gathers in one location to learn, discuss, and collaborate.

Saturday sees the return of the User Unconference, run similar to the format of 
previous years. People show up, voice their opinions on what they'd like to 
hear or would like to speak about, the topics are upon, and the items with the 
most votes gets onto the schedule. 

In summary:

• Tutorials: 17-18 May 2016 (Tue & Wed)
• Unconference: 18 & 21 May 2016
   • Wednesday is a developer unconference.
   • Saturday is a user unconference.
   • Everyone is welcome to both sessions, but you must register separately for 
each.
• Talks: 19-20 May 2016 (Thu-Fri).

Registration will open shortly after the talks are announced.

The official Call For Papers announcement will go out on Tuesday.

— 
Dan Langille
http://langille.org/

[ANNOUNCE] Announcing PGConf US 2016: Apr 18 - 20, NYC - Call for Presentations Open

[Jonathan S. Katz]

The call for presentations for PGConf US 2016 is now open! Submissions will be 
allowed through  January 31st, 2016. All speakers will be notified by February 
15, 2016. Please note that as with our past conferences, there will be no 
extensions of the submission deadline. For more information and submission 
details, please visit http://www.pgconf.us/2016/submit/

Thanks to the support of our attendees, speakers, volunteers, and sponsors, we 
have had two incredibly successful PostgreSQL conferences in NYC that have 
grown the PostgreSQL community substantially. Hundreds of attendees 
representing a plethora of companies around the world have attended one or both 
of our previous conferences and continue to join our event. In April of 2016 we 
plan to keep the tradition going. With the support of the United States 
PostgreSQL Association, the conference organization team is planning the most 
informational and involved conference yet.

April 18th is dedicated to hosting trainings and summits. Trainings will occur 
at the conference venue and the schedule will be announced in February. We are 
featuring the “Second Annual Regulated Industry Summit: Finance, Government, 
Healthcare, and PostgreSQL" hosted at the NYC Marriott Brooklyn Bridge, which 
will bring together PostgreSQL contributors and enterprise developers to 
discuss challenges and solutions in utilizing PostgreSQL in regulated 
environments. For more information about the summit and how to attend, please 
visit http://www.pgconf.us/2016/training/

April 19th - 20th, 2016, will host two days of dedicated sessions, keynotes, 
and events that will allow individuals to enter and experience the PostgreSQL 
community at its finest. Experts from around the globe will be submitting talks 
and trainings in order to grow the PostgreSQL community and empower those 
involved. This wealth of knowledge comes from the perspectives of developers, 
DBAs, systems administrators, business-intelligence analysts, decision makers, 
and the like. 

PGConf US 2016 would not be possible without the considerate support of our 
sponsors, which allows us to continue to produce a high-quality event while 
keeping registration fees low to encourage growing our community. We extend a 
very warm thank you to our launch sponsors:

Platinum:
+ EnterpriseDB
+ OpenSCG
+ Citus Data

Gold:
+ 2ndQuadrant
+ Amazon Web Services

Silver:
+ Command Prompt
+ Consistent State

Are you interested in joining these generous businesses in sponsoring the 
PostgreSQL event of 2016? We invite you to view our sponsorship prospectus 
slideshow at 
http://www.pgconf.us/static/prospectus/PGConf-US-2016-Prospectus.pdf

We look forward to seeing everyone in April to make this the best PostgreSQL 
conference in the United States to date!

For more information, please visit http://www.pgconf.us/

[ANNOUNCE] Announcing Postico, a modern PostgreSQL client for OS X

[Jakob Egger]

I'd like to announce Postico, my new PostgreSQL client app for OS X.

Postico has a well-designed graphical user interface targeted at application 
developers, students and data analysts.

https://eggerapps.at/postico/ 


HIGHLIGHTS

- Postico offers a powerful structure editor for designing tables. Edit column 
names, types, foreign keys and constraints in an intuitive user interface.

- Browse tables, filter rows, and edit individual rows or even multiple rows at 
once. Postico is has great data entry tools suitable for business users and 
developers alike.

- A convenient SQL Query editor for executing complex queries, with support for 
multiple results

- Postico is also great as a client for data warehousing solutions like Amazon 
Redshift

After almost a year in Beta, I've now officially released Postico. Postico, 
which is the successor to PG Commander, is available directly from my website 
or on the Mac App Store.


LINKS

Postico Website: https://eggerapps.at/postico/ 
Mac App Store: https://itunes.apple.com/us/app/postico/id1031280567?ls=1&mt=12 



Best regards,
Jakob Egger


--
https://eggerapps.at 

[ANNOUNCE] == PostgreSQL Weekly News - November 29 2015 ==

[David Fetter]

== PostgreSQL Weekly News - November 29 2015 ==

PostgreSQL 9.5 Beta 2 released.
http://www.postgresql.org/about/news/1625/

PostgreSQL 9.6devel RPMs are available for testers. Please use only
for crash testing.
http://www.postgresql.org/message-id/1447660638.4285.45.ca...@gunduz.org
http://yum.PostgreSQL.org

FOSDEM PGDay is a one day conference that will be held ahead of FOSDEM in
Brussels, Belgium, on Jan 29th, 2016.  Details and CfP below:
http://fosdem2016.pgconf.eu/

Prague PostgreSQL Developer Day 2016 (P2D2 2016) is a two-day conference
that will be held on February 17-18 2016 in Prague, Czech Republic.
Czech language web site below:
http://www.p2d2.cz/

The first pan-Asian PostgreSQL conference will be held March 2016 in
Singapore.  The CfP is open.
http://2016.pgday.asia/

== PostgreSQL Product News ==

barman 1.5.1, a backup and recovery manager for PostgreSQL, released.
http://www.pgbarman.org/barman-1-5-1-released/

== PostgreSQL Jobs for November ==

http://archives.postgresql.org/pgsql-jobs/2015-11/

== PostgreSQL Local ==

PGConf Silicon Valley 2015 is November 17-18 at the South San
Francisco Convention Center.
http://www.pgconfsv.com

PGBR2015 (The Brazilian PostgreSQL Conference) will take place in Porto
Alegre, Rio Grande do Sul, on November 18, 19 and 20.  Registration is
open.
http://pgbr.postgresql.org.br/2015/en/

Postgres Conference China 2015 will be on November 20-22, 2015 in
Beijing.
http://postgres2015.eventdove.com/   (Chinese)
http://postgrescluster2015.eventdove.com/ (English)

PGConf.DE will be held on November 26-27, 2015 in Hamburg, Germany, at
the Lindner Hotel am Michel.
http://2015.pgconf.de/

PostgreSQL@SCaLE is a two day, two track event which takes place on Jan.
21-22, 2016, at Pasadena Convention Center, as part of SCaLE 14X.
The CfP is open until Oct 30, 2015.
https://www.socallinuxexpo.org/scale/14x/cfp

== PostgreSQL in the News ==

Planet PostgreSQL: http://planet.postgresql.org/

PostgreSQL Weekly News is brought to you this week by David Fetter

Submit news and announcements by Sunday at 3:00pm Pacific time.
Please send English language ones to da...@fetter.org, German language
to p...@pgug.de, Italian language to p...@itpug.org.  Spanish language
to p...@arpug.com.ar.

== Applied Patches ==

Tom Lane pushed:

- Speed up ruleutils' name de-duplication code, and fix
  overlength-name case.  Since commit
  11e131854f8231a21613f834c40fe9d046926387, ruleutils.c has attempted
  to ensure that each RTE in a query or plan tree has a unique alias
  name.  However, the code that was added for this could be quite
  slow, even as bad as O(N^3) if N identical RTE names must be
  replaced, as noted by Jeff Janes.  Improve matters by building a
  transient hash table within set_rtable_names.  The hash table in
  itself reduces the cost of detecting a duplicate from O(N) to O(1),
  and we can save another factor of N by storing the number of
  de-duplicated names already created for each entry, so that we don't
  have to re-try names already created.  This way is probably a bit
  slower overall for small range tables, but almost by definition,
  such cases should not be a performance problem.  In principle the
  same problem applies to the column-name-de-duplication code; but in
  practice that seems to be less of a problem, first because N is
  limited since we don't support extremely wide tables, and second
  because duplicate column names within an RTE are fairly rare, so
  that in practice the cost is more like O(N^2) not O(N^3).  It would
  be very much messier to fix the column-name code, so for now I've
  left that alone.  An independent problem in the same area was that
  the de-duplication code paid no attention to the identifier length
  limit, and would happily produce identifiers that were longer than
  NAMEDATALEN and wouldn't be unique after truncation to NAMEDATALEN.
  This could result in dump/reload failures, or perhaps even views
  that silently behaved differently than before.  We can fix that by
  shortening the base name as needed.  Fix it for both the relation
  and column name cases.  In passing, check for interrupts in
  set_rtable_names, just in case it's still slow enough to be an
  issue.  Back-patch to 9.3 where this code was introduced.
  
http://git.postgresql.org/pg/commitdiff/8004953b5a2449c26c4e082771276b2f8629d153

- Fix possible internal overflow in numeric division.  div_var_fast()
  postpones propagating carries in the same way as mul_var(), so it
  has the same corner-case overflow risk we fixed in 246693e5ae8a36f0,
  namely that the size of the carries has to be accounted for when
  setting the threshold for executing a carry propagation step.  We've
  not devised a test case illustrating the brokenness, but the
  required fix seems clear enough.  Like the previous fix, back-patch
  to all active branches.  Dean Rasheed
  
http://git.postgresql.org/pg/commitdiff/5f10b7a604c87fc61a2c20a56552301f74c9bd5f

- Accept flex > 2.5.x in configu