David Fetter's blog

Wednesday, July 1. 2009

WITH (so much drama in the CTE)

By now, you've probably seen that PostgreSQL 8.4 can produce Mandelbrot sets
like the one below, but what are Common Table Expressions really about?
Continue reading "WITH (so much drama in the CTE)" »

Posted by

David Fetter

at 20:18 | Comment (1) | Trackbacks (0)

Saturday, June 6. 2009

Materialized Views Performance Tips

So you don't feel your clients' time is best spent on scanning a multi-million row table, and you've decided to materialize some views. Here are some principles to keep in mind as you go forward... Continue reading "Materialized Views Performance Tips" »

Posted by

David Fetter

at 07:08 | Comments (0) | Trackbacks (0)

Thursday, May 7. 2009

PGX!

Q: Where can you find decades of PostgreSQL expertise all in one spot?
A: PostgreSQL Experts, Inc.! Continue reading "PGX!" »

Posted by

David Fetter

at 17:56 | Comments (0) | Trackbacks (0)

Saturday, April 4. 2009

The Mange Guide to Databases: First Impressions

Big Eyes: Check
Tentacles: Nope (whew!)

Posted by

David Fetter

at 19:22 | Comments (0) | Trackbacks (0)

Wednesday, March 4. 2009

Mutt Majordomo Moderation, Modified

It turns out you don't even need vim for this part. Alvaro pointed out that mutt's native capability, along with Perl, can make moderation a one-keystroke operation. I've updated the script for strict-cleanliness and Perl 5.10 grammar. Continue reading "Mutt Majordomo Moderation, Modified" »

Posted by

David Fetter

at 22:55 | Comment (1) | Trackbacks (0)

Moderating Majordomo Lists with Vim and Mutt

So, you have the pleasure of moderating a high-traffic majordomo list, and you want to speed up the action you take once you've scanned the message in your in box. Here's a couple of things to put in your .vimrc to help: Continue reading "Moderating Majordomo Lists with Vim and Mutt" »

Posted by

David Fetter

at 09:07 | Comments (0) | Trackbacks (0)

Monday, February 23. 2009

Trip Report: FOSDEM 2009

Why it's important to go in person, reasons #187 and #188:

- 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

Continue reading "Trip Report: FOSDEM 2009" »

Posted by

David Fetter

at 05:58 | Comment (1) | Trackbacks (0)

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"

Posted by

David Fetter

at 06:15 | Comments (0) | Trackbacks (0)

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"

Posted by

David Fetter

at 03:34 | Comments (0) | Trackbacks (0)

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"

Posted by

David Fetter

at 04:46 | Comments (0) | Trackbacks (0)

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"

Posted by

David Fetter

at 05:50 | Comments (0) | Trackbacks (0)

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 =="

Posted by

David Fetter

at 05:40 | Comments (0) | Trackbacks (0)

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"

Posted by

David Fetter

at 04:09 | Comments (0) | Trackbacks (0)

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"

Posted by

David Fetter

at 03:52 | Comments (0) | Trackbacks (0)