PostgreSQL

• About this group
• Forums

• Home
• Groups
• PostgreSQL
• Forums
• Introductions
• the way to go

• 
  Markus Dresch

  The company name is only visible to registered members.

  the way to go

  hello, my name is markus dresch and i'm a software and webapplication developer.
  
  a few years ago i switched from mysql to postgres, because of mysql's limitations compared to postgre's power. postgres indeed is the most advanced open source database system i know of. what i particularly like is the possibility to add functions in just about any programing language.
  
  one thing that took me a while to figure out is pgsql's memory management. pgsql would sometimes quit/not start, giving some cryptic error message about memory corruption. the reason being some wrong settings in the configuration. semaphores, cache and such.
  
  another thing that takes some getting used to is the overhead generated by new connections. this makes particularly webapplications appear slow. i overcome this issue with skype's pgbouncer, which keeps connection's open and reduces this overhead to a minimum.
  
  • 15 Oct 2008, 6:22 pm
  Markus Dresch wrote: > hello, my name is markus dresch and i'm a software and webapplication > developer. > > a few years ago i switched from mysql to postgres, because of mysql's > limitations compared to postgre's power. postgres indeed is the most > advanced open source database system i know of. what i particularly > like is the possibility to add functions in just about any programing > language. > > one thing that took me a while to figure out is pgsql's memory > management. pgsql would sometimes quit/not start, giving some cryptic > error message about memory corruption. the reason being some wrong > settings in the configuration. semaphores, cache and such. > > another thing that takes some getting used to is the overhead > generated by new connections. this makes particularly webapplications > appear slow. i overcome this issue with skype's pgbouncer, which > keeps connection's open and reduces this overhead to a minimum.