Four issues why "old elephants" lack performance: Explanation sought Four issues why "old elephants" lack performance: Explanation sought

Поиск
Список
Период
Сортировка
От Stefan Keller
Тема Four issues why "old elephants" lack performance: Explanation sought Four issues why "old elephants" lack performance: Explanation sought
Дата
Msg-id CAFcOn28S91wYb4fftiV5f2sESWGR0V3AvShyJXLsaSoWSXveRg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Four issues why "old elephants" lack performance: Explanation sought Four issues why "old elephants" lack performance: Explanation sought  (Scott Marlowe <scott.marlowe@gmail.com>)
Re: Four issues why "old elephants" lack performance: Explanation sought Four issues why "old elephants" lack performance: Explanation sought  (Andy Colson <andy@squeakycode.net>)
Список pgsql-general
Hi,

Recently Mike Stonebraker identified four areas where "old elephants"
lack performance [1]:

1. Buffering/paging
2. Locking/Multithreading
3. WAL logging
4. Latches (aka memory locks for concurrent access of btree structures
in buffer pool?).

He claims having solved these issues while retaining SQL and ACID.
But the only issue I understood is #1 by loading all tuples in-memory.
=> Are there any ideas on how to tell Postgres to aggressively load
all data into memory (issue #1)?

All remaining issues make me wonder.
I actually doubt that there are alternatives even theoretically.
=> Can anyone help explaining me issues 2,3 and 4, their solutions,
and why Postgres would be unable to resolve them?

Yours, Stefan

[1] "NewSQL vs NoSQL for New OLTP", NoSQLNow! Conference, August 2011.
http://voltdb.com/resources/videos

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

Предыдущее
От: Frank Church
Дата:
Сообщение: What effect does destroying database related threads have on system resources?
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: Four issues why "old elephants" lack performance: Explanation sought Four issues why "old elephants" lack performance: Explanation sought