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

Month: June 2016

What’s happening in my database?

Lately at least two people on irc asked questions similar to “how do I know how many queries there are in database, per second?“.

So, let's see what we can find out.

Continue reading What's happening in my database?

Posted on 2016-06-292016-06-29|Tags awk, performance, pg_stat_activity, pg_stat_all_tables, pg_stat_database, postgresql, psql, ruby, stats|3 Comments on What’s happening in my database?

Incrementing counters in database

Some time ago someone on irc asked about creating fast counters for something (banners I think).

I talked with her (him?) about it, but figured, I can as well write a blogpost, so others can use it too.

Continue reading Incrementing counters in database

Posted on 2016-06-14|Tags counter, cron, increment, irc, postgresql, trigger|22 Comments on Incrementing counters in database

Search

Follow me

  • Comments RSS
  • Posts RSS

Popular Posts

  • Explaining the unexplainable – part 2 201 views | 0 comments
  • Explaining the unexplainable – part 3 200 views | 0 comments
  • CHAR(x) vs. VARCHAR(x) vs. VARCHAR vs. TEXT – UPDATED 2010-03-03 161 views | 0 comments
  • Changes on explain.depesz.com – extracted query from auto-explain plans 128 views | 0 comments
  • explain.depesz.com. 109 views | 0 comments
  • Why is UPSERT so complicated? 105 views | 0 comments
  • How much RAM is PostgreSQL using? 99 views | 0 comments
  • “ERROR: operator does not exist: integer = text” how to fix it? 97 views | 0 comments
  • Waiting for PostgreSQL 14 – Improvements for handling large number of connections 90 views | 0 comments
  • Waiting for PostgreSQL 14 – SEARCH and CYCLE clauses 85 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