Re: Strange query plan

On Thu, Aug 14, 2008 at 18:47, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> 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 <dave(dot)gauthier(at)intel(dot)com> 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?