postgresql

kamal's picture

PHP CLI Segmentation Fault With pgsql

Posted Mon, 13/07/2009 - 14:09 by kamal

"Segmentation fault"

Got this every time running PHP from the command line, especially when working with Drupal. It doesn't caused any harm (script working just fine) and that's why I never look into it. But accidentally found this post and the suggested fix did remove the "Segmentation fault" message from appearing.

  • Commented pgsql in pgsql.ini
  • Load pgsql extension in curl.ini, before the curl extension.
angch's picture

#geekcamp Malaysia presentation: A Coder's Intro to PostgreSQL+PostGIS

Posted Wed, 10/06/2009 - 19:53 by angch

Gave a quick and dirty talk at #geekcamp Malaysia: A Coder's Intro to PostgreSQL + PostGIS.

This looks like a topic I'd be revisiting and revising as I'm heavily into PostGIS these days, and definitely felt that the I missed several important topics. I'll just put this up here for now, and we'll see how well it improves.

angch's picture

Drupal: PostgreSQL vs MySQL

Posted Thu, 26/03/2009 - 19:11 by angch

Let's get this out of the way first: MySQL beats PostgreSQL for Drupal sites in terms of raw performance. See this benchmark

But the real question is the how and why, and also how to make sites even faster and more scalable?

angch's picture

Dogfood, cobbler's kids, changes to blog.bytecraft.com.my

Posted Fri, 20/03/2009 - 13:16 by angch

Haven't been working on this site (blog.bytecraft.com.my) for a while. There are plenty of things that needs to be done, and while it's not perfect:

  • This site is based on our pulut's Drupal 6 branch. Easier to maintain several sites with well known and tested modules.

  • Changed the theme to Acquia's Marina. Still needs some tweaks to css for our content.

  • Experimenting with Drupal's cacherouter with memcache to speed things up.

  • Tweaked the PostgreSQL config a little (fsync is slow, asynchronous commit is a Good Thing). Yes, using MySQL for drupal would be faster, but it's dogfood, and we're more comfortable with PostgreSQL.

  • Added the lego logo.

Syndicate content