Re: WIP: Fast GiST index build
| От | Alexander Korotkov |
|---|---|
| Тема | Re: WIP: Fast GiST index build |
| Дата | |
| Msg-id | BANLkTi=umLx8LBCSmALKpoGTFguqQxQ61w@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: WIP: Fast GiST index build (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>) |
| Ответы |
Re: WIP: Fast GiST index build
|
| Список | pgsql-hackers |
On Fri, Jun 24, 2011 at 12:40 PM, Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> wrote:
------
With best regards,
Alexander Korotkov.
On 21.06.2011 13:08, Alexander Korotkov wrote:It would be nice to have links to the datasets and scripts used, so that others can reproduce the tests.I've created section about testing in project wiki page:
http://wiki.postgresql.org/wiki/Fast_GiST_index_build_GSoC_2011#Testing_results
Do you have any notes about table structure?
Done.
It's surprising that the search time differs so much between the point_ops tests with uniformly random data with 100M and 10M rows. Just to be sure I'm reading it correctly: a small search time is good, right? You might want to spell that out explicitly.
Yes, you're reading this correctly. Detailed explanation was added to the wiki page. It's surprising for me too. I need some more insight into causes of index quality difference.
Now I found some large enough real-life datasets (thanks to Oleg Bartunov) and I'm performing tests on them.
With best regards,
Alexander Korotkov.
В списке pgsql-hackers по дате отправления: