On Tue, Mar 23, 2004 at 08:32:30 -0300,
Ricardo Vaz Mannrich <rvm_l1(at)silcom(dot)com(dot)br> wrote:
> Both indexed...
> But... When I try EXPLAIN SELECT * FROM detail WHERE master_id = XXXXXX;
> PostgreSQL uses seq scan (why?)
This has been discussed many times previously and if you want to understand
why things are this way search the archives.
Things will work better in 7.5.
For the time being quoting XXXXX will solve your problem as it will
allow the constant to get the same type as master_id.
In response to
pgsql-admin by date
|Next:||From: Josh Berkus||Date: 2004-03-23 16:15:39|
|Subject: Re: [PERFORM] Benchmarking postgres on Solaris/Linux|
|Previous:||From: Bruno Wolff III||Date: 2004-03-23 15:50:41|
|Subject: Re: upgrading to 7.4.2|