Re: [GENERAL] clustered index benchmark comparing Postgresql vs Mariadb

On Wed, Aug 30, 2017 at 9:03 PM, 유상지 wrote: > I want to get help with Postgresql. > > I investigated that Postgresql could be rather fast in an environment > using a secondary index. but It came up with different results on benckmark. > > The database I compared was mariadb, and

Re: [GENERAL] clustered index benchmark comparing Postgresql vs Mariadb

유상지 schrieb am 31.08.2017 um 04:03: > Cluster secondary indexes were faster than those without cluster indexes in > pg, but slower than mariadb. There is no such thing as a "clustered index" in Postgres. The Postgres "cluster" command physically sorts the rows of a table according to the sort

Re: [GENERAL] clustered index benchmark comparing Postgresql vs Mariadb

On Wed, Aug 30, 2017 at 10:03 PM, 유상지 wrote: > > > I want to get help with Postgresql. > > I investigated that Postgresql could be rather fast in an environment > using a secondary index. but It came up with different results on benckmark. > > The database I compared was

[GENERAL] clustered index benchmark comparing Postgresql vs Mariadb

I want to get help with Postgresql. I investigated that Postgresql could be rather fast in an environment using a secondary index. but It came up with different results on benckmark. The database I compared was mariadb, and the benchmark tool was sysbench 1.0.8 with the postgresql driver.