pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Torsten Zühlsdorff <foo@meisterderspiele.de>
To: pgsql-performance@postgresql.org
Subject: Re: [HACKERS] Slow count(*) again...
Date: Fri, 04 Feb 2011 09:43:23 +0100
Message-ID: <iige7c$ctl$1@news.eternal-september.org> (raw)
In-Reply-To: <4D4B3B41.7060803@vmsinfo.com>
References: <201102012247.p11Ml6u02682@momjian.us>
	<4D48914B.4050403@dunslane.net>
	<4D489AD1.1010105@vmsinfo.com>
	<AANLkTiknZi97dDwm7sHqy0EL7tpNEP9sY5uPV6AN+q=u@mail.gmail.com>
	<4D499E55.4020107@vmsinfo.com>
	<4D49A6B9.4060608@2ndquadrant.com>
	<4D49C482.4010707@vmsinfo.com>
	<4D49F0BA.9000901@2ndquadrant.com>
	<4D4A16BF.1020304@vmsinfo.com>
	<4D4A4844.3020409@2ndquadrant.com>
	<4D4AD9F6.6040903@vmsinfo.com>
	<4D4AE16E.9040807@peak6.com>
	<4D4B17B4.9030406@vmsinfo.com>
	<4D4B1F5B.4060403@peak6.com>
	<4D4B261B.6010303@vmsinfo.com>
	<AANLkTi=6_7N4EuT-trfPbxb9UmanJsnL+ineO-iJUFtJ@mail.gmail.com>
	<4D4B2E8A.7010402@vmsinfo.com>
	<4D4ADF42020000250003A34C@gw.wicourts.gov>
	<4D4B3B41.7060803@vmsinfo.com>

Mladen Gogala schrieb:

> Well, the problem will not go away.  As I've said before, all other 
> databases have that feature and none of the reasons listed here 
> convinced me that everybody else has a crappy optimizer.  The problem 
> may go away altogether if people stop using PostgreSQL.

A common problem of programmers is, that they want a solution they 
already know for a problem they already know, even if it is the worst 
solution the can choose.

There are so many possibilities to solve a given problem and you even 
have time to do this before your application get released.

Also: if you rely so heavily on hints, then use a database which 
supports hints. A basic mantra in every training i have given is: use 
the tool/technic/persons which fits best for the needs of the project. 
There are many databases out there - choose for every project the one, 
which fits best!

Greetings from Germany,
Torsten
-- 
http://www.dddbl.de - ein Datenbank-Layer, der die Arbeit mit 8 
verschiedenen Datenbanksystemen abstrahiert,
Queries von Applikationen trennt und automatisch die Query-Ergebnisse 
auswerten kann.



view thread (246+ messages)  latest in thread

Message-ID: <iige7c$ctl$1@news.eternal-september.org>
Permalink:  ../iige7c$ctl$1@news.eternal-september.org/
Also on:    postgresql.org/message-id/iige7c$ctl$1@news.eternal-september.org

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: foo@meisterderspiele.de
  Subject: Re: [HACKERS] Slow count(*) again...
  In-Reply-To: <iige7c$ctl$1@news.eternal-september.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox