Postgres Pro
Downloads
Home   >   mailing lists

Re: Optimizing select count query which often takes over 10 seconds - Mailing list pgsql-general

From Jeff Janes
Subject Re: Optimizing select count query which often takes over 10 seconds
Date
Msg-id CAMkU=1wFRANBCttRtgxnqx2VgcANEzKZ+JzmcqY85ii6X-Uqiw@mail.gmail.com
Whole thread Raw
In response to Re: Optimizing select count query which often takes over 10 seconds  (Alexander Farber <alexander.farber@gmail.com>)
List pgsql-general
Tree view 
On Tue, Jan 29, 2013 at 11:41 PM, Alexander Farber
<alexander.farber@gmail.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

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Is there a way to add a detail message in a warning with pl/Python?
Next
From: AI Rumman
Date:
Subject: Query Parallelizing with dblink