Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id D70AF2E003F for ; Thu, 19 Jun 2008 06:05:57 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 14227-04 for ; Thu, 19 Jun 2008 06:05:49 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from ds528.dedicated.turbodns.co.uk (ds528.dedicated.turbodns.co.uk [81.21.72.118]) by developer.postgresql.org (Postfix) with ESMTP id E3D8E2E0037 for ; Thu, 19 Jun 2008 06:05:51 -0300 (ADT) Received: (qmail 3367 invoked from network); 19 Jun 2008 09:05:40 -0000 Received: from howardnews@selestial.com by ds528.dedicated.turbodns.co.uk by uid 1005 with qmail-scanner-1.22 ( Clear:RC:1(62.3.231.11):. Processed in 0.023156 secs); 19 Jun 2008 09:05:40 -0000 Received: from unknown (HELO ?10.202.6.101?) (selestial-howard.cole@62.3.231.11) by ds528.dedicated.turbodns.co.uk with SMTP; 19 Jun 2008 09:05:40 -0000 Message-ID: <485A20E9.7090500@selestial.com> Date: Thu, 19 Jun 2008 10:03:37 +0100 From: Howard Cole User-Agent: Thunderbird 2.0.0.14 (Windows/20080421) MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: Tsearch2 Initial Search Speed References: <4856A91F.1020001@selestial.com> <200806161124.57543@hal.medialogik.com> <485789C1.3000803@selestial.com> <485797D4.7010201@selestial.com> <48579EB1.8050403@selestial.com> <4857A739.5020800@selestial.com> <4858E60B.5070300@selestial.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200806/98 X-Sequence-Number: 30448 > Good idea. Note that Postgres is already doing this to some extent > with TOAST - read > http://www.postgresql.org/docs/8.3/interactive/storage-toast.html - > unfortunately, there doesn't seem to be an option to always move > particular columns out to TOAST. Your idea will produce an even > smaller table. However, are email_ids all that you want from the query? > > Matthew > As you point out - I will need more then the email_ids in the query, but if I remove just the content, to, cc fields then the size of the table should shrink dramatically. Just remains to be seen if the TOAST has already done that optimisation for me. Again. Thanks Matthew - I owe you a beer.