pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
8.0 vs. 7.4 benchmarks
6+ messages / 3 participants
[nested] [flat]

* 8.0 vs. 7.4 benchmarks
@ 2004-12-06 09:28 Postgres Learner <postgres.learner@gmail.com>
  2004-12-07 09:17 ` Fwd: 8.0 vs. 7.4 benchmarks Postgres Learner <postgres.learner@gmail.com>
  0 siblings, 1 reply; 6+ messages in thread

From: Postgres Learner @ 2004-12-06 09:28 UTC (permalink / raw)
  To: pgsql-performance

Hi all!
Has anyone done any performance benchmarking of postgresql 7.4 vs 8.0? 
Are there any scenarios where 8.0 can be expected to be faster? I
would love to get my hands on any numbers that someone might have.
Also does anyone know how long it will take for a stable release of
8.0 to come? Given the loads of additional features in 8.0, I can't
wait to use it in production. :-)

thanks a lot everyone!!!
ps



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Fwd: 8.0 vs. 7.4 benchmarks
  2004-12-06 09:28 8.0 vs. 7.4 benchmarks Postgres Learner <postgres.learner@gmail.com>
@ 2004-12-07 09:17 ` Postgres Learner <postgres.learner@gmail.com>
  2004-12-07 14:52   ` Re: Fwd: 8.0 vs. 7.4 benchmarks Bruno Wolff III <bruno@wolff.to>
  0 siblings, 1 reply; 6+ messages in thread

From: Postgres Learner @ 2004-12-07 09:17 UTC (permalink / raw)
  To: pgsql-general@postgresql.org

Hi all!
I posted this on pgsql-performance but got no reply, so here it is:
thanks!
ps


---------- Forwarded message ----------
From: Postgres Learner <postgres.learner@gmail.com>
Date: Mon, 6 Dec 2004 14:58:46 +0530
Subject: 8.0 vs. 7.4 benchmarks
To: pgsql-performance@postgresql.org


Hi all!
Has anyone done any performance benchmarking of postgresql 7.4 vs 8.0?
Are there any scenarios where 8.0 can be expected to be faster? 
I would love to get my hands on any numbers that someone might have.

Also does anyone know how long it will take for a stable release of
8.0 to come (any estimates would be good) ? 
Given the loads of additional features in 8.0, I can't
wait to use it in production. :-)

thanks a lot everyone!!!
ps



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Fwd: 8.0 vs. 7.4 benchmarks
  2004-12-06 09:28 8.0 vs. 7.4 benchmarks Postgres Learner <postgres.learner@gmail.com>
  2004-12-07 09:17 ` Fwd: 8.0 vs. 7.4 benchmarks Postgres Learner <postgres.learner@gmail.com>
@ 2004-12-07 14:52   ` Bruno Wolff III <bruno@wolff.to>
  2004-12-07 16:43     ` Re: Fwd: 8.0 vs. 7.4 benchmarks Joshua D. Drake <jd@commandprompt.com>
  0 siblings, 1 reply; 6+ messages in thread

From: Bruno Wolff III @ 2004-12-07 14:52 UTC (permalink / raw)
  To: Postgres Learner <postgres.learner@gmail.com>; +Cc: pgsql-general@postgresql.org

On Tue, Dec 07, 2004 at 14:47:58 +0530,
  Postgres Learner <postgres.learner@gmail.com> wrote:
> 
> Has anyone done any performance benchmarking of postgresql 7.4 vs 8.0?
> Are there any scenarios where 8.0 can be expected to be faster? 

Have you read the release notes?

> I would love to get my hands on any numbers that someone might have.
> 
> Also does anyone know how long it will take for a stable release of
> 8.0 to come (any estimates would be good) ? 

The last target date I saw mentioned was 2004-12-15. If a second release
candidate is needed, I don't know if that date will be met.



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Fwd: 8.0 vs. 7.4 benchmarks
  2004-12-06 09:28 8.0 vs. 7.4 benchmarks Postgres Learner <postgres.learner@gmail.com>
  2004-12-07 09:17 ` Fwd: 8.0 vs. 7.4 benchmarks Postgres Learner <postgres.learner@gmail.com>
  2004-12-07 14:52   ` Re: Fwd: 8.0 vs. 7.4 benchmarks Bruno Wolff III <bruno@wolff.to>
