::Planet PostgreSQL::::Planet PostgreSQL:: - http://www.planetpostgresql.org/David Fetter: PostgreSQL Weekly News - September 07 2008- September 8, 2008 PostgreSQL Weekly News - September 07 2008 8.4 CVS Snapshot RPMs are ready for testing. http:people.planetpostgresql.orgdevrimindex.phparchives121-Testers-8.4-snapshot-RPMs-are-available.html September CommitFest has begun! Interesting inew tems being reviewed include: column-level permissions, hash indexing, windowing functions, in-place upgrade and others. http:wiki.postgresql.orgwikiCommitFest:2008-09 What you can do: http:wiki.postgresql.orgwikiReviewing_a_Patch We also...http://people.planetpostgresql.org/dfetter/index.php?/archives/190-PostgreSQL-Weekly-News-... Leo Hsu and Regina Obe: How to restore select tables, select objects, and schemas from Pg Backup- September 7, 2008 One of the nice things about the PostgreSQL command-line restore tool is the ease with which you can restore select objects from a backup. We tend to use schemas for logical groupings which are partitioned by context, time, geography etc. Often times when we are testing things, we just want to restore one schema or set of tables from our backup because restoring a 100 gigabyte database takes a lot of space, takes more time and is unnecessary for our needs. In order to be able to accomplish...http://www.postgresonline.com/journal/index.php?/archives/71-How-to-restore-select-tables,... Leo Hsu and Regina Obe: CTEs and Windowing Functions in 8.4- September 7, 2008 As we mentioned in a previous article, RECURSIVE queries, often referred to in SQL ANSI specs and by DB2 and SQL Server as Common Table Expressions (CTE) will make it into the 8.4 release and can already be found in the dev source. Technically CTE is a superset and RECURSIVE queries are a subclass of CTE. Looks like basic windowing functionality will make it in 8.4 as well. A summary of where your favorite patches are at can be found at the September 2008 PostgreSQL 8.4 commit-fest summary...http://www.postgresonline.com/journal/index.php?/archives/70-CTEs-and-Windowing-Functions-... Leo Hsu and Regina Obe: Fibonacci, Graphs and Recursive Queries- September 7, 2008 One thing I'm really looking forward to have in the upcoming PostgreSQL 8.4 is the introduction of the WITH RECURSIVE feature that IBM DB2 and SQL Server 2005 already have. Oracle has it too but in a non-standard CONNECT BY so is much less portable. This is a feature that is perhaps more important to us for the kind of work we do than the much complained about lack of windowing functions. I was recently taking a snoop at IBM DB2 newsletter. Why I read magazines and newsletters on...http://www.postgresonline.com/journal/index.php?/archives/66-Fibonacci,-Graphs-and-Recursi... Hubert Lubaczewski: Waiting for 8.4 - ef in psql- September 6, 2008 Today, Tom Lane committed patch, written by Abhijit Menon-Sen, which adds interesting feature to psql. Namely - it simplifies changing definition of functions. Commit message pretty much explains everything: Implement a psql command "ef" to edit the definition of a function. In support of that, create a backend function pg_get_functiondef(). The psql command is functional but maybe a bit ...http://www.depesz.com/index.php/2008/09/06/waiting-for-84-ef-in-psql/ Bruce Momjian: Elephants Can Count Too- September 4, 2008 Postgres chose an elephant mascot in 1997 because of the saying, "Elephants never forget". Research now shows that elephants can count too.http://momjian.us/main/blogs/pgblog.html#September_4_2008 Devrim Gndz: Testers: 8.4 snapshot RPMs are available- September 3, 2008 If you are a Fedora-9 or RHELCentOS 5 user and want to test new features of PostgreSQL 8.4 and help development team, you may use the packages that I have just released, based on today's CVS snapshot. I am planning to push new packages each weekend during commitfest.Please note that these packages are not built using the official tarball. I built it with the help of some PostgreSQL hackers.These are not stable packages. Use them at your own risk. They are not production ready.As usual, the RPMs.http://people.planetpostgresql.org/devrim/index.php?/archives/121-Testers-8.4-snapshot-RPM... Robert Treat: ZFS, databases, and common threads- September 2, 2008 Yesterday Neil mentioned his "systems" class at Berkely, which studies common themes among operating systems, networking, and databases. I wonder if they will study ZFS at all. One of the things I find interesting about ZFS is that it shares many common ideas from the database world, including things like durability, transactions, commit logs, and buffer caches. They sometimes refer to these thing with different terms, but the ideas are basically the same. If you'd like to learn more, there is..http://people.planetpostgresql.org/xzilla/index.php?/archives/357-ZFS,-databases,-and-comm... Robert Hodges: Continuent Community Site for Database Scale-Out- September 1, 2008 Our goal at Continuent is to be the go-to guys for database scale-out. Last Thursday we opened up a new community site for scale-out software at http:community.continuent.com. The site is driven by Joomla and has a number of very nice additions like Fireboard Forums and Mediawikis for each project. The first day or two was a bit bumpy as we nailed down some final issues, but most features are now working. We hope the result will be a nice place to meet other people who are interested in...http://scale-out-blog.blogspot.com/2008/09/continuent-community-site-for-database.html David Fetter: PostgreSQL Weekly News - August 31 2008- September 1, 2008 PostgreSQL Weekly News - August 31 2008 September's Commitfest starts tomorrow. A PostgreSQL developer room is available for the afternoon of October 16th, the day before PGDay 2008 starts. Let's make great use of that! September 10 is the last day to sign for PGDay 2008's "conference bags" advertising partnership. For a free entry PGDay 2008 edition we need a few more partners, especially from Silver level up. Please visit the partnership page for more information:...http://people.planetpostgresql.org/dfetter/index.php?/archives/189-PostgreSQL-Weekly-News-... |