On Thu, Aug 14, 2008 at 18:47, Scott Marlowe <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general