@ 2004-12-07 16:43     ` Joshua D. Drake <jd@commandprompt.com>
  2004-12-07 17:43       ` Re: Fwd: 8.0 vs. 7.4 benchmarks Bruno Wolff III <bruno@wolff.to>
  0 siblings, 1 reply; 6+ messages in thread

From: Joshua D. Drake @ 2004-12-07 16:43 UTC (permalink / raw)
  To: Bruno Wolff III <bruno@wolff.to>; +Cc: Postgres Learner <postgres.learner@gmail.com>; pgsql-general@postgresql.org


>>I would love to get my hands on any numbers that someone might have.
>>
>>Also does anyone know how long it will take for a stable release of
>>8.0 to come (any estimates would be good) ? 
>>    
>>
>
>The last target date I saw mentioned was 2004-12-15. If a second release
>candidate is needed, I don't know if that date will be met.
>  
>
It should also be noted that putting any .0 release into
production right away is typically a bad idea. This is not
a reflection on PostgreSQL but a reflection on software in general.

IMHO 8.0 means, hey all you external developers -- time to test
with your applications and report bugs.

8.1 means, alright we got some wide reports -- fixed a few mistakes
and now were ready.

Sincerely,

Joshua D. Drake



>---------------------------(end of broadcast)---------------------------
>TIP 7: don't forget to increase your free space map settings
>  
>


-- 
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL

Attachments:

jd.vcf (text/x-vcard, 283B) download begin:vcard fn:Joshua Drake n:Drake;Joshua org:Command Prompt, Inc. adr:;;PO Box 215 ;Cascade Locks;OR;97014;US email;internet:jd@commandprompt.com title:Consultant tel;work:503-667-4564 tel;fax:503-210-0334 x-mozilla-html:FALSE url:http://www.commandprompt.com version:2.1 end:vcard
^ permalink raw reply [nested|flat] 6+ messages in thread

* Re: Fwd: 8.0 vs. 7.4 benchmarks
  2004-12-06 09:28 8.0 vs. 7.4 benchmarks Postgres Learner <postgres.learner@gmail.com>
  2004-12-07 09:17 ` Fwd: 8.0 vs. 7.4 benchmarks Postgres Learner <postgres.learner@gmail.com>
  2004-12-07 14:52   ` Re: Fwd: 8.0 vs. 7.4 benchmarks Bruno Wolff III <bruno@wolff.to>
  2004-12-07 16:43     ` Re: Fwd: 8.0 vs. 7.4 benchmarks Joshua D. Drake <jd@commandprompt.com>
@ 2004-12-07 17:43       ` Bruno Wolff III <bruno@wolff.to>
  2004-12-07 18:35         ` Re: Fwd: 8.0 vs. 7.4 benchmarks Joshua D. Drake <jd@commandprompt.com>
  0 siblings, 1 reply; 6+ messages in thread

From: Bruno Wolff III @ 2004-12-07 17:43 UTC (permalink / raw)
  To: Joshua D. Drake <jd@commandprompt.com>; +Cc: Postgres Learner <postgres.learner@gmail.com>; pgsql-general@postgresql.org

On Tue, Dec 07, 2004 at 08:43:03 -0800,
  "Joshua D. Drake" <jd@commandprompt.com> wrote:
> 
> IMHO 8.0 means, hey all you external developers -- time to test
> with your applications and report bugs.
> 
> 8.1 means, alright we got some wide reports -- fixed a few mistakes
> and now were ready.

That should probably be 8.0.1. That is what the next release will be named.
Typically there is a *.*.1 release not too long after the *.* release. My memory
is that this has been around 2-3 months for the last serveral *.*
releases.

8.1 will be an important release as it should include integrated autovacuum,
some tools for handling PITR recoveries and other changes related to lessons
learned from the several major feature additions in 8.0. I will be surprised
if 8.1 is released before next fall.

We did have a thread about *.* releases about a month ago and the data seemed
to suggest that the *.* releases tended to be better than the latest version
of the previous *.* release. (I think the main problem is that some fixes
were not being back ported because they are too extensive to be safely
back ported.) So with 8.0, it might be a good idea to hold off for a little
bit to see if anything major was missed during beta, but that it might be
desirable to upgrade to 8.0 without waiting for 8.0.1 if there aren't any
major problems reported within a few weeks of the release.



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Fwd: 8.0 vs. 7.4 benchmarks
  2004-12-06 09:28 8.0 vs. 7.4 benchmarks Postgres Learner <postgres.learner@gmail.com>
  2004-12-07 09:17 ` Fwd: 8.0 vs. 7.4 benchmarks Postgres Learner <postgres.learner@gmail.com>
  2004-12-07 14:52   ` Re: Fwd: 8.0 vs. 7.4 benchmarks Bruno Wolff III <bruno@wolff.to>
  2004-12-07 16:43     ` Re: Fwd: 8.0 vs. 7.4 benchmarks Joshua D. Drake <jd@commandprompt.com>
  2004-12-07 17:43       ` Re: Fwd: 8.0 vs. 7.4 benchmarks Bruno Wolff III <bruno@wolff.to>
@ 2004-12-07 18:35         ` Joshua D. Drake <jd@commandprompt.com>
  0 siblings, 0 replies; 6+ messages in thread

