pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Which plattform do you recommend I run PostgreSQL for best performance?
7+ messages / 6 participants
[nested] [flat]

* Which plattform do you recommend I run PostgreSQL for best performance?
@ 2004-10-12 15:45 nd02tsk@student.hig.se
  2004-10-12 15:47 ` Re: Which plattform do you recommend I run PostgreSQL for Matt Clark <matt@ymogen.net>
  2004-10-12 16:27 ` Re: Which plattform do you recommend I run PostgreSQL for Francisco Reyes <lists@natserv.com>
  2004-10-12 20:02 ` Re: Which plattform do you recommend I run PostgreSQL for best performance? Christopher Browne <cbbrowne@acm.org>
  2004-10-12 20:32 ` Re: Which plattform do you recommend I run PostgreSQL for best performance? Josh Berkus <josh@agliodbs.com>
  2004-10-13 08:46 ` Re: Which plattform do you recommend I run PostgreSQL for best CoL <col@mportal.hu>
  0 siblings, 5 replies; 7+ messages in thread

From: nd02tsk@student.hig.se @ 2004-10-12 15:45 UTC (permalink / raw)
  To: pgsql-performance

Hello

I am doing a comparison between MySQL and PostgreSQL.

In the MySQL manual it says that MySQL performs best with Linux 2.4 with
ReiserFS on x86. Can anyone official, or in the know, give similar
information regarding PostgreSQL?

Also, any links to benchmarking tests available on the internet between
MySQL and PostgreSQL would be appreciated.

Thank you!

Tim





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

* Re: Which plattform do you recommend I run PostgreSQL for
  2004-10-12 15:45 Which plattform do you recommend I run PostgreSQL for best performance? nd02tsk@student.hig.se
@ 2004-10-12 15:47 ` Matt Clark <matt@ymogen.net>
  4 siblings, 0 replies; 7+ messages in thread

From: Matt Clark @ 2004-10-12 15:47 UTC (permalink / raw)
  To: nd02tsk@student.hig.se; +Cc: pgsql-performance


>In the MySQL manual it says that MySQL performs best with Linux 2.4 with
>ReiserFS on x86. Can anyone official, or in the know, give similar
>information regarding PostgreSQL?
>  
>
I'm neither official, nor in the know, but I do have a spare moment! I 
can tell you that any *NIX variant on any modern hardware platform will 
give you good performance, except for Cygwin/x86.  Any differences 
between OSes on the same hardware are completely swamped by far more 
direct concerns like IO systems, database design, OS tuning etc.  Pick 
the OS you're most familiar with is usually a good recommendation (and 
not just for Postgres).



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

* Re: Which plattform do you recommend I run PostgreSQL for
  2004-10-12 15:45 Which plattform do you recommend I run PostgreSQL for best performance? nd02tsk@student.hig.se
@ 2004-10-12 16:27 ` Francisco Reyes <lists@natserv.com>
  4 siblings, 0 replies; 7+ messages in thread

From: Francisco Reyes @ 2004-10-12 16:27 UTC (permalink / raw)
  To: nd02tsk@student.hig.se; +Cc: pgsql-performance

On Tue, 12 Oct 2004 nd02tsk@student.hig.se wrote:

> In the MySQL manual it says that MySQL performs best with Linux 2.4 with
> ReiserFS on x86. Can anyone official, or in the know, give similar
> information regarding PostgreSQL?

Don't know which OS/filesystem PostgreSQL runs best on, but you should 
test on whatever OS and filesystem you are most experienced.

Whatever speed gain you may get from "best setups" will mean little if 
the machine crashes and you don't know how to fix it and get it back 
up quickly.



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

* Re: Which plattform do you recommend I run PostgreSQL for best performance?
  2004-10-12 15:45 Which plattform do you recommend I run PostgreSQL for best performance? nd02tsk@student.hig.se
@ 2004-10-12 20:02 ` Christopher Browne <cbbrowne@acm.org>
  4 siblings, 0 replies; 7+ messages in thread

From: Christopher Browne @ 2004-10-12 20:02 UTC (permalink / raw)
  To: pgsql-performance

In an attempt to throw the authorities off his trail, nd02tsk@student.hig.se transmitted:
> I am doing a comparison between MySQL and PostgreSQL.
>
> In the MySQL manual it says that MySQL performs best with Linux 2.4 with
> ReiserFS on x86. Can anyone official, or in the know, give similar
> information regarding PostgreSQL?

The fastest I have ever seen PostgreSQL run is on an IBM pSeries 650
system using AIX 5.1 and JFS2.  There aren't many Linux systems that
are anywhere _near_ as fast as that.

There's some indication that FreeBSD 4.9, running the Berkeley FFS
filesystem might be the quickest way of utilizing pedestrian IA-32
hardware, although it is _much_ more important to have a system for
which you have a competent sysadmin than it is to have some
"tweaked-out" OS configuration.

In practice, competent people generally prefer to have systems that
hum along nicely as opposed to systems that have ben "tweaked out"
such that any little change will cause them to cave in.  

Benchmarks are useful in determining:

  a) Whether or not it is realistic to attempt a project, and

  b) Whether or not you have made conspicuous errors in configuring
     your systems.

They are notoriously BAD as predictive tools, as the benchmarks
sponsored by vendors get tweaked to make the vendors' products look
good, as opposed to being written to be useful for prediction.

