Hello Oleg, Yes, thanks - I have installed this patch as soon as it became available. Concerning my largest database, I haven't yet migrated that to tsearch2 - it's still tsearch1-based, so I intend to drop ts1 before the last dump, reload the database with PostgreSQL 8.0.1 and deploy tsearch2 after that. I was thinking more in terms of what would be the optimum settings for things 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@xxxxxxxxxx] Sent: Mon 2/21/2005 11:15 To: Markus Wollny Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: 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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx
