Re: Compression and on-disk sorting

Поиск
Список
Период
Сортировка
От Jim C. Nasby
Тема Re: Compression and on-disk sorting
Дата
Msg-id 20060515201436.GL26212@pervasive.com
обсуждение исходный текст
Ответ на Re: Compression and on-disk sorting  (Martijn van Oosterhout <kleptog@svana.org>)
Ответы Re: Compression and on-disk sorting  (Ron Mayer <rm_pg@cheapcomplexdevices.com>)
Список pgsql-hackers
On Mon, May 15, 2006 at 10:09:47PM +0200, Martijn van Oosterhout wrote:
> > In this case the problem is that we want to tell the OS "Hey, if this
> > stuff is actually going to go out to the spindles then compress it. And
> > by the way, we won't be doing any random access on it, either." But
> > AFAIK there's no option like that in fopen... :)
> 
> posix_fadvise(). We don't use it and many OSes don't support it, but it
> is there.

There's an fadvise that tells the OS to compress the data if it actually
makes it to disk?
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461


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

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Compression and on-disk sorting
Следующее
От: Hannu Krosing
Дата:
Сообщение: Re: Iterating generator from C (PostgreSQL's pl/python RETUN