Re: PostgreSQL performance in simple queries

From: Joseph Shraibman <jks(at)selectacast(dot)net>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: PostgreSQL performance in simple queries
Date: 2004-05-20 04:49:43
Message-ID: c8hdd7$ffa$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance

Neil Conway wrote:

> PostgreSQL (< 7.5) won't consider using an indexscan when the predicate
> involves an integer literal and the column datatype is int2 or int8.

Is this fixed for 7.5? It isn't checked off on the TODO list at
http://developer.postgresql.org/todo.php

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2004-05-20 05:07:14 Re: add server include files to default installation?
Previous Message Bruce Momjian 2004-05-20 03:50:47 Re: [HACKERS] Configuration patch

Browse pgsql-performance by date

  From Date Subject
Next Message Matthew T. O'Connor 2004-05-20 05:10:14 Re: Wierd context-switching issue on Xeon
Previous Message Christopher Browne 2004-05-20 04:48:48 Re: Wierd context-switching issue on Xeon