Skip to content

=$
|

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

Counting number of distinct elements

When I was working for one of customers we found some strange thing. We needed to found number of distinct sessions per day. Table layout was very simple:

Continue reading Counting number of distinct elements

Posted on 2008-05-22|Tags count, distinct, group by, performance, postgresql, surprise|2 Comments on Counting number of distinct elements

postgresql @ highscalability.com

as you perhaps know there is this site/blog called high scalability. it contains articles about various things related to performance, scalability, availability and so on.

usually, when there is something about databases, it is about mysql. luckily for us, today they showed something about postgresql:

“Skype Plans for PostgreSQL to Scale to 1 Billion Users“.

Posted on 2008-04-06|Tags performance, postgresql, scalability, skype|

Posts pagination

Previous page Page 1 … Page 5 Page 6

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 19
    • … 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