From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Rod Taylor <rbt(at)rbt(dot)ca> |
Cc: | Oleg Lebedev <oleg(dot)lebedev(at)waterford(dot)org>, Jeff <threshar(at)torgo(dot)978(dot)org>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: Tuning/performance issue... |
Date: | 2003-10-04 02:38:17 |
Message-ID: | 200310040238.h942cHX12107@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Rod Taylor wrote:
-- Start of PGP signed section.
> On Fri, 2003-10-03 at 21:39, Bruce Momjian wrote:
> > I have updated the FAQ to be:
> >
> > In comparison to MySQL or leaner database systems, we are
> > faster for multiple users, complex queries, and a read/write query
> > load. MySQL is faster for SELECT queries done by a few users.
> >
> > Is this accurate? It seems so.
>
> May wish to say ... for simple SELECT queries ...
Updated.
> Several left outer joins, subselects and a large number of joins are
> regularly performed faster in PostgreSQL due to a more mature optimizer.
>
> But MySQL can pump out SELECT * FROM table WHERE key = value; queries in
> a hurry.
>
>
> I've often wondered if they win on those because they have a lighter
> weight parser / optimizer with less "lets try simplifying this query"
I think that is part of it.
> steps or if the MYISAM storage mechanism is simply quicker at pulling
> data off the disk.
And their heap is indexed by myisam, right. I know with Ingres that Isam
was usually faster than btree because you didn't have all those leaves
to traverse to get to the data.
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-10-04 03:49:03 | Re: reindex/vacuum locking/performance? |
Previous Message | Christopher Browne | 2003-10-04 02:37:53 | Re: Tuning/performance issue... |