Skip to content

=$
|

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

  • Waiting for PostgreSQL 14 – SEARCH and CYCLE clauses 604 views | 0 comments
  • Starting with Pg – where/how can I set configuration parameters? 560 views | 0 comments
  • Explaining the unexplainable – part 3 245 views | 0 comments
  • CHAR(x) vs. VARCHAR(x) vs. VARCHAR vs. TEXT – UPDATED 2010-03-03 198 views | 0 comments
  • Explaining the unexplainable – part 2 197 views | 0 comments
  • Starting with Pg – where are logs? 161 views | 0 comments
  • Why is UPSERT so complicated? 124 views | 0 comments
  • “ERROR: operator does not exist: integer = text” how to fix it? 107 views | 0 comments
  • explain.depesz.com. 96 views | 0 comments
  • Waiting for PostgreSQL 11 – Fast ALTER TABLE ADD COLUMN with a non-NULL default 95 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 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