Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] Slow count(*) again...

From: Samuel Gendler <sgendler(at)ideasculptor(dot)com>
To: Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
Cc: Andrew Dunstan <andrew(at)dunslane(dot)net>, Bruce Momjian <bruce(at)momjian(dot)us>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "david(at)lang(dot)hm" <david(at)lang(dot)hm>, Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>, Vitalii Tymchyshyn <tivv00(at)gmail(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: [HACKERS] Slow count(*) again...
Date: 2011-02-02 03:13:38
Message-ID: AANLkTikftsY8=sFf9X6XD6B37-LBHykHzY4ByMPNRZFA@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-performance
On Tue, Feb 1, 2011 at 3:44 PM, Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>wrote:

> On 2/1/2011 6:03 PM, Andrew Dunstan wrote:
>
>> Whether or not it's bad application design, it's ubiquitous, and we
>> should make it work as best we can, IMNSHO. This often generates
>> complaints about Postgres, and if we really plan for world domination
>> this needs to be part of it.
>>
>
> There are many other things to fix first. One of them would be optimizer
> decisions when a temp table is involved. I would also vote for wait event
> interface, tracing and hints, much rather than speeding up count(*). World
> domination will not be achieved by speeding up count(*), it will be achieved
> by providing overall performance akin to what the player who has already
> achieved the world domination. I believe that the company is called "Oracle
> Corp." or something like that?
>
>
> Mladen Gogala
> Sr. Oracle DBA
>

Don't listen to him.  He's got an oracle bias.  Slashdot already announced
that NoSQL is actually going to dominate the world, so postgres has already
lost that battle.  Everything postgres devs do now is just an exercise in
relational masturbation.  Trust me.

In response to

Responses

pgsql-performance by date

Next:From: Mladen GogalaDate: 2011-02-02 03:40:16
Subject: Re: [HACKERS] Slow count(*) again...
Previous:From: Greg SmithDate: 2011-02-02 01:30:20
Subject: Re: Are we in the ballpark?

pgsql-hackers by date

Next:From: Luis OchoaDate: 2011-02-02 03:25:34
Subject: A postgres parser related question
Previous:From: Mladen GogalaDate: 2011-02-01 23:44:17
Subject: Re: [HACKERS] Slow count(*) again...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group