From: Joshua D. Drake @ 2004-12-07 18:35 UTC (permalink / raw)
  To: Bruno Wolff III <bruno@wolff.to>; +Cc: Postgres Learner <postgres.learner@gmail.com>; pgsql-general@postgresql.org

Bruno Wolff III wrote:
> On Tue, Dec 07, 2004 at 08:43:03 -0800,
>   "Joshua D. Drake" <jd@commandprompt.com> wrote:
> 
>>IMHO 8.0 means, hey all you external developers -- time to test
>>with your applications and report bugs.
>>
>>8.1 means, alright we got some wide reports -- fixed a few mistakes
>>and now were ready.
> 
> 
> That should probably be 8.0.1. That is what the next release will be named.

Your right that was my bad.

Sincerely,

Joshua D. Drake


> We did have a thread about *.* releases about a month ago and the data seemed
> to suggest that the *.* releases tended to be better than the latest version
> of the previous *.* release. (I think the main problem is that some fixes
> were not being back ported because they are too extensive to be safely
> back ported.) So with 8.0, it might be a good idea to hold off for a little
> bit to see if anything major was missed during beta, but that it might be
> desirable to upgrade to 8.0 without waiting for 8.0.1 if there aren't any
> major problems reported within a few weeks of the release.



-- 
Command Prompt, Inc., home of PostgreSQL Replication, and plPHP.
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL

Attachments:

jd.vcf (text/x-vcard, 638B) download begin:vcard fn:Joshua D. Drake n:Drake;Joshua D. org:Command Prompt, Inc. adr:;;PO Box 215;Cascade Locks;Oregon;97014;USA email;internet:jd@commandprompt.com title:Consultant tel;work:503-667-4564 tel;fax:503-210-0334 note:Command Prompt, Inc. is the largest and oldest US based commercial PostgreSQL support provider. We provide the only commercially viable integrated PostgreSQL replication solution, but also custom programming, and support. We authored the book Practical PostgreSQL, the procedural language plPHP, and adding trigger capability to plPerl. x-mozilla-html:FALSE url:http://www.commandprompt.com/ version:2.1 end:vcard
^ permalink raw reply [nested|flat] 6+ messages in thread


end of thread, other threads:[~2004-12-07 18:35 UTC | newest]

Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-12-06 09:28 8.0 vs. 7.4 benchmarks Postgres Learner <postgres.learner@gmail.com>
2004-12-07 09:17 ` Postgres Learner <postgres.learner@gmail.com>
2004-12-07 14:52   ` Bruno Wolff III <bruno@wolff.to>
2004-12-07 16:43     ` Joshua D. Drake <jd@commandprompt.com>
2004-12-07 17:43       ` Bruno Wolff III <bruno@wolff.to>
2004-12-07 18:35         ` Joshua D. Drake <jd@commandprompt.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox