Re: Inserting 8MB bytea: just 25% of disk perf used?

Поиск
Список
Период
Сортировка
От Scott Carey
Тема Re: Inserting 8MB bytea: just 25% of disk perf used?
Дата
Msg-id FFDFFE4C-A683-4168-B544-951A6150233E@richrelevance.com
обсуждение исходный текст
Ответ на Re: Inserting 8MB bytea: just 25% of disk perf used?  (Greg Smith <greg@2ndquadrant.com>)
Список pgsql-performance
On Jan 21, 2010, at 12:35 AM, Greg Smith wrote:

> Scott Carey wrote:
>> On Jan 20, 2010, at 5:32 AM, fkater@googlemail.com wrote:
>>
>>
>>> In the attachement you'll find 2 screenshots perfmon34.png
>>> and perfmon35.png (I hope 2x14 kb is o.k. for the mailing
>>> list).
>>>
>>>
>
> I don't think they made it to the list?  I didn't see it, presumably
> Scott got a direct copy.  I'd like to get a copy and see the graphs even
> if takes an off-list message.  If it's an 8.2 checkpoint issue, I know
> exactly what shapes those take in terms of the disk I/O pattern.
>

I got the images directly from the email, from the list.
So .... ???


> --
> Greg Smith    2ndQuadrant   Baltimore, MD
> PostgreSQL Training, Services and Support
> greg@2ndQuadrant.com  www.2ndQuadrant.com
>


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

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: Data Set Growth causing 26+hour runtime, on what we believe to be very simple SQL
Следующее
От: Scott Carey
Дата:
Сообщение: Re: Inserting 8MB bytea: just 25% of disk perf used?