Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 98D55476265 for ; Thu, 3 Oct 2002 17:02:36 -0400 (EDT) Received: from beamish.nsd.ca (unknown [205.150.156.194]) by postgresql.org (Postfix) with ESMTP id E0E64476264 for ; Thu, 3 Oct 2002 17:02:35 -0400 (EDT) Received: (from smap@localhost) by beamish.nsd.ca (8.9.3/8.9.3) id RAA18011 for ; Thu, 3 Oct 2002 17:02:37 -0400 X-Authentication-Warning: beamish.nsd.ca: smap set sender to using -f Received: from reddog.nsd.ca(192.168.101.30) by beamish.nsd.ca via smap (V2.1/2.1+anti-relay+anti-spam) id xma018009; Thu, 3 Oct 02 17:02:31 -0400 Received: from nsd.ca (jllachan-linux.nsd.ca [192.168.101.148]) by reddog.nsd.ca (8.8.7/8.8.7) with ESMTP id RAA22887 for ; Thu, 3 Oct 2002 17:02:13 -0400 Message-ID: <3D9CB2A2.47A4F6F1@nsd.ca> Date: Thu, 03 Oct 2002 17:12:02 -0400 From: Jean-Luc Lachance X-Mailer: Mozilla 4.77 [en] (X11; U; Linux 2.4.9-31 i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: use [PERF] instead of References: <3D9C8712.9513.9C6521D@localhost> <3D9CBAD7.23509.A908C61@localhost> <3D9C7579.2010206@cybertec.at> <1033678535.28946.158.camel@haggis> Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-MIME-Autoconverted: from 8bit to quoted-printable by reddog.nsd.ca id RAA22887 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/16 X-Sequence-Number: 33 May I suggest that instead of [pgsql-performance] that [PERF] be used to save some of the subject line. Ron Johnson wrote: >=20 > On Thu, 2002-10-03 at 11:51, Hans-J=FCrgen Sch=F6nig wrote: > > Shridhar Daithankar wrote: > > > > >On 3 Oct 2002 at 11:57, Robert Treat wrote: > [snip] > > PostgreSQL allows you to improve execution plans by giving the planner a > > hint. > > In addition to that: if you need REAL performance and if you are running > > similar queries consider using SPI. >=20 > 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 | > +------------------------------------------------------------+ >=20 > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)