Re: MySQL InnoDB Performance vs Postgres
Performance boost is good. If queries both may return a lot of rows you would probably do best with covering index. It would allow to retrieve all/most of rows with single read.
Performace depending on data size is usually non linear - when data fits in memory it is one case, when you get miss rating growing up to certain point and when it is close to some stable state being seriously IO bound.
Ie if you have 1GB of buffer pool you can get great performance with table size up to 1GB, when it will start to drop gradually (depending on your working set) with 40GB for example you may reach very IO bound case and it would be only marginally different from 400GB.
Subject
Views
Written By
Posted
4612
July 20, 2005 03:42PM
1988
July 20, 2005 04:16PM
1954
July 20, 2005 05:12PM
2189
July 20, 2005 05:27PM
2117
July 20, 2005 07:57PM
2115
July 21, 2005 12:53PM
1953
July 24, 2005 11:36PM
Re: MySQL InnoDB Performance vs Postgres
2103
August 03, 2005 12:34PM
2090
July 21, 2005 05:37AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.