pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Howard Cole <howardnews@selestial.com>
To: pgsql-performance@postgresql.org
Subject: Re: Tsearch2 Initial Search Speed
Date: Thu, 19 Jun 2008 10:03:37 +0100
Message-ID: <485A20E9.7090500@selestial.com> (raw)
In-Reply-To: <Pine.LNX.4.64.0806181321020.5056@aragorn.flymine.org>
References: <4856A91F.1020001@selestial.com>
	<200806161124.57543@hal.medialogik.com>
	<485789C1.3000803@selestial.com>
	<485797D4.7010201@selestial.com>
	<Pine.LNX.4.64.0806171202130.3987@aragorn.flymine.org>
	<48579EB1.8050403@selestial.com>
	<Pine.LNX.4.64.0806171228480.3987@aragorn.flymine.org>
	<4857A739.5020800@selestial.com>
	<Pine.LNX.4.64.0806171407250.3987@aragorn.flymine.org>
	<4858E60B.5070300@selestial.com>
	<Pine.LNX.4.64.0806181321020.5056@aragorn.flymine.org>


> 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.



view thread (18+ messages)  latest in thread

Message-ID: <485A20E9.7090500@selestial.com>
Permalink:  ../485A20E9.7090500@selestial.com/
Also on:    postgresql.org/message-id/485A20E9.7090500@selestial.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: howardnews@selestial.com
  Subject: Re: Tsearch2 Initial Search Speed
  In-Reply-To: <485A20E9.7090500@selestial.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox