Re: Odd blocking (or massively latent) issue - even with EXPLAIN

Поиск
Список
Период
Сортировка
От Martin French
Тема Re: Odd blocking (or massively latent) issue - even with EXPLAIN
Дата
Msg-id OFD096C18F.C98A054A-ON80257A45.0032E783-80257A45.00332C2A@LocalDomain
обсуждение исходный текст
Ответ на Re: Odd blocking (or massively latent) issue - even with EXPLAIN  (Jim Vanns <james.vanns@framestore.com>)
Ответы Re: Odd blocking (or massively latent) issue - even with EXPLAIN
Re: Odd blocking (or massively latent) issue - even with EXPLAIN
Список pgsql-performance
<p><tt><font size="2">Hi Jim,</font></tt><br /><br /><tt><font size="2">> <br />> I've already tried something
verysimilar using dd. No performance<br />> penalties during a normal running of the system - or when this
blocking<br/>> happens either actually. But I agree, it does indeed sound like some<br />> sort of I/O problem. I
justdon't know what! I do have a few more tricks<br />> up my sleeve that I'll try today. I'll post any results that
Ihave.<br /></font></tt><br /><tt><font size="2">Ok, let me know how you get on. </font></tt><br /><br /><tt><font
size="2">><br />> That latter test - won't that pretty much just read from the page cache?<br />> 'sync' may
wellhave forced dirty pages to disk but does it actually<br />> evict them to?<br /></font></tt><br /><tt><font
size="2">Basically,the cache is avoided because of the size of the file. 6000000 blocks at 8k exceeds the size of RAM
inthe machine, so it *should* miss the cache and hit the disk directly. :)</font></tt><br /><br /><tt><font
size="2">><br />> Anyway, that is off topic... perhaps ;)<br />> <br />> Thanks again,<br />> <br />>
Jim<br/>> <br /></font></tt><br /><tt><font size="2">Cheers</font></tt><br /><br /><tt><font size="2">Martin
</font></tt><fontface="sans-serif">============================================= Romax Technology Limited Rutherford
HouseNottingham Science & Technology Park Nottingham, NG7 2PZ England Telephone numbers: +44 (0)115 951 88 00
(main)For other office locations see: http://www.romaxtech.com/Contact =================================
===============E-mail: info@romaxtech.com Website: www.romaxtech.com ================================= ================
ConfidentialityStatement This transmission is for the addressee only and contains information that is confidential and
privileged.Unless you are the named addressee, or authorised to receive it on behalf of the addressee you may not copy
oruse it, or disclose it to anyone else. If you have received this transmission in error please delete from your system
andcontact the sender. Thank you for your cooperation. =================================================</font> 

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

Предыдущее
От: Daniele Varrazzo
Дата:
Сообщение: Re: Shards + hash = forever running queries
Следующее
От: Jim Vanns
Дата:
Сообщение: Re: Odd blocking (or massively latent) issue - even with EXPLAIN