@mcm : I was replying to BrendanC.
On cluster indexes: retried, getting slighly better resultsthis timings
don't get into account the actual "CLUSTER" operation, only the queries
fired after having the table reindexed.
method1 : 20.4900407235
method2 : 4.55434324348
method3 : 5.3219832108
Niphold,
Thanks for the reply.
My first question is about this:
http://www.postgresql.org/docs/8.1/static/sql-cluster.html. Sorry if
I did not explicit about what I was referring, as it is postgresql
specific. I was wondering if you would see different figures or not,
because order by is influe
Niphlod,
Just out of curiosity.
Is the dal connection pooled?
If in postgres you CLUSTER on the salary index do figures change?
mic
2012/2/10 BrendanC :
> Niphlod,
> Thanks (belatedly) for your valuable contribution and your test results.
> The only thing missing from your test is contention
3 matches
Mail list logo
