[PERFORM] which ext3 fs type should I use for postgresql

Hi all, using mkfs.ext3 I can use "-T" to tune the filesytem mkfs.ext3 -T fs_type ... fs_type are in /etc/mke2fs.conf (on debian) is there a recommended setting for this parameter ??? thanks -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your

Re: [PERFORM] Index files

Le vendredi 14 septembre 2007 à 11:09 +0800, Ow Mun Heng a écrit : > On Fri, 2007-09-14 at 08:33 +0530, Harsh Azad wrote: > > ah.. thanks. Didn't realize table spaces can be mentioned while > > creating a index. BTW, are soft links ok to use for pg_clog / > > pg_xlog . I moved the existing director

Re: [PERFORM] PostgreSQL publishes first real benchmark

Le mercredi 11 juillet 2007 à 13:37 -0300, André Gomes Lamas Otero a écrit : > I don't this so, because DB2 is running on a Sun Sparc T1 processor > (http://www.sun.com/processors/UltraSPARC-T1/) that's implements much > more features, like thread level parelelism, than AMD Opteron. > > the DB2

Re: [PERFORM] PostgreSQL publishes first real benchmark

am I wrong or DB2 9.1 is faster on less powerfull hardware ? Le lundi 09 juillet 2007 à 11:57 -0400, Jignesh K. Shah a écrit : > Hello all, > > I think this result will be useful for performance discussions of > postgresql against other databases. > > http://www.spec.org/jAppServer2004/results/