Postgres Pro
Downloads
Home   >   mailing lists

Re: GROUP BY Vs. Sub SELECT - Mailing list pgsql-performance

From Jim C. Nasby
Subject Re: GROUP BY Vs. Sub SELECT
Date
Msg-id 20060424210017.GM48010@pervasive.com
Whole thread Raw
In response to Re: GROUP BY Vs. Sub SELECT  (Richard Broersma Jr <rabroersma@yahoo.com>)
List pgsql-performance
Tree view 
On Mon, Apr 24, 2006 at 12:07:39PM -0700, Richard Broersma Jr wrote:
>
> > I'd like to get more info on EXPLAIN ANALYZE output... where can I read more
> > about it?
>
> I believe this link has what you are looking for:
> http://www.postgresql.org/docs/8.1/interactive/performance-tips.html

http://www.pervasive-postgres.com/lp/newsletters/2006/Insights_postgres_Apr.asp#4
might also be worth your time to read...
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

pgsql-performance by date:

Previous
From: "Mikael Carneholm"
Date:
Subject: Re: Hardware: HP StorageWorks MSA 1500
Next
From: Tom Lane
Date:
Subject: Re: Index on function less well cached than "regular" index ?