Wednesday, July 1. 2009
WITH (so much drama in the CTE)
like the one below, but what are Common Table Expressions really about?
Continue reading "WITH (so much drama in the CTE)" »
Saturday, June 6. 2009
Materialized Views Performance Tips
Thursday, May 7. 2009
PGX!
A: PostgreSQL Experts, Inc.! Continue reading "PGX!" »
Saturday, April 4. 2009
The Mange Guide to Databases: First Impressions
Tentacles: Nope (whew!)
Wednesday, March 4. 2009
Mutt Majordomo Moderation, Modified
Moderating Majordomo Lists with Vim and Mutt
Monday, February 23. 2009
Trip Report: FOSDEM 2009
- Spoke with Stéphane Schildknecht about his "little scripts" for controlling Slony clusters, which resulted in a pgfoundry project. Go, Stéphane!
- Discovered that Gevik Babakhani speaks fluent Farsi and was happy to become a point of contact for the Tehran PUG. Expect good stuff from there
Monday, December 10. 2007
Postgres Weekly News - December 09 2007
8.3 beta 4 is out. Keep on testing!
FISL 9.0 will be happening April 17-19, 2008 at PUCRS in Porto Alegre,
Brazil. Lecture proposals are due by December 17. Sorry about the
late notice.
https://fisl.softwarelivre.org/9.0/papers/speaker/
To help with the Italian translation of the Postgres documentation,
please visit:
https://labs.psql.it/wiki/Traduzioni
Developer.com survey: help bring PostgreSQL numbers up!
http://solutions.internet.com/index.php/4431_default/d06d68c39e4b77545d082da8d2ea5d86
PgCon.br was a smash hit with over 200 attendees.
http://www.postgresql.org.br/encontronacionalpostgresql
Xing now has a PostgreSQL group:
https://www.xing.com/net/postgresql
Postgres Product News
Full-page write improvement project is out.
http://pgfoundry.org/projects/pglesslog/
2ndQuadrant now has a PostgreSQL Performance course.
http://www.2ndquadrant.com/training.html
pgloader 2.2.5 released.
http://pgfoundry.org/projects/pgloader/
PostGis 1.3.2 released.
http://www.postgis.org/
Postgres Jobs for December
http://archives.postgresql.org/pgsql-jobs/2007-12/threads.php
Postgres Local
PGCon 2008 Call for Papers starts December 19. Start your papers now.
http://www.pgcon.org/2008/papers.php
The BSD and PostgreSQL teams share a developer room at FOSDEM 2008 in
Brussels. If you want to give a talk or help managing the dev room,
contact fosdem@pgug.eu. For more information, see:
http://fosdem.org/2008/schedule/devroom/bsdpostgresql
PostgreSQL Conference East '08 talks are March 28 and 29.
http://www.postgresqlconference.org/
Postgres in the News
Planet PostgreSQL: http://www.planetpostgresql.org/
General Bits, Archives and occasional new articles:
http://www.varlena.com/GeneralBits/
Postgres Weekly News is brought to you this week by David Fetter, Josh
Berkus, Devrim GUNDUZ and Enrico Pirozzi.
Submit news and announcements by Sunday at 3:00pm Pacific time.
Please send English language ones to david@fetter.org, German language
to pwn@pgug.de, Italian language to pwn@itpug.org.
Continue reading "Postgres Weekly News - December 09 2007"
Monday, December 3. 2007
Postgres Weekly News - December 02 2007
Postgres Weekly News - December 02 2007
8.3 beta 4 will be out soon. Keep on testing! ![]()
Josh Berkus will be speaking at FOSS.IN. Help make the BoF great!
http://www.foss.in/
David Fetter will be speaking at PgCon.BR in Sao Paulo December 7-8.
http://pgcon.postgresql.org.br/index.en.html
New Survey: When do you upgrade your PostgreSQL Server?
http://www.postgresql.org/community
Postgres Product News
Netvault v3.0 released.
www.bakbone.com/postgresql
Benetl 1.0 for Windows released.
http://www.benetl.net
Postgres Local
PGCon 2008 Call for Papers starts December 19. Start your papers now.
http://www.pgcon.org/2008/papers.php
PostgreSQL Conference East '08 talks are March 28 and 29.
http://www.postgresqlconference.org/
Postgres in the News
Planet PostgreSQL: http://www.planetpostgresql.org/
General Bits, Archives and occasional new articles:
http://www.varlena.com/GeneralBits/
Postgres 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 david@fetter.org, German language
to pwn@pgug.de, Italian language to pwn@itpug.org.
Continue reading "Postgres Weekly News - December 02 2007"
Monday, November 26. 2007
Postgres Weekly News - November 25 2007
Postgres Weekly News - November 25 2007
8.3 Beta 3 is out.
http://www.postgresql.org/developer/beta
The UK Postgres User Group will be meeting December 3. Mail Simon
Riggs <uk AT postgresql.org> for details.
IT-PUG is now a non-profit organization.
http://www.itpug.org/index.it.html
Postgres Product News
2ndQuadrant has a High Availability training course.
http://www.2ndquadrant.com/training.html
pgloader 2.2.4 released.
http://pgfoundry.org/projects/pgloader/
pgpool-II 2.0.1 released.
http://pgfoundry.org/projects/pgpool/
Pg::Snapshot and Materialized Views 0.3.1 released.
http://pgfoundry.org/projects/snapshot/
SkyTools 2.1.5 released.
http://pgfoundry.org/projects/skytools/
Postgres Jobs for November
http://archives.postgresql.org/pgsql-jobs/2007-11/threads.php
Postgres Local
Josh Berkus will be speaking at FOSS.IN. Help make the BoF great!
http://www.foss.in/
PgCon.BR will take place in Sao Paulo December 7-8.
http://pgcon.postgresql.org.br/index.en.html
PGCon 2008 Call for Papers starts December 19. Start your papers now.
http://www.pgcon.org/2008/papers.php
PostgreSQL Conference East '08 talks are March 28 and 29.
http://www.postgresqlconference.org/
Postgres in the News
Planet PostgreSQL: http://www.planetpostgresql.org/
General Bits, Archives and occasional new articles:
http://www.varlena.com/GeneralBits/
Postgres 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 david@fetter.org, German language
to pwn@pgug.de, Italian language to pwn@itpug.org.
Continue reading "Postgres Weekly News - November 25 2007"
Monday, November 19. 2007
Postgres Weekly News - November 18 2007
Postgres Weekly News - November 18 2007
PGCon 2008 Call for Papers starts December 19. Start your papers now.
http://www.pgcon.org/2008/papers.php
8.3 Beta 3 will be out soon. Keep testing!
Continuent has donated two servers to PostgreSQLFr and two others for
the upcoming PostgreSQL Europe group. Dalibo will be hosting all
four, just as it has hosted PostgreSQLFr since 2005.
The PostgreSQL Project needs regional contacts! Share the fame and
excitement by helping us get the news about the 8.3 release to press
and communities in your area. Particularly needed are contacts in
India, Africa, Southeast Asia, Mexico and the Pacific Islands.
Contact josh@postgresql.org to volunteer.
Postgres Product News
Lightning Admin Version 1.3.4 build 44 released.
http://www.amsoftwaredesign.com/down_loads
pgloader 2.2.3 released.
http://pgfoundry.org/projects/pgloader/
Slony-I 1.2.12 released.
http://slony.info/
Postgres Jobs for November
http://archives.postgresql.org/pgsql-jobs/2007-11/threads.php
Postgres Local
Josh Berkus will be speaking at FOSS.IN. Help make the BoF great!
http://www.foss.in/
PgCon.BR will take place in Sao Paulo December 7-8.
http://pgcon.postgresql.org.br/index.en.html
Postgres in the News
Planet PostgreSQL: http://www.planetpostgresql.org/
General Bits, Archives and occasional new articles:
http://www.varlena.com/GeneralBits/
Postgres 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 david@fetter.org, German language
to pwn@pgug.de, Italian language to pwn@itpug.org.
Continue reading "Postgres Weekly News - November 18 2007"
Monday, November 12. 2007
== Postgres Weekly News - November 11 2007 ==
Postgres Weekly News - November 11 2007
Look for 8.3 beta 3 late this week.
gborg.postgresql.org is dead. Long live pgfoundry.org!
Postgres Product News
Cybercluster 1.0.0 released.
http://pgfoundry.org/projects/cybercluster/
Npgsql2 Beta1 released.
http://pgfoundry.org/projects/npgsql/
pgloader 2.2.2 released.
http://pgfoundry.org/projects/pgloader/
Postgres Jobs for November
http://archives.postgresql.org/pgsql-jobs/2007-11/threads.php
Postgres Local
SFPUG will be meeting at Hyperic November 13 at 7:30pm. RSVP below.
http://postgresql.meetup.com/1/calendar/6522343/
Postgres in the News
Planet PostgreSQL: http://www.planetpostgresql.org/
General Bits, Archives and occasional new articles:
http://www.varlena.com/GeneralBits/
Postgres 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 david@fetter.org, German language
to pwn@pgug.de, Italian language to pwn@itpug.org.
Continue reading "== Postgres Weekly News - November 11 2007 =="
Monday, November 5. 2007
Postgres Weekly News - November 04 2007
Postgres Weekly News - November 04 2007
8.3 beta 2 is out. Test!
http://www.postgresql.org/ftp/source/v8.3beta
Which new PostgreSQL feature are you most excited about?
http://www.postgresql.org/community
Postgres Product News
Cybercluster, a PgCluster-based replication system, released under the BSDL.
http://www.postgresql.at/english/downloads_e.html
PgPool II 2.0 beta released.
http://pgfoundry.org/projects/pgpool/
PostgreSQL PHP Generator 7.10 released.
http://www.sqlmaestro.com/products/postgresql/phpgenerator/
Whitebeam 1.1.5 released.
http://www.whitebeam.org
Postgres Jobs for November
http://archives.postgresql.org/pgsql-jobs/2007-11/threads.php
Postgres Local
New Zealand PUG's first meeting will take place in Wellington
November 6, 2007. Details below.
http://pgug.org.nz
Check out the new German-language Postgres job board.
http://www.pg-forum.de/jobboerse-marktplatz/
Postgres in the News
Planet PostgreSQL: http://www.planetpostgresql.org/
General Bits, Archives and occasional new articles:
http://www.varlena.com/GeneralBits/
Postgres 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 david@fetter.org, German language
to pwn@pgug.de, Italian language to pwn@itpug.org.
Continue reading "Postgres Weekly News - November 04 2007"
Monday, October 29. 2007
Postgres Weekly News - October 28 2007
Postgres Weekly News - October 28 2007
8.3 beta 2 will be out soon thanks to your testing. Get ready to test
some more!
Postgres Product News
MicroOLAP Database Designer 1.2.2 for PostgreSQL released.
http://microolap.com/products/database/postgresql-designer/
Npgsql 1.0.1 released.
http://pgfoundry.org/projects/npgsql/
Debian now has orafce packages.
http://pgfoundry.org/projects/orafce/
PgBouncer 1.1.1 bugfix release is out.
http://pgfoundry.org/projects/pgbouncer/
pgpool-II 1.3 released.
http://pgfoundry.org/projects/pgpool/
Postgres Jobs for October
http://archives.postgresql.org/pgsql-jobs/2007-10/threads.php
Postgres Local
New Zealand PUG's first meeting will take place in Wellington
November 6, 2007. Details below.
http://pgug.org.nz
Check out the German-language Postgres job board.
http://www.pg-forum.de/jobboerse-marktplatz/
Postgres in the News
Planet PostgreSQL: http://www.planetpostgresql.org/
General Bits, Archives and occasional new articles:
http://www.varlena.com/GeneralBits/
Postgres 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 david@fetter.org, German language
to pwn@pgug.de, Italian language to pwn@itpug.org.
Continue reading "Postgres Weekly News - October 28 2007"
Monday, October 22. 2007
Postgres Weekly News - October 22 2007
Postgres Weekly News - October 22 2007
Watch for Postgres 8.3 beta 2, and keep testing. ![]()
The PostgreSQL Fall Conference was a smashing success. Pictures
below.
http://db.endpoint.com/pgcon07/
Postgres Product News
explain-analyze.info is now online!
http://explain-analyze.info
pgAdmin3 1.8.0 released.
http://www.pgadmin.org/news.php
PL/php 1.3.5 beta 1 released.
http://projects.commandprompt.com/public/plphp
Postgres Jobs for October
http://archives.postgresql.org/pgsql-jobs/2007-10/threads.php
Postgres Local
New Zealand PUG's first meeting will take place in Wellington
November 6, 2007. Details below.
http://pgug.org.nz
Check out the new German-language Postgres job board.
http://www.pg-forum.de/jobboerse-marktplatz/
Postgres in the News
Planet PostgreSQL: http://www.planetpostgresql.org/
General Bits, Archives and occasional new articles:
http://www.varlena.com/GeneralBits/
Postgres 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 david@fetter.org, German to
pwn@pgug.de.
Continue reading "Postgres Weekly News - October 22 2007"
