Hi Tom, thank you, I'll upgrade as soon as I can. Anyway I've already planned to do so for a while. I'll keep in mind your remarks concerning the DISTINCT clause too.
Bye and Best Regards, -- Csaba > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Tom Lane > Sent: 2004. január 6. 21:04 > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] (E-mail) > Subject: Re: [GENERAL] Query performance question on a large table > > > =?iso-8859-2?Q?Egy=FCd_Csaba?= <[EMAIL PROTECTED]> writes: > > here is a sample query: > > select mertido, fomeazon, ertektipus, mertertek from > t_me30 where fomeazon > > in (select distinct fomeazon from t_fome where lower(inuse) > = 'igen') and > > mertido like '2003-12-17%' and ertektipus in ('+MW') order > by mertido, > > fomeazon, ertektipus; > > > Ohh, I nearly forgot the config: Linux 7.1; Postgres 7.3.2; > > The first thing you ought to do is move to PG 7.4. "foo IN > (SELECT ...)" > generally works a lot better under 7.4 than prior releases. > I'd suggest > dropping the "DISTINCT" when using 7.4, too. > > regards, tom lane > > ---------------------------(end of > broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to > [EMAIL PROTECTED] > > > > -- Incoming mail is certified Virus Free. > Checked by AVG Anti-Virus (http://www.grisoft.com). > Version: 7.0.209 / Virus Database: 261 - Release Date: 2004. 01. 02. > ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
