Skip to content

=$
|

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

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?

Prepared statements gotcha

Friend from my previous employer told me that plans of execution of prepared statement, and the same statement run “as it" are different.

Well, I checked and this is what I found (it's not shocking, it's actually quite obvious, but You have to think about it for a while to “get it").

Continue reading Prepared statements gotcha

Posted on 2008-05-102008-05-10|Tags explain, partial index, plan, postgresql, prepare|10 Comments on Prepared statements gotcha

Search

Follow me

  • Comments RSS
  • Posts RSS

Popular Posts

  • Explaining the unexplainable – part 3 187 views | 0 comments
  • CHAR(x) vs. VARCHAR(x) vs. VARCHAR vs. TEXT – UPDATED 2010-03-03 184 views | 0 comments
  • Explaining the unexplainable – part 2 154 views | 0 comments
  • “ERROR: operator does not exist: integer = text” how to fix it? 146 views | 0 comments
  • how to insert data to database – as fast as possible 111 views | 0 comments
  • Why is UPSERT so complicated? 110 views | 0 comments
  • Waiting for PostgreSQL 11 – Fast ALTER TABLE ADD COLUMN with a non-NULL default 99 views | 0 comments
  • How to run short ALTER TABLE without long locking concurrent queries 94 views | 0 comments
  • Waiting for PostgreSQL 15 – Add support for MERGE SQL command 85 views | 0 comments
  • Explaining the unexplainable 74 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 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