Re: Select count(*), the sequel

Поиск
Список
Период
Сортировка
От Pierre C
Тема Re: Select count(*), the sequel
Дата
Msg-id op.vk82ubgueorkce@apollo13
обсуждение исходный текст
Ответ на Re: Select count(*), the sequel  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Select count(*), the sequel
Re: Select count(*), the sequel
Список pgsql-performance
> Even if somebody had a
> great idea that would make things smaller without any other penalty,
> which I'm not sure I believe either.

I'd say that the only things likely to bring an improvement significant
enough to warrant the (quite large) hassle of implementation would be :

- read-only / archive tables (get rid of row header overhead)
- in-page compression using per-column delta storage for instance (no
random access penalty, but hard to implement, maybe easier for read-only
tables)
- dumb LZO-style compression (license problems, needs parallel
decompressor, random access penalty, hard to implement too)

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

Предыдущее
От: Jesper Krogh
Дата:
Сообщение: Re: Postgres insert performance and storage requirement compared to Oracle
Следующее
От: Tom Lane
Дата:
Сообщение: Re: HashJoin order, hash the large or small table? Postgres likes to hash the big one, why?