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

RE: [GENERAL] Speed

From: "Jackson, DeJuan" <djackson(at)cpsgroup(dot)com>
To: justinlong(at)xc(dot)org, pgsql-general(at)postgreSQL(dot)org
Subject: RE: [GENERAL] Speed
Date: 1999-04-27 19:18:31
Message-ID: D05EF808F2DFD211AE4A00105AA1B5D20DCBA0@cpsmail (view raw or flat)
Thread:
Lists: pgsql-general
Use Indexes...
	-DEJ

> -----Original Message-----
> From:	Justin Long [SMTP:justinlong(at)strategicnetwork(dot)org]
> Sent:	Tuesday, April 27, 1999 11:31 AM
> To:	pgsql-general(at)postgreSQL(dot)org
> Subject:	[GENERAL] Speed
> 
> I find that it is actually faster to do a SELECT from a single record set,
> then fetch each individual row and do additional SELECTS to find
> additional
> pieces of data from other databases, rather than to a join between two or
> three databases
> 
> for example
> 
> 	SELECT ctryid, dirid, notes from initiative order by postedon limit
> 3;
> 	(for each individual record in the above select)...
> 		select name from country where country.ctryid=iRec.ctryid
> 		select name from directory where directory.dirid=iRec.dirid
> 
> (well this is kind of abstract code but you can follow the logic)
> 
> Has anyone else noticed that when you do multiple joins the speed of
> PGSQL6.5 goes down dramatically? This is the difference between 2 seconds
> for the above and 15 for a join... Is there some way to optimize?
> 
> 
> Never retreat. Never surrender. Never cut a deal with a dragon.
> _______________________________________________________________
> Justin Long                   CIO / Site Editor
> 616 Station Square Ct         Network for Strategic Missions
> Chesapeake, VA 23320          977 Centerville Trnpk CSB 317
> JustinLong(at)xc(dot)org             Va Beach, VA 23463
> Check out our site at:        http://www.strategicnetwork.org
> 

pgsql-general by date

Next:From: Jackson, DeJuanDate: 1999-04-27 19:21:06
Subject: RE: [GENERAL] INDEXes and UNIQUES and PRIMARY KEYS
Previous:From: Dustin SallingsDate: 1999-04-27 17:21:35
Subject: Re: [GENERAL] advice on buying sun hardware to run postgres

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