Tobias Brox <tobias(at)nordicbet(dot)com> writes:
>> time (datetime) > '2005-06-21 10:36:22+02'
>> time (timestamp) > 'some timestamp pointing to yesterday'
> If I have understood it correctly, the planner will recognize the timestamp
> and compare it with the statistics in the first example but not in the
> second, and thus it will be more likely to use index scan on the first one
> and seqscan on the second.
That statement is true for releases before 8.0. Kjell has not at any
point told us what PG version he is running, unless I missed it...
regards, tom lane
In response to
pgsql-performance by date
|Next:||From: Paul Ramsey||Date: 2005-06-22 14:20:13|
|Subject: Re: Querying 19million records very slowly|
|Previous:||From: Oleg Bartunov||Date: 2005-06-22 10:53:20|
|Subject: Re: Forums & tsearch2 - best practices reg. concurrency|