Re: [ADMIN] Database storage bloat

2004-04-08 Thread Douglas Trainor
Saying "we've set field sizes to their theoretical skinniness" makes me think that you may have the wrong data types. For example, you may have used CHAR and not VARCHAR. douglas Tony Reina wrote: I'm developing a database for scientific recordings. These recordings are traditionally saved

Re: [ADMIN] Yet another postgres scaling question (use on AMD Opteron)

2003-06-01 Thread Douglas Trainor
The width of the memory bus is likely to be larger with a 64-bit machine than a 32-bit machine, and that is a big factor for database applications. But peak memory bandwidth numbers published by manufacturers are not as useful as actual measured benchmarks for your type of problem. PostgreSQL is gr

[ADMIN] volunteer needed to fix

2002-12-23 Thread Douglas Trainor
Hey, a minor thing-to-do I noticed. From http://postgresql.org/sitess.html one can see " The latest source is available from the primary site via FTP or HTTP

Re: [ADMIN] Tape/DVD Backup Suggestions?

2002-07-19 Thread Douglas Trainor
<> I used DLT in industry and didn't like it due to excessive rewinding and a pain to deal with. I use a HP DDS drive purchased a year or so ago on one older Sun box, but forgot which DDS version. No problems ever, but I don't buy noname tapes. Just wait for a sale and buy a bunch... Won a fr