Re: Strange query plan

On Thu, Aug 14, 2008 at 18:47, Scott Marlowe  wrote:
> What does "explain analyze select.... (your query here)" have to say?
>
Expalin analyze says it makes sequential scan on a table table1.

On Thu, Aug 14, 2008 at 18:48, Gauthier, Dave  wrote:
> Try this...
>
> Set default_statistics_target to be 1000 in postgres.conf then reboot
> your pg server.  "Analyze" the table.  Try the query again.
>
> If that fails, drop the index on (field1, field3) and recreate the other
> way around (field3, field1).  Analyze again and try the query.
>
> -dave
I've altered query and swapped field1 and field3 there, in where statement.
Seems that order doesn't matter.

--
A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?
A: Top-posting.
Q: What is the most annoying thing in e-mail?