Skip site navigation (1) Skip section navigation (2)

Re: Query performance question

From: Lukas Ertl <l(dot)ertl(at)univie(dot)ac(dot)at>
To: Vijay Deval <deval(at)giaspn01(dot)vsnl(dot)net(dot)in>
Cc: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Query performance question
Date: 2001-03-29 09:44:41
Message-ID: Pine.BSF.4.33.0103291141270.17729-100000@pcle2.cc.univie.ac.at (view raw or flat)
Thread:
Lists: pgsql-novice
On Thu, 29 Mar 2001, Vijay Deval wrote:

> URL is a very large field.  If an extra field is created which gives a
> neumeric id to the url, run the query on the number, and then get the desired
> output

I have to admit, that I quite don't understand what you want me to do
here... I already have that numeric id:

> > httplog=# \d referrer
> >           Table "referrer"
> >  Attribute |     Type     | Modifier
> > -----------+--------------+----------
> >  id        | integer      |
> >  url       | varchar(300) |
> > Index: referrer_pkey

If I say:

SELECT count(*), referrer.id FROM hits, referrer WHERE referrer.id =
referrer_id GROUP BY referrer.id ORDER BY count DESC LIMIT 10;

it is really fast and I get the IDs of the referrer-urls but how would I
get the URLs then?

regards,
le

-- 
Lukas Ertl                          eMail: l(dot)ertl(at)univie(dot)ac(dot)at
WWW-Redaktion                       Tel.:  (+43 1) 4277-14073
Zentraler Informatikdienst (ZID)    Fax.:  (+43 1) 4277-9140
der Universit├Ąt Wien


In response to

Responses

pgsql-novice by date

Next:From: D. DucciniDate: 2001-03-29 10:51:08
Subject: Re: Query performance question
Previous:From: Vijay DevalDate: 2001-03-29 09:42:55
Subject: Re: Query performance question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group