Re: Ways to speed up dump&reload

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