Skip site navigation (1) Skip section navigation (2)

Building full-text index

From: "Sean Davis" <sdavis2(at)mail(dot)nih(dot)gov>
To: pgsql-novice(at)postgresql(dot)org
Subject: Building full-text index
Date: 2007-11-15 12:41:52
Message-ID: 264855a00711150441x70e1264cq3fa7c1be0acf418f@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
I am trying to build a full-text index (gin(to_tsvector('english',
title || abstract))) on about 18 million abstracts and titles from
medical literature.  However, I keep getting out-of-memory errors.  (I
am on a 32Gb linux system with maintenance_work_mem set to 20Gb and
shared buffers at 4Gb; postgres 8.3beta).  Does creation of a
full-text index require that the entire index fit into memory?  I know
this is probably a naive question, but I guess I assumed that the file
system could be used.  Any hints on how to build such an index?

Thanks,
Sean

Responses

pgsql-novice by date

Next:From: LukasDate: 2007-11-15 14:04:16
Subject: 2 problems
Previous:From: Sean DavisDate: 2007-11-15 12:35:24
Subject: XML schema

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group