Re: unlogged tables

Поиск
Список
Период
Сортировка
От Andy Colson
Тема Re: unlogged tables
Дата
Msg-id 4CE2C8EB.20807@squeakycode.net
обсуждение исходный текст
Ответ на Re: unlogged tables  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: unlogged tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: unlogged tables  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
I was able to apply and compile and run ok, creating unlogged tables 
seems to work as well.

I patched up pgbench to optionally create unlogged tables, and ran it 
both ways.  I get ~80tps normally, and ~1,500tps with unlogged.  (Thats 
from memory, was playing with it last night at home)

I also have a "real world" test I can try (import apache logs and run a 
few stats).

What other things would be good to test:
indexes?
analyze/stats/plans?
dump/restore?

Is "create temp unlogged table stuff(...)" an option?

-Andy


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

Предыдущее
От: "Greg Sabino Mullane"
Дата:
Сообщение: Re: GCC vs clang
Следующее
От: Tom Lane
Дата:
Сообщение: Re: GCC vs clang