Accidentally sent to nha only --- On Wed, 7/8/09, John Cheng <jlcheng@xxxxxxxxx> wrote: > From: John Cheng <jlcheng@xxxxxxxxx> > Subject: Re: Problem search on text arrays, using the overlaps (&&) operator > To: "nha" <lyondif02@xxxxxxx> > Date: Wednesday, July 8, 2009, 4:24 PM > Hi nha, > > I will try out your suggestion about a materialized view. I > had never even thought about trying it. > > As luck would have it, I had to try out these tests on a > different database today, which resulted in a different > query plan that executed both forms in the same time. > This different plan used a merge join instead of a hash > join. I will research this are more to see if I learn > anything new. > > You also pointed out that my queries (reports) are simply > reporting off of a lot of data. Perhaps I need to see if the > windowing functions in 8.4 can help improve things, or > perhaps try to partition the data. Unfortunately, these kind > of changes will be bigger than I had expected. > > > > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
