Skip to content

Unterlagen für Tutorial beim Perl-Workshop in Frankfurt/Main

Die Unterlagen für das Tutorial beim Perl-Workshop 2009 in Frankfurt/Main am 25.02.2009 sind unter:

http://andreas.scherbaum.la/writings/

zu finden. Folgende Änderungen wurden gegenüber dem Vortrag vorgenommen:

- ein falscher Variablenbezeichner im "Perl" Teil wurde korrigiert

- Beispiele für Nutzung von SPI in Perl Stored Procedures wurden aufgenommen

Viel Spass mit den Unterlagen

Update: Die Unterlagen aller Vorträge gibt es im Wiki: http://conferences.yapceurope.org/gpw2009/wiki?node=Slides

  • Twitter
  • Bookmark Unterlagen für Tutorial beim Perl-Workshop in Frankfurt/Main at del.icio.us
  • Facebook
  • Google Bookmarks
  • FriendFeed
  • Digg Unterlagen für Tutorial beim Perl-Workshop in Frankfurt/Main
  • Bloglines Unterlagen für Tutorial beim Perl-Workshop in Frankfurt/Main
  • Technorati Unterlagen für Tutorial beim Perl-Workshop in Frankfurt/Main
  • Fark this: Unterlagen für Tutorial beim Perl-Workshop in Frankfurt/Main
  • Bookmark Unterlagen für Tutorial beim Perl-Workshop in Frankfurt/Main at YahooMyWeb
  • Bookmark Unterlagen für Tutorial beim Perl-Workshop in Frankfurt/Main at Furl.net
  • Bookmark Unterlagen für Tutorial beim Perl-Workshop in Frankfurt/Main at reddit.com
  • Bookmark Unterlagen für Tutorial beim Perl-Workshop in Frankfurt/Main at blinklist.com
  • Bookmark Unterlagen für Tutorial beim Perl-Workshop in Frankfurt/Main at Spurl.net
  • Bookmark Unterlagen für Tutorial beim Perl-Workshop in Frankfurt/Main at Simpy.com
  • Bookmark Unterlagen für Tutorial beim Perl-Workshop in Frankfurt/Main at blogmarks
  • Bookmark Unterlagen für Tutorial beim Perl-Workshop in Frankfurt/Main with wists
  • wong it!
  • Bookmark using any bookmark manager!
  • Stumble It!
  • Identi.ca

PostgreSQL and the Perl Workshop 2009 in Frankfurt (Main)

There will be a workshop "optimize PostgreSQL, combine Perl and PostgreSQL" at the Perl Workshop 2009 on february 25 in Frankfurt/Main in Germany.

More details (in german) are available at: http://www.perl-workshop.de/talks/151/view

The full timetable (also mostly in german) for the workshop is available at: http://www.perl-workshop.de/en/2009/zeitplan.html

  • Twitter
  • Bookmark PostgreSQL and the Perl Workshop 2009 in Frankfurt (Main) at del.icio.us
  • Facebook
  • Google Bookmarks
  • FriendFeed
  • Digg PostgreSQL and the Perl Workshop 2009 in Frankfurt (Main)
  • Bloglines PostgreSQL and the Perl Workshop 2009 in Frankfurt (Main)
  • Technorati PostgreSQL and the Perl Workshop 2009 in Frankfurt (Main)
  • Fark this: PostgreSQL and the Perl Workshop 2009 in Frankfurt (Main)
  • Bookmark PostgreSQL and the Perl Workshop 2009 in Frankfurt (Main) at YahooMyWeb
  • Bookmark PostgreSQL and the Perl Workshop 2009 in Frankfurt (Main) at Furl.net
  • Bookmark PostgreSQL and the Perl Workshop 2009 in Frankfurt (Main) at reddit.com
  • Bookmark PostgreSQL and the Perl Workshop 2009 in Frankfurt (Main) at blinklist.com
  • Bookmark PostgreSQL and the Perl Workshop 2009 in Frankfurt (Main) at Spurl.net
  • Bookmark PostgreSQL and the Perl Workshop 2009 in Frankfurt (Main) at Simpy.com
  • Bookmark PostgreSQL and the Perl Workshop 2009 in Frankfurt (Main) at blogmarks
  • Bookmark PostgreSQL and the Perl Workshop 2009 in Frankfurt (Main) with wists
  • wong it!
  • Bookmark using any bookmark manager!
  • Stumble It!
  • Identi.ca

Speed up your Serendipity blog running on PostgreSQL

In the last days i monitored the PostgreSQL logfile on my webserver to find slow queries in the Serendipity blog software. I was hunting another bug in the "events" module so i decided it's woth the additional work and maybe i can tweak some settings to speed up the response time a bit.

Continue reading "Speed up your Serendipity blog running on PostgreSQL"
  • Twitter
  • Bookmark Speed up your Serendipity blog running on PostgreSQL at del.icio.us
  • Facebook
  • Google Bookmarks
  • FriendFeed
  • Digg Speed up your Serendipity blog running on PostgreSQL
  • Bloglines Speed up your Serendipity blog running on PostgreSQL
  • Technorati Speed up your Serendipity blog running on PostgreSQL
  • Fark this: Speed up your Serendipity blog running on PostgreSQL
  • Bookmark Speed up your Serendipity blog running on PostgreSQL at YahooMyWeb
  • Bookmark Speed up your Serendipity blog running on PostgreSQL at Furl.net
  • Bookmark Speed up your Serendipity blog running on PostgreSQL at reddit.com
  • Bookmark Speed up your Serendipity blog running on PostgreSQL at blinklist.com
  • Bookmark Speed up your Serendipity blog running on PostgreSQL at Spurl.net
  • Bookmark Speed up your Serendipity blog running on PostgreSQL at Simpy.com
  • Bookmark Speed up your Serendipity blog running on PostgreSQL at blogmarks
  • Bookmark Speed up your Serendipity blog running on PostgreSQL with wists
  • wong it!
  • Bookmark using any bookmark manager!
  • Stumble It!
  • Identi.ca

