Skip to content

=$
|

  • Why upgrade PG?
  • explain.D.C
  • paste.D.C
  • Waiting for …
    • … 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: tutorial

How to make sure there is always at least one “sub” record?

This question appeared couple of times on irc, so I figured I can do a blogpost about it.

Continue reading How to make sure there is always at least one “sub" record?

Posted on 2017-07-03|Tags constraint, count, howto, postgresql, trigger, tutorial|10 Comments on How to make sure there is always at least one “sub” record?

What index to create?

Some time ago I wrote a blogpost about why index might not be used.

While this post seemed to be well received (top link from depesz.com on reddit), it doesn't answer another question – what index to create for given situation.

I'll try to cover this question now.

Continue reading What index to create?

Posted on 2011-09-282011-09-28|Tags index, multicolumn, partial index, performance, postgresql, tutorial|9 Comments on What index to create?

Search

Follow me

  • Comments RSS
  • Posts RSS

Popular Posts

  • How to effectively dump PostgreSQL databases 830 views | 2 comments
  • "ERROR: operator does not exist: integer = text" how to fix it? 291 views | 0 comments
  • Explaining the unexplainable – part 3 277 views | 0 comments
  • Waiting for 9.1 - FOREACH IN ARRAY 245 views | 0 comments
  • Incrementing counters in database 241 views | 0 comments
  • How much RAM is PostgreSQL using? 233 views | 0 comments
  • Explaining the unexplainable - part 2 203 views | 0 comments
  • Waiting for 9.6 - Add IF NOT EXISTS processing to ALTER TABLE ADD COLUMN 177 views | 0 comments
  • CHAR(x) vs. VARCHAR(x) vs. VARCHAR vs. TEXT - UPDATED 2010-03-03 174 views | 0 comments
  • Understanding postgresql.conf : log* 145 views | 0 comments

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 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