Re: [Dspace-tech] Postgres optimizations

2007-07-13 Thread Jayan Chirayath Kurian
PROTECTED] Sent: Tuesday, May 29, 2007 5:40 PM To: Jayan Chirayath Kurian Subject: Re: [Dspace-tech] Postgres optimizations Hi, Im using pg_dump to backup db: pg_dump dspace /dspace/dbbackup/dspace.db And rsync to backup dspace-directory and assetsore rsync -av --delete /usr/local/dspace-1.4

Re: [Dspace-tech] Postgres optimizations

2007-07-13 Thread Christophe Dupriez
on windows 2003. Thanks, Jayan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mika Stenberg Sent: Tuesday, May 29, 2007 4:13 PM To: 'dspace-tech@lists.sourceforge.net' Subject: [Dspace-tech] Postgres optimizations Im hoping to get some hints for postgres

[Dspace-tech] Postgres optimizations

2007-05-29 Thread Mika Stenberg
Im hoping to get some hints for postgres performance optimization. Our DSpace (1.4.1) has started to run really slow after the number of items exceeded 40 000 (mainly metadata, few full texts only). I tried increasing work_memory and max_fsm_pages in postgres.conf but with little help. Im also