Category: PostgreSQL

Posted on: March 12, 2019 Posted by: John Huh Comments: 0

Count What?

Found this article today to optimize count on Postgresql DBMS. I wonder if this will work for my use case.   Source: https://www.cybertec-postgresql.com/en/postgresql-count-made-fast/  

Posted on: August 9, 2011 Posted by: John Huh Comments: 0

Use Postgresql for WordPress?

I would love to run WordPress on Postgresql database, simply because most of DBs I use are Postgresql-based. Here’s what WordPress says about it. http://codex.wordpress.org/Using_Alternative_Databases I’m sure there must be a way to make WordPress more portable to other databases. What’s your take on this?

Posted on: September 28, 2010 Posted by: John Huh Comments: 0

Postgresql 9.0 Cheatsheet

PostgreSQL 9.0 has been released. Here’s a cheatsheet for it: http://www.postgresonline.com/journal/archives/177-postgresql90_cheatsheet.html