pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Josh Berkus <josh@agliodbs.com>
To: psql-mail@freeuk.com
To: pgsql-performance@postgresql.org
Subject: Re: Large Text Search Help
Date: Tue, 14 Oct 2003 10:12:50 -0700
Message-ID: <200310141012.50848.josh@agliodbs.com> (raw)
In-Reply-To: <E1A7GXx-0007J5-PM@buckaroo.freeuk.net>
References: <E1A7GXx-0007J5-PM@buckaroo.freeuk.net>

Mat,

> 1. With tsearch2 I get very good query times up until I insert more
> records. For example with 100,000 records tsearch2 returns in around 6
> seconds, with 200,000 records tsearch2 returns in just under a minute.
> Is this due to the indices fitting entirely in memory with 100,000
> records?

Maybe, maybe not.  If you want a difinitive answer, post your EXPLAIN ANALYZE 
results with the original query.  

I assume that you have run VACUUM ANALYZE, first?  Don't bother to respond 
until you have.

> 2. As well as whole word matching i also need to be able to do
> substring matching. Is the FTI module the way to approach this?

Yes.

> 3. I have just begun to look into distibuted queries. Is there an
> existing solution for distibuting a postgresql database amongst
> multiple servers, so each has the same schema but only a subset of the
> total data?

No, it would be ad-hoc.  So far, Moore's law has prevented us from needing to 
devote serious effort to the above approach.

> Any other helpful comments or sugestions on how to improve query times
> using different hardware or software techniques would be appreciated.

Read the archives of this list.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco



view thread (2+ messages)

Message-ID: <200310141012.50848.josh@agliodbs.com>
Permalink:  ../200310141012.50848.josh@agliodbs.com/
Also on:    postgresql.org/message-id/200310141012.50848.josh@agliodbs.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: josh@agliodbs.com, psql-mail@freeuk.com
  Subject: Re: Large Text Search Help
  In-Reply-To: <200310141012.50848.josh@agliodbs.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