Jodi Kanter wrote: > We are currently trying to determine if their is a performance > difference with postgres in using an IN statement in the where clause > vs. using a join between tables. > > Is there any published documentation or someone with personal experience > that can answer this question? We are adding sessioning to our web > interface and plan to append security info to the queries run from the > interface. > > I can add something like: ....... AND WHERE user IN (group1, group2) > > or I can do something like ....... SELECT data FROM tables WHERE > group_ID(of one table) = group_ID(of another table). > > Any thoughts? >
IN is known for being slow. See: http://www.us.postgresql.org/docs/faq-english.html#4.22 Joe ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
