Hello Oleg,
Yes, thanks - I have installed this patch as soon as it became available. Concerning my largest database, I haven't yet
migratedthat to tsearch2 - it's still tsearch1-based, so I intend to drop ts1 before the last dump, reload the database
withPostgreSQL 8.0.1 and deploy tsearch2 after that. I was thinking more in terms of what would be the optimum settings
forthings like workmem during reload and creation of the indices - as there's not much else going on at this point of
time,it might be worthwhile to use some settings which allocate all available resources to just this task.
Kind regards
Markus
-----Original Message-----
From: Oleg Bartunov [mailto:oleg@sai.msu.su]
Sent: Mon 2/21/2005 11:15
To: Markus Wollny
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Ways to speed up dump&reload
Markus,
have you read updated http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/tsearch-V2-intro.html
about regprocedure_7.4.patch.gz and regprocedure_update.sql ?
Oleg