On Thu, Aug 14, 2008 at 18:47, Scott Marlowe <scott.marlowe@xxxxxxxxx> 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.gauthier@xxxxxxxxx> 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?
