Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 48CBB475AA1 for ; Thu, 3 Oct 2002 16:57:44 -0400 (EDT) Received: from lakemtao02.cox.net (lakemtao02.cox.net [68.1.17.243]) by postgresql.org (Postfix) with ESMTP id A063C475A09 for ; Thu, 3 Oct 2002 16:57:43 -0400 (EDT) Received: from localhost.localdomain ([68.11.66.83]) by lakemtao02.cox.net (InterMail vM.5.01.04.05 201-253-122-122-105-20011231) with ESMTP id <20021003205743.MIEH12192.lakemtao02.cox.net@localhost.localdomain> for ; Thu, 3 Oct 2002 16:57:43 -0400 Subject: Re: [HACKERS] Large databases, performance From: Ron Johnson To: pgsql-performance@postgresql.org In-Reply-To: <3D9C7579.2010206@cybertec.at> References: <3D9C8712.9513.9C6521D@localhost> <3D9CBAD7.23509.A908C61@localhost> <3D9C7579.2010206@cybertec.at> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Mailer: Ximian Evolution 1.0.8 Date: 03 Oct 2002 15:55:35 -0500 Message-Id: <1033678535.28946.158.camel@haggis> Mime-Version: 1.0 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/15 X-Sequence-Number: 32 On Thu, 2002-10-03 at 11:51, Hans-J=FCrgen Sch=F6nig wrote: > Shridhar Daithankar wrote: >=20 > >On 3 Oct 2002 at 11:57, Robert Treat wrote: [snip] > PostgreSQL allows you to improve execution plans by giving the planner a= =20 > hint. > In addition to that: if you need REAL performance and if you are running= =20 > similar queries consider using SPI. What is SPI? --=20 +------------------------------------------------------------+ | Ron Johnson, Jr. mailto:ron.l.johnson@cox.net | | Jefferson, LA USA http://members.cox.net/ron.l.johnson | | | | "What other evidence do you have that they are terrorists, | | other than that they trained in these camps?" | | 17-Sep-2002 Katie Couric to an FBI agent regarding the 5 | | men arrested near Buffalo NY | +------------------------------------------------------------+