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
Re: unlogged tables |
| Список | 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 по дате отправления: