::Planet PostgreSQL::::Planet PostgreSQL:: - http://www.planetpostgresql.org/Robert Treat: PostgreSQL Partitioning slides now on Slideshare- September 13, 2008 I think these use to be on the OmnitTI website, but must have gotten lost in the shuffle, so I've stuck them up on Slideshare for now. This version was given at pgcon 2007 (I think I have given it in a couple of other places as well, but should be mostly them same), so it's an oldie, but, hopefully a goodie as well. Enjoy! PostgreSQL Partitioning, PGCon 2007View SlideShare presentation or Upload your own. (tags: postgres postgresql)http://people.planetpostgresql.org/xzilla/index.php?/archives/359-PostgreSQL-Partitioning-... Hubert Lubaczewski: Getting record by 2 criteria, ordered by third - how to do it quickly- September 13, 2008 Let&8217;s assume we have a simple table: CREATE TABLE objects ( id serial primary key, category INT4 NOT NULL DEFAULT 0, object_type INT4 ...http://www.depesz.com/index.php/2008/09/13/getting-record-by-2-criteria-ordered-by-third-h... Hubert Lubaczewski: Waiting for 8.4 - pgbench with timed execution- September 13, 2008 Takahiro Itagaki wrote, and Tom Lane committed nice patch, which I personally find really helpful: Add a duration option to pgbench, so that test length can be specified in seconds instead of by number of transactions to run. Takahiro Itagaki You might wonder what&8217;s so great nice about it. Well, during my years as dba I&8217;ve ...http://www.depesz.com/index.php/2008/09/13/waiting-for-84-pgbench-with-timed-execution/ Stefan Kaltenbrunner: Nagios conference 2008- September 13, 2008 Long time no post - but I just got back home from the Netways Nagios Conference 2008 where I was invited to give a talk on "PostgreSQL Monitoring - Introduction, Internals And Monitoring Strategies for postgresql.org" so I figured it is time to say something again ... Continue reading "Nagios conference 2008"http://www.kaltenbrunner.cc/blog/index.php?/archives/25-Nagios-conference-2008.html Francisco Figueiredo Jr: Npgsql2 RC2 Released!!- September 12, 2008 Hi all! It's a great pleasure to say that Npgsql2 RC2 is released. From release notes: This version contains some fixes and updates for latest entity framework release. We are already in feature freeze and not so many things were added this time. Highlights include: Npgsql2 rc2 now supports .NET 3.5 sp1 with Entity Framework support. We support model generation by the command linehttp://fxjr.blogspot.com/2008/09/npgsql2-rc2-released.html Bruce Momjian: Event Attendance Cancellations- September 11, 2008 I have just informed event organizers that I cannot attend the Brazilian PostgreSQL Conference in late September. My father-in-law, who has lived with me since I got married in 1989, is terminally ill and I must help my family care for him. EnterpriseDB has been very supportive of my need for personal time. Read More »http://momjian.us/main/blogs/pgblog.html#September_11_2008 Selena Deckelmann: Filesystem IO at the Linux Plumbers Conference- September 10, 2008 graph from software raid, RAID10, no partition table, ext3, read-write load If you haven&8217;t heard, the Linux Plumbers Conference is happening September 17-19, 2008 in Portland, OR. It&8217;s a gathering designed to attract Linux developers - kernel hackers, tool developers and problem solvers. A few of us that met through the Portland PostgreSQL User Group (PDXPUG) pitched an idea for a talk on filesystem performance. We wanted to examine performance conventional wisdom and put it to the..http://www.chesnok.com/daily/2008/09/10/filesystem-io-at-the-linux-plumbers-conference/ Andreas Scherbaum: role ... cannot be dropped because some objects depend on it- September 10, 2008 Andreas 'ads' Scherbaum I want to drop a ROLE (previously USERGROUPs) which is still referenced by object(s) in my database. But PostgreSQL has objections:ERROR: role "xyz" cannot be dropped because some objects depend on itDETAIL: access to schema public Continue reading "role ... cannot be dropped because some objects depend on it"http://andreas.scherbaum.la/blog/archives/439-role-...-cannot-be-dropped-because-some-obje... US PostgreSQL Association: PgUS Memberships and Board Nominations Now Open- September 10, 2008 Greetings! A couple of related announcements: - You can now use the following URL to become a member of the United States PostgreSQL Association (PgUS): https:www.postgresql.usjoin Note the special combo rate for PgUS professional membership and PostgreSQL Conference West (October 10-12) registration; you can view a partial list of the West talks here: http:www.postgresqlconference.orgwest08talks - We are now accepting nominations for PgUS board for the October 2008 elections; please submit.http://www.postgresql.us/node/43 Hubert Lubaczewski: Waiting for 8.4 - ordered data loading in pg_dump- September 8, 2008 Great (and admittedly long overdue) patch by Tom Lane: Make pg_dump --data-only try to order the table dumps so that foreign keys' referenced tables are dumped before the referencing tables. This avoids failures when the data is loaded with the FK constraints already active. If no such ordering is possible because of circular or self-referential constraints, print a NOTICE ...http://www.depesz.com/index.php/2008/09/08/waiting-for-84-ordered-data-loading-in-pg_dump/ |