See if you see anything useful from MySQL in this regard:
<http://www.mysql.com/it-resources/benchmarks/;

> Also, any links to benchmarking tests available on the internet
> between MySQL and PostgreSQL would be appreciated.

Most database vendors have licenses that specifically forbid
publishing benchmarks.
-- 
(reverse (concatenate 'string "gro.mca" "@" "enworbbc"))
http://www3.sympatico.ca/cbbrowne/oses.html
Do you know where your towel is?



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

* Re: Which plattform do you recommend I run PostgreSQL for best performance?
  2004-10-12 15:45 Which plattform do you recommend I run PostgreSQL for best performance? nd02tsk@student.hig.se
@ 2004-10-12 20:32 ` Josh Berkus <josh@agliodbs.com>
  4 siblings, 0 replies; 7+ messages in thread

From: Josh Berkus @ 2004-10-12 20:32 UTC (permalink / raw)
  To: pgsql-performance; +Cc: nd02tsk@student.hig.se

Tim,

> In the MySQL manual it says that MySQL performs best with Linux 2.4 with
> ReiserFS on x86. Can anyone official, or in the know, give similar
> information regarding PostgreSQL?

PostgreSQL runs on a lot more platforms than MySQL; it's not even reasonable 
to compare some of them, like rtLinux, AIX or Cygwin.   The only reasonable 
comparative testing that's been done seems to indicate that:
Linux 2.6 is more efficient than FreeBSD which is more efficient than Linux 
2.4 all of which are significantly more efficient than Solaris, and
ReiserFS, XFS and JFS *seem* to outperform other Linux journalling FSes.

However, as others have said, configuration and hardware will probably make 
more difference than your choice of OS except in extreme cases.   And all of 
the above is being further tested, particularly the filesystems.

-- 
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco



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

* Re: Which plattform do you recommend I run PostgreSQL for best
  2004-10-12 15:45 Which plattform do you recommend I run PostgreSQL for best performance? nd02tsk@student.hig.se
@ 2004-10-13 08:46 ` CoL <col@mportal.hu>
  2004-10-20 12:54   ` Re: Which plattform do you recommend I run PostgreSQL nd02tsk@student.hig.se
  4 siblings, 1 reply; 7+ messages in thread

From: CoL @ 2004-10-13 08:46 UTC (permalink / raw)
  To: pgsql-performance

hi,

nd02tsk@student.hig.se wrote:
> Hello
> 
> I am doing a comparison between MySQL and PostgreSQL.
> 
> In the MySQL manual it says that MySQL performs best with Linux 2.4 with
> ReiserFS on x86. Can anyone official, or in the know, give similar
> information regarding PostgreSQL?
> 
> Also, any links to benchmarking tests available on the internet between
> MySQL and PostgreSQL would be appreciated.

http://www.potentialtech.com/wmoran/postgresql.php
http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html
http://candle.pha.pa.us/main/writings/pgsql/hw_performance/
http://database.sarang.net/database/postgres/optimizing_postgresql.html

C.



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

* Re: Which plattform do you recommend I run PostgreSQL
  2004-10-12 15:45 Which plattform do you recommend I run PostgreSQL for best performance? nd02tsk@student.hig.se
  2004-10-13 08:46 ` Re: Which plattform do you recommend I run PostgreSQL for best CoL <col@mportal.hu>
@ 2004-10-20 12:54   ` nd02tsk@student.hig.se
  0 siblings, 0 replies; 7+ messages in thread

From: nd02tsk@student.hig.se @ 2004-10-20 12:54 UTC (permalink / raw)
  To: pgsql-performance

Thank you.

Tim

> hi,
>
> nd02tsk@student.hig.se wrote:
>> Hello
>>
>> I am doing a comparison between MySQL and PostgreSQL.
>>
>> In the MySQL manual it says that MySQL performs best with Linux 2.4 with
>> ReiserFS on x86. Can anyone official, or in the know, give similar
>> information regarding PostgreSQL?
>>
>> Also, any links to benchmarking tests available on the internet between
>> MySQL and PostgreSQL would be appreciated.
>
> http://www.potentialtech.com/wmoran/postgresql.php
> http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html
> http://candle.pha.pa.us/main/writings/pgsql/hw_performance/
> http://database.sarang.net/database/postgres/optimizing_postgresql.html
>
> C.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly
>





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


end of thread, other threads:[~2004-10-20 12:54 UTC | newest]

Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-10-12 15:45 Which plattform do you recommend I run PostgreSQL for best performance? nd02tsk@student.hig.se
2004-10-12 15:47 ` Re: Which plattform do you recommend I run PostgreSQL for Matt Clark <matt@ymogen.net>
2004-10-12 16:27 ` Re: Which plattform do you recommend I run PostgreSQL for Francisco Reyes <lists@natserv.com>
2004-10-12 20:02 ` Christopher Browne <cbbrowne@acm.org>
2004-10-12 20:32 ` Josh Berkus <josh@agliodbs.com>
2004-10-13 08:46 ` Re: Which plattform do you recommend I run PostgreSQL for best CoL <col@mportal.hu>
2004-10-20 12:54   ` Re: Which plattform do you recommend I run PostgreSQL nd02tsk@student.hig.se

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