Performance issues

Last year, tweakers.net did some performance tests with MySQL and PostgreSQL and they found out that MySQL did not scale very well with many concurrent connections.


Now Kris Kennaway did some tests on his own and posted the results to the FreeBSD performance list. The resulting graphs look very similar.

  • Twitter
  • Bookmark Performance issues at del.icio.us
  • Facebook
  • Google Bookmarks
  • FriendFeed
  • Digg Performance issues
  • Bloglines Performance issues
  • Technorati Performance issues
  • Fark this: Performance issues
  • Bookmark Performance issues at YahooMyWeb
  • Bookmark Performance issues at Furl.net
  • Bookmark Performance issues at reddit.com
  • Bookmark Performance issues at blinklist.com
  • Bookmark Performance issues at Spurl.net
  • Bookmark Performance issues at Simpy.com
  • Bookmark Performance issues at blogmarks
  • Bookmark Performance issues with wists
  • wong it!
  • Bookmark using any bookmark manager!
  • Stumble It!
  • Identi.ca

Avoid autovacuum for entire databases

We have a database with production data for a platform and another database with a production database dump for testing queries. We also have a test database but this one has slightly different DDL because it's for developing new features. Now autovacuum is running on this server and keeps vacuuming this test database.
A simple way for stopping autovacuum from even checking this db at all is adding an entry for every table in pg_autovacuum:


INSERT INTO pg_autovacuum
(vacrelid, enabled, vac_base_thresh, vac_scale_factor, anl_base_thresh, anl_scale_factor, vac_cost_delay, vac_cost_limit, freeze_min_age, freeze_max_age)
SELECT oid,false,-1,-1,-1,-1,-1,-1,-1,-1 FROM pg_class WHERE relkind='r';


This adds a stop entry for every table in your database, even for system tables. If you want the autovacuum daemon to just ignore tables from a specific schema, add a "relnamespace=scheme_oid" in the WHERE clause.


  • Twitter
  • Bookmark Avoid autovacuum for entire databases at del.icio.us
  • Facebook
  • Google Bookmarks
  • FriendFeed
  • Digg Avoid autovacuum for entire databases
  • Bloglines Avoid autovacuum for entire databases
  • Technorati Avoid autovacuum for entire databases
  • Fark this: Avoid autovacuum for entire databases
  • Bookmark Avoid autovacuum for entire databases at YahooMyWeb
  • Bookmark Avoid autovacuum for entire databases at Furl.net
  • Bookmark Avoid autovacuum for entire databases at reddit.com
  • Bookmark Avoid autovacuum for entire databases at blinklist.com
  • Bookmark Avoid autovacuum for entire databases at Spurl.net
  • Bookmark Avoid autovacuum for entire databases at Simpy.com
  • Bookmark Avoid autovacuum for entire databases at blogmarks
  • Bookmark Avoid autovacuum for entire databases with wists
  • wong it!
  • Bookmark using any bookmark manager!
  • Stumble It!
  • Identi.ca

some tests from tweakers.net

tweakers.net has tested again the performance of PostgreSQL 8.2-dev and Mysql 4.1.20 and Mysql 5.0.20a. Results are nice and shown here.

Best thing: the collapses for requests per seconds if Mysql has a concurrency greater than 7. Oh, and by the way, they don't state the table type for Mysql so we don't know, if it is the fast and forgetfully MyIsam or the better but slower InnoDB type.

  • Twitter
  • Bookmark some tests from tweakers.net at del.icio.us
  • Facebook
  • Google Bookmarks
  • FriendFeed
  • Digg some tests from tweakers.net
  • Bloglines some tests from tweakers.net
  • Technorati some tests from tweakers.net
  • Fark this: some tests from tweakers.net
  • Bookmark some tests from tweakers.net at YahooMyWeb
  • Bookmark some tests from tweakers.net at Furl.net
  • Bookmark some tests from tweakers.net at reddit.com
  • Bookmark some tests from tweakers.net at blinklist.com
  • Bookmark some tests from tweakers.net at Spurl.net
  • Bookmark some tests from tweakers.net at Simpy.com
  • Bookmark some tests from tweakers.net at blogmarks
  • Bookmark some tests from tweakers.net with wists
  • wong it!
  • Bookmark using any bookmark manager!
  • Stumble It!
  • Identi.ca

Openldap and performance of back-sql

If you experience performance problems in openldap, especially with a back-sql backend, try to deactivate the debugging in openldap.

In particular the debugging mode 128 (access control list processing) needs a lot performance.

  • Twitter
  • Bookmark Openldap and performance of back-sql at del.icio.us
  • Facebook
  • Google Bookmarks
  • FriendFeed
  • Digg Openldap and performance of back-sql
  • Bloglines Openldap and performance of back-sql
  • Technorati Openldap and performance of back-sql
  • Fark this: Openldap and performance of back-sql
  • Bookmark Openldap and performance of back-sql at YahooMyWeb
  • Bookmark Openldap and performance of back-sql at Furl.net
  • Bookmark Openldap and performance of back-sql at reddit.com
  • Bookmark Openldap and performance of back-sql at blinklist.com
  • Bookmark Openldap and performance of back-sql at Spurl.net
  • Bookmark Openldap and performance of back-sql at Simpy.com
  • Bookmark Openldap and performance of back-sql at blogmarks
  • Bookmark Openldap and performance of back-sql with wists
  • wong it!
  • Bookmark using any bookmark manager!
  • Stumble It!
  • Identi.ca