Re: Significantly larger toast tables on 8.4?

Поиск
Список
Период
Сортировка
От Andrew Chernow
Тема Re: Significantly larger toast tables on 8.4?
Дата
Msg-id 495EF4DC.3040802@esilo.com
обсуждение исходный текст
Ответ на Re: Significantly larger toast tables on 8.4?  ("Robert Haas" <robertmhaas@gmail.com>)
Список pgsql-hackers
Robert Haas wrote:
> 
> Compression is
> generally bad for performance, though there are certainly exceptions.
> What it is good for is saving disk space, and that is why people use
> it.
> 

I don't think disk space is still the primary reason for using compression; 
shoot.. I can buy a terabyte drive for $150 on newegg and 1.5TB drives are out.  I think the primary reason has been
slowlymoving towards performance.  Fast 
 
downloads, compressed web sites or simply reading/writing less to/from disk are 
very common use cases for compression; all increase performance.  Basically, 
compression comonly offers faster data delivery.  As long as you utilize a fast 
compressor, like lzo or zlib "NOT level 9", its a performance win.

-- 
Andrew Chernow
eSilo, LLC
every bit counts
http://www.esilo.com/


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

Предыдущее
От: "Robert Haas"
Дата:
Сообщение: Re: Significantly larger toast tables on 8.4?
Следующее
От: "Alex Hunsaker"
Дата:
Сообщение: Re: Significantly larger toast tables on 8.4?