Re: Air-traffic benchmark

From: Simon Riggs
Subject: Re: Air-traffic benchmark
Date: ,
Msg-id: 1265280073.4660.157.camel@ebony
(view: Whole thread, Raw)
In response to: Air-traffic benchmark  (Lefteris)
List: pgsql-performance

Tree view

Air-traffic benchmark  (Lefteris, )
 Re: Air-traffic benchmark  ("Gurgel, Flavio", )
 Re: Air-traffic benchmark  ("A. Kretschmer", )
  Re: Air-traffic benchmark  (Lefteris, )
   Re: Air-traffic benchmark  ("A. Kretschmer", )
 Re: Air-traffic benchmark  (Arjen van der Meijden, )
  Re: Air-traffic benchmark  (Lefteris, )
   Re: Air-traffic benchmark  ("A. Kretschmer", )
   Re: Air-traffic benchmark  (Jochen Erwied, )
 Re: Air-traffic benchmark  (Lefteris, )
  Re: Air-traffic benchmark  (Alvaro Herrera, )
   Re: Air-traffic benchmark  (Alvaro Herrera, )
   Re: Air-traffic benchmark  (Lefteris, )
    Re: Air-traffic benchmark  (Ivan Voras, )
     Re: Air-traffic benchmark  (Lefteris, )
      Re: Air-traffic benchmark  (Grzegorz Jaśkiewicz, )
      Re: Air-traffic benchmark  (Ivan Voras, )
       Re: Air-traffic benchmark  (Lefteris, )
   Re: Air-traffic benchmark  (Craig James, )
  Re: Air-traffic benchmark  (Greg Smith, )
   Re: Air-traffic benchmark  (Lefteris, )
    Re: Air-traffic benchmark  (Lefteris, )
 Re: Air-traffic benchmark  ("Gurgel, Flavio", )
  Re: Air-traffic benchmark  (Matthew Wakeling, )
  Re: Air-traffic benchmark  (Craig Ringer, )
   Re: Air-traffic benchmark  (Tom Lane, )
 Re: Air-traffic benchmark  ("Gurgel, Flavio", )
  Re: Air-traffic benchmark  (Scott Marlowe, )
   Re: Air-traffic benchmark  ("Gurgel, Flavio", )
  Re: Air-traffic benchmark  (Nikolas Everett, )
   Re: Air-traffic benchmark  (Craig Ringer, )
 Re: Air-traffic benchmark  (hubert depesz lubaczewski, )
  Re: Air-traffic benchmark  (Greg Smith, )
 Re: Air-traffic benchmark  (Simon Riggs, )

On Thu, 2010-01-07 at 13:38 +0100, Lefteris wrote:
> Reported query times are (in sec):
> MonetDB 7.9s
> InfoBright 12.13s
> LucidDB 54.8s

It needs to be pointed out that those databases are specifically
optimised for Data Warehousing, whereas Postgres core is optimised for
concurrent write workloads in production systems.

If you want a best-vs-best type of comparison, you should be looking at
a version of Postgres optimised for Data Warehousing. These results show
that Postgres-related options exist that clearly beat the above numbers.
http://community.greenplum.com/showthread.php?t=111
I note also that Greenplum's Single Node Edition is now free to use, so
is a reasonable product for comparison on this list.

Also, I'm unimpressed by a Data Warehouse database that requires
everything to reside in memory, e.g. MonetDB. That severely limits
real-world usability, in my experience because it implies the queries
you're running aren't ad-hoc.

--
 Simon Riggs           www.2ndQuadrant.com



pgsql-performance by date:

From: Matthew Wakeling
Date:
Subject: Re: Optimizing Postgresql server and FreeBSD for heavy read and writes
From: Tory M Blue
Date:
Subject: bigint integers up to 19 digits.