Re: [GENERAL] Recomended FS

2003-10-24 Thread Nick Burrett
ssing the data will be much slower than the time taken to fetch the data off disk. -- Nick Burrett Network Engineer, Designer Servers Ltd. http://www.dsvr.co.uk ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an approp

Re: [GENERAL] Recomended FS

2003-10-24 Thread Nick Burrett
Ben-Nes Michael wrote: - Original Message - From: "Nick Burrett" <[EMAIL PROTECTED]> Ben-Nes Michael wrote: But still the greatest question is what FS to put on ? I heard Reiesref can handle small files very quickly. Switching from ext3 to reiserfs for our name servers

Re: [GENERAL] ShmemAlloc errors

2003-10-17 Thread Nick Burrett
Tom Lane wrote: Nick Burrett <[EMAIL PROTECTED]> writes: Tom Lane wrote: We don't normally hear of people needing that --- is there anything unusual about the schema of this database? Not particularly. The database consists of around 3000 tables created using this: CREATE TABLE v

Re: [GENERAL] ShmemAlloc errors

2003-10-17 Thread Nick Burrett
Tom Lane wrote: Nick Burrett <[EMAIL PROTECTED]> writes: $ pg_dumpall >full.db pg_dump: WARNING: ShmemAlloc: out of memory pg_dump: Attempt to lock table "vs_dfa554862ac" failed. ERROR: LockAcquire: lock table 1 is out of memory pg_dumpall: pg_dump failed on bandwidth, exiti