From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | "Schmidt, Peter" <peter(dot)schmidt(at)prismedia(dot)com> |
Cc: | "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "'Michael Ansley'" <Michael(dot)Ansley(at)intec-telecom-systems(dot)com>, "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: v7.1b4 bad performance |
Date: | 2001-02-16 18:58:30 |
Message-ID: | 200102161858.NAA23924@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
> > "Schmidt, Peter" <peter(dot)schmidt(at)prismedia(dot)com> writes:
> > > However, what I'm interested in is the comparison between
> > 7.0x and 7.1x.
> > > Shouldn't the 7.1b4 database be faster? Have you (or anyone
> > else) done this
> > > comparison?
> >
> > 7.1 is considerably faster if you compare performance without -F.
> > If you are comparing performance with -F, I'm not sure exactly how it
> > stacks up.
> >
> > regards, tom lane
> >
>
> Here are some of the results of my tests which are very consistent. I
> dropped and recreated postgres db before each test so the only user tables
> were the pgbench tables.
>
> 7.1b4(no -F) 49 tps
> 7.03 (no -F) 64 tps
> 7.03 (with -F) 121 tps
>
> The test machine is a Dell Dimension 800mz w/128 RAM and it is dedicated to
> this testing. Pgbench is run on the same machine. Any ideas why my results
> differ? I will continue testing and appreciate all comments.
> Peter
This is very strange. Is there any specific query that is causing the
problem? Does EXPLAIN show the same output on both versions?
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2001-02-16 19:23:51 | Re: variable question with postgresql |
Previous Message | Jreniz | 2001-02-16 17:11:35 | PostgreSQL Benchmark! |