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 the benchmark too
유상지 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
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 mariadb, and the benchmar
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.
Serve