Re: Timestamps and performances problems

From: "Dan Langille" <dan(at)langille(dot)org>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Timestamps and performances problems
Date: 2002-04-10 15:00:31
Message-ID: 20020410150121.91AAC3F30@bast.unixathome.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 10 Apr 2002 at 10:55, Dan Langille wrote:

> If there is an index on that field, casting to a timestamp may help the
> optimization. Therefore I suggested that it be tried.

And using "explain" will show the plan for that command. I recommend
using that too.
--
Dan Langille
The FreeBSD Diary - http://freebsddiary.org/ - practical examples

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Oliver Elphick 2002-04-10 15:04:54 Re: performance "tests"
Previous Message Dan Langille 2002-04-10 14:55:22 Re: Timestamps and performances problems