Re: best way to test new index?

Поиск
Список
Период
Сортировка
От Yves Weißig
Тема Re: best way to test new index?
Дата
Msg-id 4DB13476.7030703@rbg.informatik.tu-darmstadt.de
обсуждение исходный текст
Ответ на Re: best way to test new index?  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-hackers
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:
>> 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 would make sure
>> that the optimizer was doing a reasonable job of knowing when it was
>> usable and what it cost, so that it would be chosen when
>> appropriate.  Once everything seemed to be behaving I would
>> benchmark it against the reasonable alternatives.
> 
> ... And then finally, kill -9 the database server while updating the
> index to test crash-safeness.
> 


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: Formatting Curmudgeons WAS: MMAP Buffers
Следующее
От: Leonardo Francalanci
Дата:
Сообщение: Re: switch UNLOGGED to LOGGED