Jason A. Kates wrote: > Alan, > My file table currently has 434026569 (It grows to over 600Million > rows)., it is running on a server with 16GB of ram and a decent drive > array.
Add more ram. I'm using 48Gb here and was considering adding more before we moved to Postgres. Current File table size is stable around 280 million rows and Postgres is sitting at around 21Gb. MySQL was sitting at more than 32Gb for acceptable performance (make sure you use hugetbls too). ------------------------------------------------------------------------------ What You Don't Know About Data Connectivity CAN Hurt You This paper provides an overview of data connectivity, details its effect on application quality, and explores various alternative solutions. http://p.sf.net/sfu/progress-d2d _______________________________________________ Bacula-devel mailing list Bacula-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-devel
