Re: Optimizing select count query which often takes over 10 seconds

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: Alexander Farber <alexander(dot)farber(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Optimizing select count query which often takes over 10 seconds
Date: 2013-01-30 15:18:17
Message-ID: CAMkU=1wFRANBCttRtgxnqx2VgcANEzKZ+JzmcqY85ii6X-Uqiw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Jan 29, 2013 at 11:41 PM, Alexander Farber
<alexander(dot)farber(at)gmail(dot)com> wrote:
>
> When programming other languages, I never do
> if (x != 0) { x = 0; } but just set x = 0 straight away.

Most other languages are not transactional and durable. Databases are
different.

Cheers,

Jeff

In response to

Browse pgsql-general by date

  From Date Subject
Next Message AI Rumman 2013-01-30 15:27:07 Query Parallelizing with dblink
Previous Message Adrian Klaver 2013-01-30 14:55:54 Re: Is there a way to add a detail message in a warning with pl/Python?