bristol@mailman.lug.org.uk
To subscribe or unsubscribe via the World Wide Web, visit
https://mailman.lug.org.uk/mailman/listinfo/bristol
or, via email, send a message with subject or body 'help' to
bristol-request@mailman.lug.org.uk
You can reach the person managing the list at
bristol-owner@mailman.lug.org.uk
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Bristol digest..."
Today's Topics:
1. Re: Postgres optimised h/w (Jonathan Stone)
2. Re: Fwd: Last LUG Meeting of 2016 this Saturday! Tommorow!
(peternsomerset@virginmedia.com)
----------------------------------------------------------------------
Message: 1
Date: Sat, 17 Dec 2016 17:36:05 +0000
From: Jonathan Stone <lug@jonstone.org.uk>
To: Martin Moore via Bristol <bristol@mailman.lug.org.uk>
Subject: Re: [bristol] Postgres optimised h/w
Message-ID: <20161217173605.GB972@discordia.qaotiq.co.uk>
Content-Type: text/plain; charset=iso-8859-1
On Sat, Dec 17, 2016 at 02:07:19PM +0000, Martin Moore via Bristol wrote:
> On 17/12/2016, 13:49, "Bristol on behalf of Jonathan Stone via Bristol" <bristol-bounces@mailman.lug.org.uk on behalf of bristol@mailman.lug.org.uk> wrote:
> If the goal is to reduce the users' response times, then first you
> should to get a feel for where the time is being spent today. Is
> most of the time being spent waiting on physical IO, on CPU scanning
> through the data or on the network throughput/latency getting the
> queries and results to and from the database server?
>
>
> It???s the actual query ??? lots of table scans.
I would want to know what resources were used on the database server
in order to actually perform those table scans and the rest of the
query processing. When it comes to performance, I like to avoid
making assumptions.
The sort of metrics I would look at are, for a single typical execution
of this query:
1. how much CPU time is used on the database server
2. how many logical IOs are required
3. how many physical IOs are issued
4. how large those IOs are
5. how long the database waited for the IOs to complete
You may find the bottleneck moves during the query processing, e.g.
start off IO bound whilst performing a full table scan and then become
CPU bound while performing hash joins or sort operations.
In the Oracle world this all can be collected together in a SQL
monitoring report with a pretty bow on top (for a price). However
I'm not familiar with what is available in Postgres.
Jonathan
------------------------------
Message: 2
Date: Sat, 17 Dec 2016 21:16:47 +0300
From: peternsomerset@virginmedia.com
To: Samir Benmendil <me@rmz.io>, Bristol and Bath Linux User Group
<bristol@mailman.lug.org.uk>
Subject: Re: [bristol] Fwd: Last LUG Meeting of 2016 this Saturday!
Tommorow!
Message-ID: <1481998607.990817888@f22.my.com>
Content-Type: text/plain; charset="utf-8"
Yes I was there!
A small but intelligent group turned up late!
Happy Christmas☺
--
Sent from myMail for Android Saturday, 17 December 2016, 02:58pm +00:00 from Samir Benmendil via Bristol bristol@mailman.lug.org.uk :
>
>
>Anyone there already? Couldn't find anyone.
>
>On Friday, 16 December 2016, Sebastian via Bristol < bristol@mailman.lug.org.uk > wrote:
>>Hi
>>
>>WOW what a great turn out, WOW, WOW, indeed, what a great turn out, for last months November LUG meeting. I remember emailing here on the list about how it would be basically good to have a 10 people turn out, and we had like 11, including ourselves people who turned up Three from the event the previous month it seems as well, well ok two don't really count I guess then since were already on the mailing list apparnatly, but still one guy did come in from the event. That was good, after running the event and the type of event it was, and general turn out it ended up getting, and of what kind of people. The big question would be though, can we have a about 10 people turn out at the LUG meeting tommorow as well or not? 10 people turn out is rather impressive, since a lot of people don't come to the meetings anymore or rather rarely, that are still on this list. Its not just, because quite a few people have moved away from the general, big area of, Bristol, Bath, and sourunding areas. Yes our LUG may be mostly social chat now for the meetings, rather than helping people with basic to advanced support issues, but thats since Desktop Linux is generally much easier to use now for most distros, than it used to be, and its been like that for many years now.. I been to the LUG meetings since I think it was April 2012 I think last month was the biggest turn out of people that have ever had it in that time, whilst I have been there, or if not for quite a while.
>>I would like to meet some of the people who used to come to the LUG meetings a lot this Saturday ideally, but I think to keep the in person side of this LUG nicely alive, with good turn outs of people for most LUG meetings etc, its good now to do things at times that will hopefuly bring new people into them, such as events. Next year 2017 should have three events it seems, two Linux Presentaiton Day events, and one bigger event organised by someone else as well it seems, with public speaking even. Which would be quite impressive right?
>>
>>Tommorow is the Christmas meeting at the Knight's Templar hence a week earlier than usual as well, we should be sitting at the table in the left hand side corner by the plugs at the back of the pub on the lower level as usuaul, or near there instead if someone else not us is already there. The first one of us will probably arrive at about 2pm, but for anyone who may be new that might be coming tommorow I would suggest not turning up untill 2:30pm by the earliest, or may be there on own. As usaul I hope to meet new people at the LUG meeting, and I probably won't be there untill about 3pm myself, and then laving late about 6pm/7pm. What about other people who are intending on coming tommorow? We can eat Christmas dinner there tommorow as well, already had some last month, but will again ;). Also I been wondering about Samir and what plan he actusally booked for FOSDEM, and if our newer person from the event, who is hopefuly on this list now, is intending on coming still or not as well.
>>
>>Anyone got some USB's to bring along tommorow? Yes Linux Live USB's! Ideally of more fun distros to so not just common things like Fedora and OpenSUSE, and Ubuntu 16.10, but yes please someone bring those along to. Oh and the USB's I am after must have support for UEFI. I guess the USB's don't have to be Linux though. You see I have bought a interesting mini PC, that was going to crowd fund earlier this the year, but didn't reallly have the spare money then. The pre installed Windows 10 didn't last that long on there at all, more details about that at the LUG meeting tommorow. I had a USB stick with Ubuntu 16.04 on it, so put that on. Ubuntu 16.04 mostly works on it, altough with some hardware issues, because of how the device was only really intended to be made for Windows 10, but considering that and how much still just works, that's quite good really. For a few things can probably fix onself though. More details tommorow at the LUG meeting.
>>
>>2016 Regards
>>
>>Sebastian
>>
>>
>>--
>>Sent using Dekko from my Ubuntu device
>>
>>_______________________________________________
>>Bristol mailing list
>>Bristol@mailman.lug.org.uk
>>https://mailman.lug.org.uk/mailman/listinfo/bristol
>
>--
>Samir Benmendil
>
>"[The World Wide Web is] the only thing I know of whose shortened form — www — takes three times longer to say than what it's short for." Douglas Adams
>
>_______________________________________________
>Bristol mailing list
>Bristol@mailman.lug.org.uk
>https://mailman.lug.org.uk/mailman/listinfo/bristol
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.lug.org.uk/mailman/private/bristol/attachments/20161217/3034ca5e/attachment-0001.html>
------------------------------
Subject: Digest Footer
_______________________________________________
Bristol mailing list
Bristol@mailman.lug.org.uk
https://mailman.lug.org.uk/mailman/listinfo/bristol
------------------------------
End of Bristol Digest, Vol 673, Issue 13
****************************************
Tidak ada komentar:
Posting Komentar