Skip to content

=$
|

  • Why upgrade PG?
  • explain.D.C
  • paste.D.C
  • Waiting for …
    • … PostgreSQL 18
    • … PostgreSQL 17
    • … PostgreSQL 16
    • … PostgreSQL 15
    • … PostgreSQL 14
    • … PostgreSQL 13
    • … PostgreSQL 12
    • … PostgreSQL 11
    • … PostgreSQL 10
    • … PostgreSQL 9.6
    • … PostgreSQL 9.5
    • … PostgreSQL 9.4
    • … PostgreSQL 9.3
    • … PostgreSQL 9.2
    • … PostgreSQL 9.1
    • … PostgreSQL 9.0
    • … PostgreSQL 8.5
    • … PostgreSQL 8.4
  • Projects
  • Contact

Tag: comparison

Index on (a,b) vs. (b,a)?

Whenever you are considering creation of multicolumn index, there is a question what should be the order of columns in this index. I'll try to analyze various cases of this situation.

Continue reading Index on (a,b) vs. (b,a)?

Posted on 2013-01-28|Tags comparison, index, postgresql, selectivity|7 Comments on Index on (a,b) vs. (b,a)?

To rule or not to rule – that is the question

Every now and then there is someone on IRC, mailing lists, or private contact which asks about rules.

My answer virtually always is: don't use rules. If you think that they solve your problem, think again. Why?

Continue reading To rule or not to rule – that is the question

Posted on 2010-06-15|Tags benchmark, comparison, opinion, postgresql, rule, rules, trigger, triggers|29 Comments on To rule or not to rule – that is the question

searching for longest prefix

couple of times is was brought to attention of #postgresql channel – how to find longest prefix.

case: you have phone number, and you want to find which carrier it is bound to.

there are at least 3 ways of finding it, and i decided to take a look at which is fastest.

Continue reading searching for longest prefix

Posted on 2008-03-04|Tags benchmark, comparison, postgresql, prefix|24 Comments on searching for longest prefix

Search

Follow me

  • Comments RSS
  • Posts RSS

PostgreSQL

  • Documentation
  • Explain Analyze analyzer
  • IRC help channel
  • Mailing Lists search
  • PG Planet
  • PostgreSQL Home Page

About me

  • CPAN
  • GitLab
  • Linked In
  • Why upgrade PG?
  • explain.D.C
  • paste.D.C
  • Waiting for …
    • … PostgreSQL 18
    • … PostgreSQL 17
    • … PostgreSQL 16
    • … PostgreSQL 15
    • … PostgreSQL 14
    • … PostgreSQL 13
    • … PostgreSQL 12
    • … PostgreSQL 11
    • … PostgreSQL 10
    • … PostgreSQL 9.6
    • … PostgreSQL 9.5
    • … PostgreSQL 9.4
    • … PostgreSQL 9.3
    • … PostgreSQL 9.2
    • … PostgreSQL 9.1
    • … PostgreSQL 9.0
    • … PostgreSQL 8.5
    • … PostgreSQL 8.4
  • Projects
  • Contact