Re: [HACKERS] best way to test new index?

2011-04-23 Thread Yves Weißig
Thanks for the answer Kevin! I am developing an encoded bitmap index, as proposed in http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.44.7570&rank=1 Automated, in my words, would have meant... some SQL-Statements which create tables, do inserts, deletes, selects and so on and the results c

Re: [HACKERS] best way to test new index?

2011-04-22 Thread Kevin Grittner
Yves Weißig wrote: > Ok, but I thought more like an automated test, or a test which > checks if the interface is correctly implemented. I'm not aware of any automated tests which would test whether a new index type is correctly implemented. For starters, how would the test know when the AM sho

Re: [HACKERS] best way to test new index?

2011-04-22 Thread Yves Weißig
Ok, but I thought more like an automated test, or a test which checks if the interface is correctly implemented. By the way, tho broaden the topic, what would be the best way to debug in pg? elog? asserts? Am 22.04.2011 01:26, schrieb Josh Berkus: > On 4/21/11 1:28 PM, Kevin Grittner wrote: >> Tha

Re: [HACKERS] best way to test new index?

2011-04-21 Thread Josh Berkus
On 4/21/11 1:28 PM, Kevin Grittner wrote: > That said, I would start by making sure that basic things like > CREATE INDEX and DROP INDEX work. Then I would test that INSERT, > UPDATE, and DELETE do the right things with the index. Then I would > make sure that vacuum did the right thing. Then I

Re: [HACKERS] best way to test new index?

2011-04-21 Thread Kevin Grittner
Yves Weißig wrote: > Am 21.04.2011 20:56, schrieb Kevin Grittner: >> Yves Weißig wrote: >> >>> what is the best way to test a new developed index structure? >> >> Are you talking about a new AM (like btree, hash, GiST, or GIN)? > > Yes I do! The tests are going to depend somewhat on what the

Re: [HACKERS] best way to test new index?

2011-04-21 Thread Yves Weißig
Yes I do! Am 21.04.2011 20:56, schrieb Kevin Grittner: > Yves Weißig wrote: > >> what is the best way to test a new developed index structure? > > Are you talking about a new AM (like btree, hash, GiST, or GIN)? > > -Kevin > -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql

Re: [HACKERS] best way to test new index?

2011-04-21 Thread Kevin Grittner
Yves Weißig wrote: > what is the best way to test a new developed index structure? Are you talking about a new AM (like btree, hash, GiST, or GIN)? -Kevin -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/ma

[HACKERS] best way to test new index?

2011-04-21 Thread Yves Weißig
Hello pgsql-hackers, what is the best way to test a new developed index structure? Greets, Yves -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers