Hey, fellow buddies. Thanks for watching. All right, you guys I just want to pop on here and talk to you about some broaches that you may not know are worth big money and The first hey fellow buddies. Thanks for watching Amazing right all right, let's get started Okay, fellow buddies. I have a what not show tonight at 10 15 p.m. Eastern Standard Time I am gonna be bringing jewelry vintage to now. I've got Tons of broaches. All right, fellow buddies. So up here is my fancier stuff I'm thinking about digging into some of this tonight. I also have a ton of broaches that I have been going through I'm gonna do some pick two some pick threes some singles This shelf would be items that I'm gonna do in small lots and some singles depending on what it is and all of this down here Oh, I can't even pull it out is crafters all crafters So if you guys want to see some crafters lots, let me know down in the comments and I'll see you guys tonight. Thanks for watching. So follow me down below. There is a link You can get $15 to shop when you use that link to join and I hope to see you guys tonight We're gonna talk about I'm really gonna ask your opinion But the other ones through all of my research over and over and over and over again Seeing these broaches going for big money. So let's talk about it So I know most of you think that Avon is pretty much worthless. Well, Avon did collaborations with other brands So those brands would get with Avon and they would make a brooch or a necklace or a piece of jewelry and It would be a collaboration and Avon would sell it, but it would be exclusive to Avon That's how I understand it now this first one I can't verify and I'm not sure if this is legit or if the seller messed up So all of you people out there that maybe know something about broaches or are experts in trifari or Experts in Avon. Let me know down in the comments Is this actually a trifari piece because I'm looking here and I don't see anywhere where this brooch is signed, but they did not show the back So they said it's a trifari piece from 1997 for Avon and it sold for $75. So I guess be on the lookout. Maybe Traffari and Avon did collabs. I'm not really sure but the other ones I know are definitely big money bolos So let's look at some more here This one here is a 1983 Jose Barrera, I think is how you say it for Avon So anything that you see that is Jose Barrera for Avon, definitely pick it up and Look it over. Let's see if this one is signed on the back. I'm researching right here with you guys Is that a signature maybe right there? Oh? It's hard to say this one is in the original box So maybe that's how they knew I think maybe this circle has something in it down here at the bottom Perhaps but this sold for a hundred and twenty dollars now. These are older vintage brooches. This one's from 1983 The next item. I just was caught completely off guard completely costume no Collaboration, but it's an Avon Casino slot machine brooch pin winner three lipsticks silver tone and vintage and They've got the measurements. It says Avon clearly on the back this sold for I had to go over to Terapeak because a best offer was taken of $75 so if it is Slashed through and you know a best offer was taken you can take that title and you can cut and paste it Over to Terapeak and that will give you the actual sold price Now this one right here is not signed it just says Avon Sunflower satin gold plain unpainted rare signed 1980s it's just an Avon brooch. It's signed right there I never would have looked at this one and thought that it was worth big money But it looks like it sold for 150 plus shipping and hold on a second. Look at this Do you see that? Those look really similar, right? Okay, we'll come back to that So I could not find where I checked the seller's uh feedback There was no feedback, but they had not relisted the item So I'm going to assume this is a good sale now My question for you is this looks Like this only It's all one color Do you agree? Do you guys agree with me? This one is YSL. I've send laurence Hold on. I thought I was going to try really hard to get this one right Ives San Laurent I think is how you say it. I can't remember you guys have told me a hundred times But anyway, it's from 1982 and that brand is always a bolo So if you see it whether it's towels or clothes or jewelry Pick it up and definitely comp it, but don't sit it back down until you look it up Now let's see here looky looky looky I feel like that one is signed avon only. I don't see where it's signed With the clap so maybe not all of them are maybe that's just something you have to know So if you see this avon piece Definitely Know that it is a good one. I saw this one over and over and over again in the solds So it wasn't just this one pin one time that I saw this was in the the solds a lot And this one sold for 159 dollars with one bid So do you think maybe somebody got the paint off of it? Or do you think that avon had a A different I don't know. I'm so confused about this. Let me know down in the comments There's got to be an avon person in the group that knows This one is kenneth j lane kenneth j lane definitely a bolo They did a collab with avon. There are lots of different variations This one is actually if I can get the photo to work here marked right here kjl for avon So you can see it right there let's go back out and this one Is a snake a double snake pin and I went over to terapeake and it sold for 120 plus shipping Elizabeth taylor is probably the number one big money brooch that did a collab with avon that you want to be looking for It seemed like I saw so many different variations of elizabeth taylor for avon that went for big money This one is a double head horse brooch I'm not sure why there's not a picture of the back. It seems like a lot of these photos people didn't do a whole lot of photos I would recommend As a buyer and seller on ebay if i'm buying I want to see I want to see where it's signed And as a seller I would think that you would want to show the back of the brooch Just so the person buying it can see the condition and stuff like that So that would be my recommendation. This is slash through so I put it into terapeake and looky here a hundred and ninety a hundred eighty nine ninety nine a hundred and sixty two one forty nine one thirty nine One fifty one forty one eighty. This is definitely a big Money bolo brooch to look for the double headed horse This one is another hosé berrera. Let's see if there's there we go Now you can actually see it on this one. I thought maybe it was in the little circle There it is And this one actually sold for A best offer of a hundred and forty dollars. This is also from nineteen eighty three Now this elizabeth taylor if you guys can find this elephant It is a big money bolo. This one sold for two hundred and thirty seven dollars and fifty cents And it is missing a bead it said bead missing So I don't know where the bead is missing if it's a rhinestone or a bead But it still sold for two hundred and thirty seven dollars and fifty cents With twenty two bids Here is another one two hundred and fifty three dollars. This is not an accident This is not like somebody got lucky. This brooch goes for big bucks So be on the lookout for this elizabeth taylor for avon brooch I was hoping to get a picture of the back for you guys. Here we go right here Elizabeth taylor. I don't know if it says avon. Let's look at the back of this one and see if we can get a better shot of it um Let's see. I don't it's too hard to tell see I always do a close-up of that but you know, that's just what I do so This one is a rare elizabeth taylor for avon sea shimmer brooch koi fish swimming And two hundred and eighty nine dollars on this one. It is absolutely stunning This was another one that I kept seeing over and over and over again. Here we go This is a nice shot of what it should look like Elizabeth taylor avon right there. That's what you're looking for if you see that look it up. There's an elephant There's a koi fish. I saw a heart. I saw a whole bunch. I'm only showing you a few But elizabeth taylor, bam Bolo, here's another one and this one is missing a pearl Missing a pearl right there and it sold for two hundred and fifty dollars And you can see right here the feedback was left I'm sorry. There was a best offer on this one, but there was feedback. Let's see what it sold for Uh, that one sold for either a hundred and ninety eight or a hundred and fifty five So i'm gonna guess Well, I guess I can't assume anything. Let's see if there's a date March 9th and march 13th. So it sold for a hundred and fifty five But on march 20th this one here that is also missing a pearl sold for two hundred dollars Let's look at this one because it has a different background And which pearl is it missing? I don't know. I don't see it. Maybe they just did a copy paste Is it missing a pearl right there? I can't tell And use somebody else's title and forgot to update it. Who knows that could be but that one sold for two hundred here's another one of the elephants and It says as is auction, please read description And then a flower problem will absolutely be mentioned Very good condition. No issue. So this one is in good condition sold for two hundred and ninety nine dollars With the buyer paying shipping. So this is not a super long video There are not a ton of brands of avon that go for big money. I was looking in around the hundred dollar range I'm sure there is a lot that fall in the Bread and butter and then also some that fall into the Fifty dollars to a hundred dollar range as well But these are the big money ones that you want to find so if you see these just because it says avon Don't pass it by. All right, you guys. Thanks so much for being here and thanks for watching And I hope to see you guys tonight Even if you don't want to buy anything just come hang out. It's super fun Basically, I'm going to be showing jewelry and if you want to bid you can bid and if you don't You don't have to just hang out in the chat. I do have other things besides broaches. I have a whole display I'll show you guys some of that. We may dig into that tonight. I don't know And if you guys want to see another jewelry jar, let me know down in the comments. All right Thanks so much for being here. Be sure to like comment subscribe and share and thanks for watching


The fact that information spreads quickly means that truth can spread quickly and lies can spread quickly and Wikipedia I think really tries to be that that place you go when you've got a moment to reflect to say okay I actually need to learn about this. Wikipedia is a crowdsourced encyclopedia. You don't have to buy it and anyone can edit it. So you have to have your sources and you have to have your citations so there's always a way to back up the the information so it's not just out there recklessly or irresponsibly there's always something you know backing it up so that you can always start back from the original source. Working with Wikipedia is not only about writing articles but to understand the whole system of knowledge production. What's our place in the Knowledge Society. We came down and we'll leave it on the side and that's the challenge. There's no challenge with us. The challenge is that we enter quickly or we enter quickly with any direction. We know from the technologies that are on Wikipedia's website the world's most famous. I'm from Ukraine. I'm from Ghana. I'm from Argentina. I'm from Moscow, Russia. I come from Egypt. Hong Kong, Israel, Berlin, South India. Ramallah, Palestine. We are fundamentally community driven and this is very different from any other top website and it matters. Whatever you might think of Wikipedia, whatever problems Wikipedia has, of course we have problems. Nobody ever sits around and says, yeah well they're beholden to their advertisers. Our community has a very high degree of intellectual independence. No one can come to us and try to lean on us to put false information in Wikipedia or to hide some true information that they don't like because frankly the money comes from the general public and that means we're beholden to the general public. In 100 years when people look back on this era, these decades around the first of this century, they're going to point at Wikipedia as one of the things that was really good.


Welcome to Monitoring Strategy Considerations. I'm joined by David Orlandy, Senior Systems Consultant at Quest Software, who will discuss considerations as you develop monitoring and diagnostic strategy. My name is Lindsay Hooper, and I'm one of the Postgres Conference organizers. I'll be your moderator for this webinar today. With that, I'm gonna hand it off to David. Take it away. Thank you, Lindsay. Hello, everybody. As Lindsay mentioned, my name is David Orlandy. I'm with Quest, and I'm one of the Database Systems Engineers here. More specifically, I'm part of the business unit with particular focus on database monitoring and diagnostics solutions. I've been with Quest for just over eight years now. And before Quest, I held a similar sales engineering role at Embarket Arrow Technologies. Some of you may be familiar with them. It's a database tools company based in the San Francisco Bay Area. All told, I've been a part of the database software industry for about 20 years now. So thank you for joining the session today. I hope everyone is staying healthy and safe out there. I hope you find this information I share useful to your day-to-day tasks and responsibilities. So let's jump in and get started. The topic I'd like to share with you today is about the importance of monitoring and the many considerations as you develop a monitoring and diagnostics strategy. IT administrators need to keep an eye on availability, performance and storage of mission critical environments. With this in mind, there are several things to consider and prioritize. In the session today, the areas I'll cover include all in one versus specialized. In other words, do you want a monitoring solution that monitors lots of items? Or do you want to have one that is laser focused on one or two items? Build versus buy.  Or perhaps invest in something off the shelf. Real-time diagnostics versus 24 by seven monitoring, we'll discuss advantages and disadvantages of both. Architecture, something to really consider and is very important. What are the moving parts under the covers with the monitoring solution? Are there traditional agents? Is there overhead associated with the monitoring and diagnostics solution? Does the architecture provide flexibility in deployment? Configuration, are your databases on-prem in the cloud or do you have a hybrid deployment? And the same would be asked of your monitoring solution whether you want it to be on-prem in the cloud or hybrid. We'll discuss alerting notifications and actions, all of which are important to stay ahead of potential issues and be notified of potential problems. Understanding what is considered normal activity. So in addition to just seeing straight out metrics of things like memory pressure or latency or query performance, it's important to know how your environment normally runs and how it behaves and potentially be alerted if it's not acting normally. Advisory is in troubleshooting suggestions. This is something most everyone likes to have to get advice or some guidance on what to do next if you do indeed see performance issues and alerts firing. Documenting the details of your environment. In other words, your monitoring metrics and being able to communicate that out to your stakeholders and your environment, very important. And we'll round out the session today by reviewing some specific post-grasp metrics and discussed with particular use cases. Now, as Lindsay mentioned, I will have a few questions for you, the attendees. So the first one I have for you right now is, I really just wanna get a better understanding of the post-grasp monitoring landscape by polling you for just a sample size of data. So if you care to participate and share, it would be appreciated. The first one, just use again the chat feature in Zoom to submit your answers. And the first one is with an answer of one, two, three or four, what are you mostly using in your post-grasp environment? Is it version nine, version 10, version 11 or version 12? Okay, all over the map, but I actually see what I expected so far, which is a lot of nine and a lot of 12. I'm personally seeing less of those in between. It looks like we got mostly ones and fours with a few threes scattered in there, so nine, 11 and 12. Okay, and somebody squeezed in a version 10. Thank you for that. One more, I'll cover here. Answer with one, two or three. Right now you're not really monitoring your post-grasp environment. Or two, you're monitoring, but with your own queries or scripts or homegrown application. Or finally, three, you indeed have invested and are using a third-party solution. Okay, two, two and three, okay, great. Really appreciate the responses and the feedback. Okay, great, that's good information for me. So let's dive into the content of today's topic and start out with all in one versus specialized. So perhaps we have some musicians in the audience or I'm guessing at least most of you like to listen to some kind of music. As a musician myself, I thought this analogy kind of hits the mark. When it comes to selecting a software solution, there's a tendency to lean towards and a kind of a one-man band solution that empowers users to essentially do it all. Though there are some efficiencies to gain this way, more often than not, each item addressed may suffer a bit. So this guitarist on the right is likely going to perform with more precision and accuracy than the one on the left, right? So two is often the case with monitoring solutions. It's certainly possible for a monitoring solution to properly monitor several aspects of an environment. But there is a lot to consider, your applications, the databases, the underlying hosts, virtual environments, middleware, storage arrays and so on. But the more you include as a requirement for that one solution, it can create some friction and can often dilute areas of concentration. In other words, it's important to identify your correct monitoring scope. Now, as you consider and add more requirements, you'll need to get buy-in from other stakeholders and in your enterprise, right? And again, as you need a solution to do more, details for particular areas of focus may indeed suffer. Now, to take this analogy a bit further, the musicians and instruments you have, the more challenging it can be to be in concert, so to speak, right? So it helps to identify not only what needs to be monitoring, but also what items to be monitored are most closely related and with whom and or what other groups you will need to be and stay in concert with. A DBA likely needs detailed information about those databases, but also likely the underlying window and or windows and or Linux host information. Virtualization metrics may be important too, but for a DBA, how much VM detail do you really need versus that of say a VMware administrator? Now, in my experience, application monitoring solutions often try to monitor everything, but often fall short in particular areas. So again, find that correct scope for your monitoring solutions capabilities. Build versus buy, I'll use another analogy and this time a house. There are lots of pluses and minuses to both build and buy and the things to consider are similar. So in that of build and buy for a monitoring solution. So with build, the big advantage is that you can customize on the front end to your heart's content. I want a roof with four gables. I want 18 windows. I want a basement. I want hardwood floors and so on. Now in doing so, what is that that you also have to weigh into that equation? The potential build downsides include time and cost. With a monitoring solution, build equals either homegrown scripts and or internally developed custom applications. Now moving away from that house analogy for a moment, there are added considerations, mind share. What if the person or people who wrote and maintained the scripts and or custom applications leave? And what about all of the updates you may need to do if and as new versions of what you're monitoring are introduced? These new versions or additions may require rewrites to your scripts or internally developed applications. Now in the Postgres world, that may mean manually querying for those statistics leveraging those PG underscore stat tables and views. And here are some examples of that. Some of you who shared that you're doing that today. Real-time diagnostics versus that of 24 by seven. Now depending on your requirements for level of support, real-time diagnostics tools can be all that certain environments need. You can run scripts and or open that client side utility to investigate what is going on right now. And that could be effective. And sometimes enough. Now that said, to know that there is an issue going on unless you've just run those diagnostics, this method often relies on getting feedback from the end users, internal or external and them sharing things like, I can't connect or things are slow. So with 24 by seven monitoring solutions, though there will be a bit more to the architecture and likely higher cost, you won't miss anything because those 24 by seven solutions will typically offer things like alerts, but also notifications. You can get an email if a problem arises, things like that, but also a repository to hold historical data. Often with the ability to use the user interface to pull data from a historical window of time to understand what happened in the past. And sometimes those solutions offer a means to query that repository directly. Now here's an example of an architecture slide. I removed the naming convention to protect the innocent. There are a number of items to consider specific to a software solutions architecture. Does it cost money per component? And based on what your needs or requirements are, might you need to add components? Is that architecture flexible? For example, how does it work with a DMZ? Or what if there are multiple domains? Another thing to consider are there upper limits to what can be monitored? What is its resource consumption or overhead? You often hear that in X percentage, 2%, 3% or more. How about agents, traditional agents? And what I mean by that is, does the solution require that you install software or services or binaries on what you wanna monitor? On that monitored host. If so, that invasiveness can have implications. There might be additional overhead. You might need to now engage additional business stakeholders. Things like getting approval and access to install those agents. And these agents may need updating over time. So in general, I found that though there are some advantages for detailed metrics, most folks prefer to avoid solutions or architectures that leverage traditional agents. What about the monitoring solutions graphic user interface? Is it a thick client? Now, if that's the case, it means you'll need to install a client-size software wherever you wanna view your monitoring metrics, as opposed to say a web-based client. Now, the look and feel between a thick client or a web-based client is obviously personal preference, but at least with a web-based GUI, all you need is access to a web browser. So those are more things to consider. Your configuration or your deployment. Now, what I'm about to cover, these questions will pertain both to the deployment of the monitoring software itself and what you need or want to monitor. So is what you want monitored on-prem and can the monitoring solution be installed on-prem? Is what you want monitored in the cloud? Is it infrastructure as a service? Might it be a platform or database as a service? Is the monitoring solution able to be deployed to the cloud in that case? Some folks need or want a SAS model for your monitoring solution, software as a service. Is that deployment option available for the monitoring solutions you're considering? And then, of course, the same questions apply for a hybrid approach. So this is the last of a few polling questions I have. Again, please use the chat feature in Zoom and answer with one, two, or three to best describe your Postgres deployment. One, everything is on-prem. Two, everything is in the cloud and that could take the form of maybe it's Azure, maybe it's AWS, RDS, maybe it's Aurora. Or three, you have a hybrid deployment and a little bit of both. And that's a really good mix. I'm seeing almost an even split between one, two, and three. Great, okay. In my personal experience, I'm seeing more and more folks moving to the cloud and that transition has really happened probably in the past, only the past 18 months or so before that I was seeing by and large mostly on-prem deployments. And when it started going to the cloud, I saw quite a bit of RDS, quite a bit of Aurora, and then very recently I'm seeing more and more Azure deployments. Now let's move on to discussing alerts as it relates to a monitoring and diagnostic solution. Now most monitoring solutions offer alerting capabilities. Thresholds can be defined and if that threshold is crossed, the alarm fires. Now what's important to realize though is that some solutions don't offer this capability out of the box. In other words, it requires a lot of front end setup work to get a usable monitoring solution. And I would think that in the time that it takes to set it up, you might be missing some important activity, activity that's causing issues in your environment. Now these alerts will typically be visual alerts, various colors, yellow, orange or red, signaling the severity of that threshold crossing. And that's obviously very important to stay abreast of potential availability and performance problems. But now what if you don't have the solutions user interface open and actively looking at it? And what will you do about these issues? And that's quite honestly often the case, right? It's not going to be all the time that you are able to have a monitoring solutions interface open and engaging with it. Most everyone on the line, I have no doubt, is wearing many hats and juggling lots of various projects and tasks. That's where notifications and actions are critically important to a monitoring and diagnostic solution. For example, a threshold is crossed, an alarm fires, you can get say an email or a text message to be made aware of the issue. Again, when you're not actively looking at that graphic user interface, which is probably more likely than not. Actions can be equally useful. Some monitoring solutions allow for an action to be initiated based on that threshold crossing. So for example, a threshold is crossed, an alarm fires, and you can have it configured to run a corrective script or maybe kick off an SNMP trap to work with, maybe your ticketing system like Remedy or ServiceNow and have that alarm initiate a ticket. Again, these are great ways to be more proactive and stay ahead of issues and be more productive in the process in more of an automated fashion. Baselines. Now, conceptually, we're all probably pretty familiar with the idea of baselines. It's a minimum or starting point used for comparisons or a fixed reference point. And I would say you'd wanna consider a monitoring solution that generates and maintains baselines. Now, why are baselines important? Well, it establishes what is considered normal activity for that time period. That way, it's easier to identify what is abnormal activity and therefore potential issues can be more efficiently identified. So you may find that sometimes the term baseline is used loosely and is really a comparison of an earlier window of time. But that's really trending versus baselining. Baselines can be generated or learned a number of different ways. There can be algorithms run underneath the covers periodically, it may be machine learning, or I've even seen AI being utilized. Now, an added beneficial capability is for the monitoring solution to be able to alert you if activity starts to behave abnormally. So for example, it's useful to be alerted of say CPU spikes to 90%. However, it has more context and is more actionable if you also have the information that for that particular time period, CPU is normally 50% or conversely, CPU is normally 90% for that time period. So that latter example is probably less pressing, right? It may not even be a problem. Rather, it's an expected workload for that time. So again, a baseline can provide more context in the metrics and values that you're seeing. Advisories, suggestions to fix, guidance, all those kinds of things. Now, whether you're new to the field or a seasoned IT professional, most everyone welcomes troubleshooting suggestions. Look for a monitoring solution that offers this as not all of them do. It's best if the suggestions are specific to flagged activity. They're sometimes referred to as advisories or a similar name. And what they'll do is describe that flagged activity, provide some context around the potential issue, and offer suggestions as to how to administer and fix the problem. And oftentimes, as you all probably already know, there's more than one potential cause, and therefore more than one suggested remedy. Now, this is, again, another example of how your monitoring solution can provide efficiency gains. And this particular screenshot shows some examples of advisories. Let's talk about reports. It's important to consider if you need the ability to both document performance metrics and or share that data with other stakeholders at your company. You'll definitely want to consider a solution that offers these capabilities. But there's more to this concept. You want to dig in further and find out if the solution, first of all, offers out-of-the-box reports. These are handy to save time. Creating your own reports can be time consuming. But ideally, you'd want both, right? Out-of-the-box reports for the sake of time. Both, right? Out-of-the-box reports for well-formatted reports to generate quickly, but also the flexibility to create custom reports to address documentation or communication requirements with specific content. You also want to find out if these reports can be scheduled and or emailed. That makes things easier and more automated as well. Dashboards, and what I mean by dashboards, essentially categorized pages of metrics. So for example, a memory dashboard with memory-specific metrics. Now, some solutions claim to support and monitor virtually any source. But here's the catch. Many of these solutions require that you build out dashboards yourself. No out-of-the-box dashboards available whatsoever. That actually caught me by surprise because the next question that comes to mind for me is that what are you paying for? From both a value and efficiency standpoint, out-of-the-box dashboards are something that you should demand. Otherwise, you're not all that far from the build-up option that we discussed earlier, like scripts and so on. So out-of-the-box dashboards are something you should definitely require when looking for a monitoring solution. But having said that, it's even better if the monitoring solution provides a means to create your own custom dashboards. Not unlike custom reports, custom dashboards provide the power and flexibility to build them out with your own customized content, but also customized display of those metrics. So having the ability, for example, to choose from a table versus a graph or a chart or a real-time spinner or a volume cylinder and so on. Either way, out-of-the-box or custom, these dashboards should be considered a step better than reports when it comes to monitoring data. Now, why is that? Most of us are kind of programmed to be able to want and need to share reports, but in the case of monitoring, monitored data is always changing, right? Data may be hours or minutes or even seconds from having new values. Reports are static, which means the report content is going to become stale and often fairly quickly. So with dashboards, the data is being refreshed in that repetitive fashion. So the data is more meaningful and up-to-date. It says real-time as the last time the data was retrieved. So we all know that important decisions are best made when the data is current and therefore relevant. And finally, the ease with which these custom dashboards can be shared is pretty critical. The creation of custom dashboards is ideal for providing subsets of data to different groups in the enterprise. So maybe the storage admins simply need those six critical storage metrics. Maybe management only wants summarized, trended data and so on. Now that can create communication synergy between those groups. So it must be easy to share those dashboards. So how about simply sharing a link to that web-based dashboard? It really can't get easier than that. And that's possible and available with the best monitoring and diagnostics solutions. To round out the session, I thought it would be useful to discuss some common performance problems with Postgres so that you can decide with what and how you'll monitor your Postgres instances. And you can be sure the solution of choice includes the means by which to address them. Now obviously this is a subset of common performance issues but I've included locks, query performance, disk space usage, the concept of bloat, and finally considering administration capabilities. First we'll take a look at locks. Now as many of you are probably already aware, one of the most valuable capabilities of Postgres is its support for concurrent ACID transactions. ACID being that acronym for atomicity, consistency, isolation, and durability. These database transaction properties help verify data validity. It's important to understand that locking can be a common occurrence in active Postgres databases. This is because Postgres uses these levels of locking as one of the ways to safely implement these concurrent ACID transactions. Now that said, managing peak performance includes being aware of queries that might be taking too long to run. In some cases these commands might be waiting for a lock. Helpful information includes things like the process ID, the user, the query that performed it, the query start time, and in the case of Postgres again, if that lock has been granted or not true or false. If it is deadlocked, one or more may not have been granted. So you'll want to consider a monitoring solution that can both identify and alert you upon potential deadlock transactions. Query performance, I think it's safe to say that we probably spend an inordinate amount of time in this area because sometimes it just comes down to those queries and who's running them and where are those bottlenecks. So one of the primary tasks of any DBA is to find and optimize poorly performing queries. It's not a trivial job, it's as oftentimes there's too much data to sort through and pinpoint problems. One angle to take is to find queries taking a longer amount of time to run and or find those statements with low hit percentages. This can be actually a result of long running statements. Now Postgres tracks patterns of data access and keeps frequently accessed data in cash. It's best to keep a cash hit rate of about 99%. And you might want to consider increasing the cash available with a ratio significantly lower. So find a monitoring solution that can both identify and alert you about these types of queries. Disk space usage. Now many things can happen if the database runs out of disk space and really none of them are good. DBAs understand that it's essential to monitor database disk space so that critical business processes are uninterrupted. An appropriate means for monitoring this may be to alert if say the average calculated table space growth for Postgres that rate is going to use up the existing space on the hard drive and say within X number of days. I've included an example or this here really is an example of why it's important to consider monitoring not only the database but that underlying host as well. This is an example of correlating that information. Now as a side note, it's generally not able to be accomplished when monitoring a DBAs environment database as a service. But really the disk space would be managed by the service anyway. To further diagnose space issues, first determine the databases and tables using those table spaces. Make note of those databases and tables growth rate over time to help narrow down and determine which may be responsible for that increased table space growth. Now keeping in mind of course that table spaces can often host multiple databases and tables. Now another possibility for unexpected growth is that the system has not been vacuumed in some time. And this concept leads me to my final two areas to factor in, bloat. So you'll wanna look for large tables and then see if there's a high number of what are called dead tuples. So again, as many of you are probably already familiar, postgres, in postgres there are tuples are essentially logical representations of rows. Tuples are not actually removed when they're deleted, rather they're marked for deletion. And those are considered dead tuples. Now a vacuum is just that administrative process by which these dead tuples are cleared out to remove that dead space from the file. So once again, having the ability to get alerts on your number of dead tuples versus live tuples or index bloat is a common issue in postgres. The ability to be alerted on those kinds of things can be very, very useful. And lastly, administration. To allow for a more seamless workflow, it's ideal to be able to take action or administer items you have identified with your monitoring and diagnostic solution. So some examples I've included here are some of the next steps involved with the use cases we just reviewed. So for example, you have excessive locks waiting. It would be nice to have a solution that allows you to cancel that query or terminate the connection. Experiencing database table or index bloat have the ability to vacuum those dead tuples. Other administration examples include maybe needing to better understand the query steps and how long each step is taking for tuning purposes. If you have that need, generate an explain plan. Now, if you've made changes to the table structure or query and you're ready to test performance, another administrative capability that's nice to have is to reset tracking statistics to display that new performance data. Now we covered quite a bit in this session. I hope it proved helpful and perhaps provides you a checklist of sorts of the important items to consider as you plan your environment's Postgres monitoring strategy. So I appreciate everybody's time and attention today and we certainly have time for questions. So one of the questions asked was, is there a product available from Quest? And there is and that's something I can speak offline with you about. I know that Postgres would like to keep these outside of the scope of particular products by one of the vendors. But yes, as I mentioned at the beginning, my primary job is to support Quest monitoring and diagnostics solutions. Couple of solutions called Foglight and Spotlight. So along the same lines, is there an all-in-one tool for this? And I guess I wasn't pulling the wool over anyone's eyes with my screenshots. They are indeed from Quest's Foglight solution that has all of these capabilities, yes. Just one added note there. The Quest Foglight solution is a cross-DBMS platform solution. So not only will it allow you to monitor Postgres, but other DBMSs as well, as we found most all environments now have multiple platforms. So maybe Postgres, but also maybe Oracle, or DB2, or Microsoft SQL Server, or MySQL, or MongoDB, Cassandra, and so on. Okay, well, again, before you jump off, I wanted to thank you again very much for your time and attention today. And again, I hope the content proved helpful. And thank you, David. This was fantastic, really wonderful presentation. I wanna thank all of our attendees as well. So regardless of where you are, I hope you have a good morning, a good afternoon, or a great evening. And I hope to see you on the next one. Cheers, thank you. Thanks.


