Re: [PERFORM] PostgreSQL publishes first real benchmark

Hi, I think this result will be useful for performance discussions of postgresql against other databases. http://www.spec.org/jAppServer2004/results/res2007q3/ More on Josh Berkus's blog: http://blogs.ittoolbox.com/database/soup/archives/postgresql- publishes-first-real-benchmark-17470

Re: [PERFORM] how small to split a table?

down too much, so that a different number of partitions could be better. The same applies for queries as well (here perhaps in the other direction). -- Heiko W.Rupp [EMAIL PROTECTED], http://www.dpunkt.de/buch/3-89864-429-4.html ---(end of broadcast

Re: [PERFORM] Auto Vacuum Problem

Hi, How do I make the physical size of the DB smaller without doing a full vacuum. This might turn out to be counterproductive, as subsequent inserts and updates will increase the size of the physical database again, which might be expensive depending on the underlying OS. -- Heiko

Re: [PERFORM] slow result

" of postgres :-/ So enhancing the performance is currently only possible by having faster disk drives. -- Heiko W.Rupp [EMAIL PROTECTED], http://www.dpunkt.de/buch/ 3-89864-429-4.html ---(end of broadcast)--- TIP 9: In vers