Hey, this is Bill McKibbin. We're backstage before the Philadelphia Roadshow Saturday night. Do the math. If you listen closely, you can probably hear the band opening up the show. And I'll go out in a minute. But before I go, we're just asking everyone, if you're in reach of the DC area tomorrow, please make sure you're there for this rally. The first demonstration of the Second Obama Era to remind him that we haven't forgotten about Keystone for one minute. It's going to be important, and it's going to come with a big, interesting announcement about future actions. So get there, if you can, tomorrow all the details at 350.org. Thanks.


Welcome. This is Melissa Armell with the stockswush.com. I thought I would do a brief video here very quickly on Netflix. It's 601 Eastern Time. Netflix. Oh my Netflix. Love of my life here. 70350. Netflix is trading out after hours. It is gapping up on a news announcement of the stock split that they're gonna do on July 14th. The earnings are the 15th and I and I called this to happen. If you had taken a hundred shares of Netflix on my swing trade letter call in January here on a day that the gap didn't work right as along in the day but it was a golden gap. If you had bought a hundred shares of that you'd be up twenty nine thousand five hundred dollars right now or three hundred dollars right now and running still going. Dream target 750. I don't know if it'll get there in the next three weeks before the split happens but it very well could because it's getting bought and it's gonna keep getting bought and I actually think it's I think I think it's gonna go there. I think it's gonna go to 750 because it's the July 14th is three weeks away and this is gonna keep getting bought before the split now that they even know about the split and now it's getting bought even in the announcement of the split it's not gonna stop getting bought okay it's going to keep getting bought and this is amazing and I called it. What a great eye. So let's just take this off I mean just geez I I have such a gift to look at this stuff. I really I feel very lucky. I have a gift I I see things in charts that aren't even there and I see them before they happen and of course I see them when they happen but I I also see them before they even happen and that my friends I cannot explain and that is a gift and when I say no chance of failure I don't I don't know what I see but I saw it in this and I and I saw the numbers and it's hitting them right now and I saw it in January. The day of this gap I made the trade and said 700 750 and it's there and none of these numbers are on the chart and again I don't have access to any research reports or any of the stuff that any of these institutions are doing and I guess that's what's really amazing about it and that's what's so amazing about it. It's the power of the gap but it's really that I know how to read price action so well from trading gaps for seven years and and I think that's why I see these NCOS why I see something way in advance before it happens how I can see what something's gonna do in the day and then a long term how I'm able to read the market I'm reading the money in the charts now so well for seven years that I I can see things before they even happen in gaps because I'm so good at reading gaps. This is amazing I I'm ecstatic. So if you are interested in signing up for the swing trade letter you can email me at Melissa at the stockswush.com but the real power and what I know is in the golden gap course that I teach how to read gaps and how to read what the gap is going to do. As a day trading for the longer-term trade as well if you want to take it overnight and this was an amazing call. The next golden gap class for July is July 11th and 12th. If you would like to sign up or register email me at Melissa at the stockswush.com. Have a wonderful evening everyone.