Okay, after that short delay we'll get started. Shoaib talking about tuning PostgreSQL. Yeah, so before I start I just wanted to get some idea about how many of you guys are using PostgreSQL in production? Oh, that's great. That's great because I don't get to see that kind of feedback anywhere else. So yeah, that's great. And how many of you tried tuning the PostgreSQL server and found it really hard to do? Cool, yeah. I'm sorry? Oh yeah, that's what I do. I'm a PostgreSQL consultant and a worker for Jutsu. So we do the same thing as well. We help customers with tuning PostgreSQL servers and giving support services as well. We do 24-7 support and business support as well. So yeah, yeah, it's over there as well. So we'll be looking at basically going through a few things that we can cover in the next 20 minutes because tuning the database server is a very big topic. So we just be covering a few things because we can't basically go through everything in the 20-minute time. So we're looking at procedures that we can use for diagnosing performance problems for the PostgreSQL server and then how do you benchmark your database server performance and then a little bit of our database monitoring as well. So let's starting with the procedures that you usually carry out to diagnose performance problems. First of all, you need to identify the areas. So I basically cut it down to starting with doing the application analysis, looking at the SQL, looking at the memory usage that involves the buffer cache that PostgreSQL is using and then looking at the storage setup that you got file system and the very famous PostgreSQL.com file that people found really hard to tune. So starting with application analysis, the first thing that you look at is how the application is interacting with the database, whether it's using it's basically reading large amounts of data, if it's writing large amounts of data are you using any ETL jobs, using any analytical queries, because they basically all really matter because when you're tuning your PostgreSQL or Confile you really need to think about all these kind of things before you set up those values. So yeah, you have to be really careful with the kind of way the application is working and that's something that I've always found that the SIS admins had a really hard time tuning these things because they don't really at times know how the application is interacting with the database server and they've given this job to tune the database server so it's a very hard job for somebody who doesn't know how the application is interacting with the database server and you're trying to tune the database. The next thing is SQL like finding what are the problematic queries that are taking a long time because that's the first thing, that's the starting point basically to find out those queries that are taking the long time that they're executing for longer months of time. So a best way to do that is install a query analysis tool on top of your database server and what those two do is that they basically look at the database server log files and they can generate some very nice reports on the basis of data that they can gather from the server log files and a couple of them I've put them in the presentation as well EPQA is the one that I really like because it uses Perl so you don't have to install anything else but if you're using PG4 and you have to install PHP as well because it only works with PHP so I usually prefer using EPQA that's much nicer and it gives you a very nice report and once you've found those SQL queries that are problematic the next step is using Expand and Analyze on those queries. Has anybody over here used Expand and Analyze and found it really hard to understand the output? Yeah that's exactly the next thing so there are some nice tools that can help you understand the Expand and Analyze output so I can explain those tools after the presentation if you really want some more data on that because we can't really cover everything about the Expand and Analyze output in these 20 minutes so yeah but the next thing is you will look at the plan and see where exactly in the plan are the parts which are taking the most time and then start debugging those areas. Another thing to note about Expand and Analyze is that never try to use Expand and Analyze with the DML type of queries because if you're doing a simple Explan that's just giving the estimates but if you're doing an Expand and Analyze that's basically executing the query as well and then it's giving you the actual times so if you're doing a DML type query that's insert, update, or delete it will in fact run that query as well and so the changes are all done on the database as well so just be a little bit careful debugging the DML queries the next thing to look at is memory usage first thing you need to gather is the size of database if it is small enough to fit in the memory or if it's not if you can't really fit it in the memory if it's like say it's a database or a one terabyte database and you can't get that much of RAM on that box then you need to look at getting faster disk to basically nullify that effect and other than that you should be looking at the buffer cache usage Postgres uses both OS cache and its own buffer cache as well it's a little bit different than other databases something that I've noticed with Oracle DBAs is that they would think that giving all the shared memory to the database will get better performance but with Postgres it won't give you the same kind of behavior so you need because Postgres will be using the OS cache and the buffer cache together so at times you will see double buffering as well but a Postgres manages it very intelligently so you basically have to look at how a Postgres is using the buffer cache in order to do that Postgres comes with PG underscore buffer cache counter module Has anybody used counter modules over here with Postgres? No? So counter modules are the contribution modules that come with Postgres and there are RPM and DB packages available for those contribution modules so as soon as you install them they're all installed within the Postgres skill installation and you just need to run a few SQL scripts to get them all going so PG underscore buffer cache is also one of them and that helps you look at the buffer cache like what exactly is in the cache right now and how the table is using the cache that is available for Postgres and you can see you can basically relate to the most used tables and see if they are being cached properly or not if they're not properly cached there's something going wrong over there so that's how you basically look at the memory usage for the Postgres database server so if something is wrong you need to look at increasing the shared servers for Postgres server or looking at how you're using the OS cache Next thing about memory is looking at the query plans and looking for anywhere in the query plan where it's using external disk because Postgres uses RAM for doing sorts during the query execution so if you see a sort using an external disk for doing the sort that's a terrible thing for the query so keep a watch on the query plans and look for lines in the query plans where it says external disk sort being used because if it is using that then that's a bad sign and that usually happens when you don't have enough memory available and Postgres has no way to go about it instead of like it just goes in using the disk and that's like using the swap. Next thing is looking at a storage so what type of storage setup you're using you can use a data data storage or SAN. I would always recommend data data storage because I've seen, I've had some terrible experiences with using a SAN because we had a customer who was using a NetApp SAN that's very good if you tune it properly but they had one big aggregate that was using 48 disk and they didn't give the database a dedicated aggregate and everything else like the exchange server, the database server, file server everything else was using that same aggregate and the database was always competing for resources and it wasn't getting all the resources that were required so we ended up going towards a cheap data data storage setup so instead of giving it the share from the SAN we just went with the data data storage and that usually gives you better performance because you know that the database server is dedicated using that chunk of storage. The rate setup, I usually recommend rate 1.0 because doing some benchmarks with rate 1.0 and rate 5 we found out that if you are using a right heavy database rate 1.0 will give you better performance because with rate 5 you are storing that extra parity information so that becomes a hit on the right performance so we usually recommend going with rate 1.0 Other than that, look at the iostat outputs from time to time. I would have customers set up scripts in Nagios and then do trend analysis on those iostat outputs to see any spikes that they can see while the database server is doing the normal activity and if you do see them you need to look at the bottlenecks where are those bottlenecks and also look at the queue sizes as well. If you see the queue sizes going abnormally when you relate them to the number of disks available then there is something wrong and there is some bottleneck with the IOS somewhere so you need to identify those areas as well. And then the rate control settings, usually these days rate controls come with right back cache enabled but you need to verify if your rate controller is using the right back cache and they usually come with battery back cache these days so just make sure that your rate control is battery backed as well and something that I've seen people usually ignore is that they don't monitor their battery health. They think that they've got a battery backed rate controller but they don't monitor the battery health so when you have a crash your battery is not in a good health so it won't be able to do a proper rate crash recovery even if you had a battery backed rate controller available. And then Postgres has got table spaces so that can be very useful if you are trying to dispute data across different storage locations so a good starting point is separating your indexes and your table data onto different table spaces that basically helps you with the IO loads and then our transaction log files they should be on a separate storage area as well other than your data folder that helps with the IO performance especially with a right heavy database file system. Everybody has its own preferred file system but I usually go with XFS that's what we gathered after doing some benchmarks against EXT3 and the reason for that was that XFS had a better journaling system because it only journals the metadata it doesn't journal everything else so we found XFS to be much better than EXT3 on doing benchmarks against Postgres and XFS is much better with bigger files as well and each Postgres data file can be up to one gig in size so I know everybody has its own preferences about file system and I know XFS doesn't have a lot of tools available that EXT3 would have but it's your own decision you just need to do benchmarks as well but I found XFS to be better than EXT3 something to note with XFS is that it comes with barrier support enabled so it would be a good option to use no barrier when mounting the file system if you are using a battery backed controller because if you are using a battery backed controller then there's no use of using a no barrier support in XFS and then comes the famous Postgres to log con file there are a lot of parameters that you can tune in that file but we can't really cover every one of those parameters in the timer located so I'll be just covering a few of them which are very important first one is shared buffer this is the value for the database so Postgres basically uses that cache to do read writes and it stores important information in this amount of cache and this basically is a chunk of memory that is taken from the shared memory and it's allocated as soon as you start the database server so Postgres starts using it as soon as the database server starts a good starting point for setting up this value is use 25% of your available RAM don't give it like the 70 to 80% of your RAM just like the way you do in Oracle or other database servers because Postgres is like a big shared buffer you can get into buffer log contention problems if you have a really big buffer cache so again use PGNOS for buffer cache contribution module to monitor your shared buffers and see if you really need for the tuning for the shared buffers or you need to cut down the value of shared buffer this thing is effective cache size that is not the value that is that is not the amount it basically is taken again from the RAM but it is not the memory that is allocated to the database server right on the database server start it's just a value that's used by the QT planner when it is picking up an optimized optimal plan for the QT execution so basically it is the database server sees this value as a total amount of OS cache available to the server so it will look at this value and will get a proper plan according to this value so if you have a bigger number for this value it will be able to pick up a corrective QT plan using a proper index and starting point for that is start with 75% of the available RAM and you basically take this number out of getting output from free or top and looking at the numbers for free and cached and free and cached so you just start with 75% and then monitor the QT performance as well next thing that is very important is the work map this is the amount of memory that is used by sorting operations during the QT execution so basically you try to avoid as much just sort as possible and a good point to start is look at the explain analyze output and with Postgres 8.3 and above it shows you whenever the QT is using this sort so whenever you see something like external merge sort or external sort in the QT plan you know that I don't have enough work map available so I need to raise up the value and the good thing about this setting is that it is session based so you can set it for a specific session and that session can use that amount of work map you don't have to set this value and restart the server to put this value in effect so you can just use it on a session for a specific query so like the query is where we are doing we are basically working on large amounts of data we use the set of the work map to a high value like in multiple gigs of RAM and then we run that QE so that the QE can use that amount of memory. Next is maintenance work map memory that is used by the DDL operations like the create index operation, re-indexing the database or altering the table to add a foreign key or all the other DDL operations use this maintenance work map again this is session based so when you are doing a bulk load job or ETL job and at the end of it you want to create an index you basically raise this value to a very high number and just create the index to be able to use a lot of memory. The next one is auto vacuum that's a very important saying so by default it is enabled on Postgres 8.0 and above and it should be let enabled because if you don't enable it that means that you can end up having database blots which is not a good thing so what it does is that it looks at the threshold values for each table and those thresholds are like for analyze they depend on the number of when you have a specific number of inserts on a table auto vacuuming process will go and try to do an analyze on that table and the same thing goes for the vacuuming as well as soon as vacuuming auto vacuuming thread finds out that a certain number of updates or deletes have happened on the table it will go and try to vacuum that table again you can find the threshold values by analyzing your this is a very useful view in Postgres that is called PGSTAD user tables so that gives you the number of inserts, updates, deletes for a specific table so you can look at those numbers and find out the threshold values that how many inserts or updates or deletes you are getting every minute or every hour and with 8.3 a very nice feature came in which is we have worker threads available for auto vacuuming so before that auto vacuuming was a single process so only one table could be vacuuming only one table could be vacuum at one time but now with 8.3 above you can have pedal processes doing vacuuming and analyze on different tables next is default statistic target it's this basically value sets up the amount of sampling you need to do on specific table when analyze runs so analyze is a process of collecting statistics for a table and those statistics are then used for getting optimized query plans so this value by default is 10 in 8.3 which is a bit low it should be set to 100 at least but again it depends on the kind of queries that you are doing in your database server and looking at the query plans if you think that the query plan is not what you really want it to be then you need to raise up your stats because the Postgres server is not able to get proper stats next is checkpoint sequence again you usually set it to a very high number if you are getting bottlenecks on the IO especially when you are doing large amounts of write we are running a bit short in time so I will just cover the next slides quickly next is benchmarking I used to use Bonnie++ for doing benchmarking on the Postgres database server and the recent version of Bonnie++ is really useful iPhone is really useful the one after 1.96 I guess they are going to release the next one very soon so that is 2.0 it also gives you lag times as well and it can do some tests that are really database oriented so I have used that in the past and it has really helped me in finding the bottlenecks with the Postgres performance so keep on doing the benchmarks every now and then to find out how the behavior is changing and then for the database server specific activities you can use pgbench to find tps transaction per seconds and see how the database behavior is changing from time to time monitoring use the normal Unix commands like iostat, dstat top and keep on putting them in a database and then try to do trend analysis on that and then the last thing is checkpostgres.pl script that is a Nagios base plugin it is a very useful plugin if you have a Postgres database server which is in production because it can automatically check for the bloats it can check for the checkpoints it can check your free space memory and it can alert the admins about any kind of problems beforehand and then you should be using a combination of Nagios or tools like ganglia so you can get proper graphs on the trends for your database server performance that's about it any questions we don't really have time for questions because we're running a little bit late but perhaps you can talk to them after the sessions if you've got any questions just tell me what thank you


you guys huge low bun um and it's messy all I did was I was supposed to be um hold on this is my hair from yesterday and I got lazy did two flat not two two twists and all I did was pull this back yeah she is serving you messy mom yeah yeah sorry I always cuz I have asthma it is Tuesday and I am about to fix me some breakfast just like some waffles egg or waffles I know not good for you and some strawberries because I have an appointment later on this morning with the nurse at my surgeon's office because you guys I need to turn that ball your mouth my phone I'm getting some discoloration on my breasts those you don't know I had a breast reduction in May of this year I went from a triple D sometimes double E depending on the brand and the brand of the bra to a full C a man girl 38 full C and so what's the point you know it's so funny is that my minimizers are apparently so well that people who see me like my girlfriend who saw me yesterday she's like you look really good you've lost a lot away and I say girl it was my titty I got a breast reduction she's like really she's like you fly it makes me look so much smaller even when I went back home and I had one I had one aunt who just kept looking at me and finally I let her know I whispered to her to the side she's like Vibb that's what it is they call me Vibb back home she's like Vibb I've been looking at you child yo your breasts so good yeah so anyway I got some rice over her boiling I need the whole show so what's the point I've been getting discoloration which you know from my Google research and looking at some other women is it's common or not uncommon I should say because it is Tuesday I'm trying to cook my husband some lunch today because he didn't get much tomorrow for work and get much tomorrow so I'm just gonna whip up something some wild rice and have some black rice in there too that I've had in there for a couple of weeks and I'm too afraid to try it has anyone tried black rice wild rice includes brown well the world rice mixture I has half includes black rice but this is like pure black rice I'm gonna wait till I have some time to make that so I can experiment so y'all been I've been back to eating carbs not to say I had reduced I mean I have completely stopped but I have reduced it but my thing now is coconut rice when I tell you that it's some good eating girl until what I do okay this is what I do I make my rice and I've gotten to the point to why I make my rice like the Latinos make it I make it in a skillet and just steam it Africans and West Indies would we typically use a pot but I use I do like the Latino so girl maybe I'm a black Hispanic and I don't know it so I use a skillet and once it's done steaming and all that I pour in like one fourth of a cup of unsweetened coconut milk put a little bit of cilantro on top girl I could eat the whole pan if no one's watching all right y'all it's time to go to the appointment look I didn't have any coffee today I just decided not to sometimes when you have something like the anxiety like I'm going through right now this year this not this year girl every other year around this time of the year I get seasonal seasonal you do to you know stuff and I do have a video coming up I think I'm gonna go ahead and edit that and post it in a couple more weeks y'all can't see me hold on but anyway girl I didn't have any coffee today cuz I sometimes I think that the caffeine can make it worse a I did not have any coffee and so far I'm still feeling good I need to go ahead and take my supplements and medicine besides that CBD oil let me check something real quick you guys I before we leave the place is only about 40 minutes away like but I you never know accidents or whatever um who's I gonna look up okay I just posted on YouTube I really do love this new future with YouTube where you can as a content creator where I can post either a poll ask you guys questions you guys can response I like that being able to interact like that so I just posted whether or not you guys wanted me I should have done a poll but I didn't I posted whether or not you guys wanted me to review this hairdryer let's see what the comments say okay six comments so let's see yes please I've been looking at hairdryers both heat and non-heat you know what you you you doing the most maybe I could do heat and non-heat on maybe I can do that then my hair would be messed up we'll see yes please hire the comb attachments on 4C yes please yes hi y'all so I'll go ahead and do it um you know what I'm thinking about our wedding anniversary I it's not till next year April was like tax day or something April 15th I may recreate my entire wedding style put on my dress and everything y'all like seriously I'm thinking about doing it I've seen someone else do that and I thought it was really cute so I'm thinking about recreating the hair and the makeup that makeup slate too that makeup was really beautiful I make up for my wedding but I will go ahead and recreate actually that hair is what I'm recreating now this week 50 and get your together so yeah I haven't had any coffee so I'm but I am drinking peppermint coffee peppermint tea you know what she has is big-ass blow-up and the damn snowman is on his hands and knees with the butt up in the air yeah I told you my neighborhood be doing the most for the holidays yeah y'all was thinking about stopping by JB school and dropping him something off you know cuz sometimes you got lunch with them and I think that may make it worse he that may make it worse I'm not gonna do that so yeah like I said it's just a phase but I'm just I'm just surprised I'm surprised that even another parent was like JB was crying I said yeah he's like JB is typically the one that's consoling other kids I said I know you telling me I know he was like wow I would think he would cry I'm like thank you I know hey you guys so I'm here my doctor's appointment I'm a little early so we're gonna do like a little quick chit chat then I mean it's gonna be like less than 10 minutes girl and I'll give you guys the timestamp so that way those of you who don't really care for my vlogs you can get to the you know chit chat or maybe I'll put the chit chat before so girl let's talk real quick yeah I got like eight minutes I'm gonna talk about what's going on these YouTube streets you know TV I've been watching and just it's something random comes up in my head we're gonna talk about it so he's driving way too fast I should guys like this place no girl what you gonna do with that I have been watching a little bit of just random people having you know really watching a while and I was watching a video from naturally fashionable who her and her husband have been living in Kuwait for a while and this video was how long let me get some tea cuz my voice hmm first of all I like her because she is a no-nonsense and she was reading people in a very PC manner in a very southern hospitality I'm shading you and you really don't know um excuse me the video was about Jill Scott who was those you don't know Jill Scott is a well-known artist music artist what is a Neil soul which I like some of Jill's music and it's been a while now a couple of weeks ago Jill Scott was pretending to be performing oral sex on her microphone so youtuber naturally fashionable made every you know basically talking about how war has class gone you know and that it was inappropriate for Jill Scott to have done this being that she's a mother to a young child and she's an older woman and now I do agree with her on a lot of talking points that she brought up I really did now I did not watch the whole video because they were dragging her in the comments when I tell you they were dragging her they were dragging her but this is the thing you guys most of the women who are making those comments are young girls young girls who probably don't even have children and not to say that you can't have an opinion if you don't have any children but your perspective on things and this is coming from someone who felt like I could say anything about you know when I didn't have kids and it totally changes once you have a child and it makes you think okay maybe I should do it in because quite as it kept sometimes I be wanting to do videos on a little rated R rated PGX but then I think about it okay I am a mom I also have to think about my brand that once you put something out there it's out there so do I is that a ref do I really want that to reflect me okay no I don't so we ain't gonna go there we ain't gonna talk about anything I think that our morals are out the door you guys I really do now yes people have talked about sex before cuz I saw someone made a comment you know this is nothing new you know look at Patty label songs and you know Tina Turner songs they were talking about sex back then but they were using what metaphors it wasn't all out there it wasn't I don't think I ever saw Tina Turner using a microphone and pretending like it was a damn penis yet no not on stage no but now yes there has been R&B artists doing stuff stuff that are sexual in the 70s let's just put it out there but that's what their concerts were known for and I know that Joe Scott she has some sexual explicit songs but to do that at a concert I don't know y'all first of all cry is the cap she wasn't doing anything extraordinary to me so I was like okay well where's the well where's the magic at I don't understand you know everyone's going crazy I'm like y'all do I think it was age-appropriate there are older women that have oral sex so yeah but I'm not like a huge Joe Scott fan and so I'm not of you know I'm not a fan enough to be offended by it you know so anyway those of us who follow Justin J we know by now that he has been diagnosed what he revealed a couple of weeks ago that he is HIV positive and you guys I have her had a hate-love relationship with Justin and I've mentioned this before I am subscribed to him and and it's all it's all for me personally with Justin and a lot of these controversial youtubers when they go back and forth from bickering but there was a point there where I felt a lot of people were ganging up on him and I'm gonna name drop it was your James Carwell it was Sean Bradley it was what is his name one of the glasses I don't I'm not subscribed to him I felt like it was just a bit ganging and I felt like it was bullying and so I was a little sympathetic towards him was like oh and then I also see where he's come from I've seen the growth so when I saw that video and he you know he was in good spirits and sometimes you have to smile through the pain you know and he said how he's going to use his platform this is what I am wishing from him and that what I would hope from other people who decide to use their YouTube channel vlog whatever it be I hope that we get into this is how to prevent this instead of okay this is what we do now because I think that's the real way to make a change is to prevent other people from actually contracting HIV or A you know teach our young children young adults on what not to do what behavior we should avoid you know cuz it's so much easier to now say okay now this is what I'm gonna do now that I have this disease you guys and he may do that he may you know like I say use his channel to educate people on the things not to do so it is really unfortunate you know yes treatment is out there but having a disease like that you know I don't know anyone personally that has had HIV or AIDS but for what I can tell from other people that have had it is not just you know taking your medication it's like a overall health struggle and a lot of these immune suppressant diseases come with a plethora of symptoms oh gosh so yeah my heart goes out to him and I was so heartbroken when he and but I was it was very courageous of him to have done that and I think regardless of what you stand on as far as what you view of Justin you have to admit that was very brave of him to have done that I know there was room was going around that well someone was about to out him regardless of that regardless of if he was on the verge of being out it was still brave of him to come on cam and admit to that so you guys I'm about to go into my doctor's appointment real quick and yeah I just want to say that besides that I'm catching up on the real housewives of Atlanta I'm done I always say this every season but I'm done with candy using Porsche as her storyline I'm sick of Porsche I just can't believe that Porsche is in her what she's in her late 30s acting like she's 20 something years old I mean tat getting matching tattoos with the hot dog guy her now her fiance who she's also pregnant by and her mom act got miss Diane is a geriatric thought I'm sorry I had to talk about somebody mama like that but she's pushing Porsche into this having a baby and getting married and I'm like she's known this man for a few months all right y'all I'm an out of my doctor's appointment and now I'm just sitting up here girl girl a $50 copay just for her to tell me I need to start put more lotion on my titties seriously I know I'm sorry I have basically have eczema on my lord have mercy so anyway what was I talking about okay so real housewives of Atlanta I can't do it I just gotten to a point to where I'm not even watching the full episode because I just I don't know the only storyline I'm slightly interested in is Evers is that how you pronounce my Eva I know she was that old y'all not she's not old but she's only a year younger than me she's 37 why does she act so immature she doesn't necessarily act immature but she acts a lot younger than what she comes off I thought she was in her late 20s early 30s a girl between her miss Diane Porsche's mama I feel like I feel like candy I feel like candy is the type of person who doesn't really have she doesn't have true friends she knows a lot of people she has a lot of business acquaintances but I feel like she's the type of friend that can get on your damn nerves if they're why because she's complaining about the same thing over and over you either do something that you hush up like I she would be that annoying friend for me that I would love from a distance you know love from afar because you keep talking about cuz I could just see the expressions on when she was talking to Don one and Todd about Porsche I could see their experiences like not again girl you still talking about this that's how they look to me I had finished up with how to get away with murder girl that fine Frank I cannot wait for walking dead to see fine Frank the actor who plays Frank on how to get away with murder is also on fear the walking and I told you guys about that a couple of blocks ago again one of those shows what I'm always like this you guys there are certain shows that I do look look at and that I watch from like seasons and the walking dead was one of those that I was watching from season one then I stopped because I started having nightmares but then I started back up but this season is ever since Rick got flown away I don't like this season that much but girl I watched the last episode and I was I don't know if I want to be able to do this because I'm like the zombies are talking of the zombies talking there is not the zombies talking there's another group of people wearing zombie skin or some shit so yeah I can't really watch that anymore so it's really not too many shows that I'm watching I did download the Brit box I love me some British TV and I bench watch Vera which is a very good crime show I told you guys the British does crime very well but now I'm watching Vera someone uploaded the they uploaded the series or the seasons on YouTube so that's for free so yeah you guys not a lot on TV like I said some of the YouTube videos I did catch up on a lot of them I not I do see quite a few quite a few of people doing vlogmas I really do like a natural hair for you I believe that's her YouTube name I love the sisters she's very I don't know how to put it I can't put her in a box and I like that and I believe she's a type of person she doesn't want you to put I can't categorize her channel or her personality for that but she's very straightforward transparent and I do like that about her some of the other people I was talking about I had to unsubscribe for and I'm gonna name drop because this is who I am a Christy mom for you I had to unsubscribe from and Olivia with the living with the webs I had to unsubscribe from them I'm not gonna go get into it just I'm not watching them what really ticks me off though not nearly ticks me off but you can unsubscribe from someone and then their videos still come up and they're suggested or recommendations and I'm like what for so I'm not gonna do this so Christmas is around the corner what are y'all getting for me so look I know I'm not I know that I'm not the only person that buys himself something for Christmas girl I already started you hear me I already started one of the things I definitely want to get is a hair steamer and once I do get the steamer I will be officially reviewing it now I am up to the point to where right now I am deep conditioning once a month with the steaming I want to do that once a month so I will more than likely when I do my deep conditioner I will be steaming with it because the only time I've done a true steamer with with an actual hooded steamer was women's or let did it and let me tell you my hair felt oh my gosh you guys my hair felt wonderful and been out here in the area it is extremely dry and Phoenix hence my my dr. It is it's really dry here in Phoenix so it really does help if you have a steamer I think it would help even if you're not in a area where this dry climate but be not in the desert I live in a desert like no I live in these called the Sonoran Desert and yeah so yeah I'm good definitely gonna buy me a hair steamer I'm trying not to buy any makeup however I saw a LA girls palette and I'm a type of person why is that flag half mass oh because of George Bush why did I think he was already dead y'all like so I knew that his wife passed away by for some reason I thought that George Bush senior had passed away a couple of weeks after that I don't know why I'm like what he been what I'm anyway I'm sorry the flag is half mass in front it's always wondering why and I'm gonna send it that they gonna postpone our mail tomorrow because of his death I'm like what I might know my camera to get back I mean rest in peace and honor glory to God I'm like you know so much has changed when it comes to these holidays and you know sometimes you guys I know there's like a really big commercialization of it especially here in the US I mean they start putting this stuff out this year they started putting the holiday stuff out in late August and that is absolutely ridiculous and I've tried not to fall into the traps of all that this is what I saw until I was bring up one of my neighbors has one of those old school like 80s nativity scenes like that though plastic ones and with the wise man and Jesus of Mary and I seriously want to go whenever I see that I'm like and they're all white I know how I feel about this you know you have the the old school nativity scenes and every you know the wise men are all whites you know nowadays I will say nowadays I've been seeing proper representation of the wise man being of color at least really or at least one of them in real chocolate girl they they make them real chocolate to make up for the other 210 ones try not to decorate with that type of stuff because I don't see it being a proper representation of the way things truly were I don't even I think about it I don't even go out my way to have anything with Santa Claus on it and for those you don't know there are other characters when it comes to Christmas you know what I mean and what country is that word one of the characters is some short little black leprechaun named Pete or something Pete or Patrick but yeah girl you got like black Pete show and I first saw pictures of black people all those white people running around with black faces I don't know what country that is in in Europe but they have a character called black Pete there's crumpas there's other character due to pagan ties that are tied to Christmas which is why I'd shot jay we can take pictures with Santa Claus but I don't go out my way and be like oh let me get you these Santa Claus stuff girl no we ain't doing that now I'll be looking at the figurines on that black Santa the black Santa is cute but I'm not gonna buy it unless it's like 75% off even then I don't know anyway all this is all over the place I know so we're gonna get back into the vlog but I want to put a chitchat in the in the middle of this okay hold on y'all let me see y'all I have to start eating better I had water burger yesterday I've been eating out a lot more which is not good I'm just I just real quick went back home just because I need to go back inside this is personally go to my work ooh deeper than her just upload y'all deeper than hair you two were deeper than hair she can slay some hair now what what the hell's going on all right y'all yeah I thought I was so good to hang out with my friend and I like I said in my last vlog I really need to start doing that more often and if not do that have some type of adult time which quite frankly I have been you know every two months I've been either having lunch with a friend or just having some adult time with other adults so yeah that that hasn't been a problem but I guess my thing is that I need to hang out with my friends that are here more often locally more often um alright so I was gonna tell y'all I completely got sidetracked and forgot I have an event I didn't forget but I haven't been preparing for the event that I'm going to be vlogging this coming Sunday and so Ms. Ehrlich just an honor reminder she's like get your get your phone charges girl you ain't got to tell me get your phone charges get your business card but why y'all I have or had two types of business cards I have a business card that is you know for me being a beauty influencer I don't want to say that youtuber I have that type of business card and then I had I'm sorry I'm trying not to judge people and judge young young people but this mom she has a little girl around JB's age and she is puffing on this cigarette like you are really not only are you doing yourself a disservice but your child my father quit smoking when he had kids it was hard but he did it anyway sorry yeah my brain it's how my brain works so I have two types of business cards let me put this up here and I have to run in y'all I have two types of business cards I have my business card for when I was selling my hair on hair oil and I was also at one point I was trying but nobody wouldn't do this I was trying to do natural hair consultations I mean I spent so much time creating a form compiling less I mean I literally spent months month at least half a year on research for natural hair consultation but no one's gonna do that because one there's so much free information out there why would you go to someone for natural hair consultation and I know Ms. Urlet try and she's she has some ideas surrounding them I'm not gonna go into detail because she may not want that information out there but I did approach her and let her know that I think we should co-app and do like a series of back-to-basics and back-to-basics deep conditioning back to basics detangling and have her do my hair you know what I mean y'all but get very detailed and it would be specifically for category four hair excuse me I'm spitting boy for hair and this is Ms. Urlet's passion she loves hair she's been doing here for 25 years or something like that and it's it's interesting coming from she's someone who actually watch YouTube and watch youtubers she sometimes comments on things that youtubers do because those people don't have the knowledge when it comes to hair and texture you know what I mean hey y'all home now I'm gonna divide up these vlogs because I've already uploaded two blocks for y'all this week and I really really don't feel like editing any more vlogs to load up for this week because I have two hair related videos to record film and of course I have the event I'm gonna be going to and then we have a lot of stuff we're doing over the weekend that I'm gonna try to film a little bit there so yeah when you have a lot editing is the hard part so I'm not gonna have time to edit edit is what I'm saying on Saturday karate was canceled the guy canceled karate lessons which is fine but JB goes I try to have him to go three times a week but since he canceled yesterday I mean sorry Saturday he's gonna go Thursday and Friday which is tomorrow the next day and thank the Lord his school since I noticed it was basically like we're gonna be offering child care services during the winter break I'm like amen so I call same day and I was like let me go ahead and sign my child up so out of the two weeks I just signed him up for four days because my husband's gonna be off all that week I'm gonna be taking off the week before two days and then into Christmas those first two days I have off but so I was trying to see if I could you know find some other parents to do a play day but people have plans and that's why I try to tell my husband I'm like again it's it's really doing you know our family in this service being away so far away from our family back in Texas because typically around this time you send your kids to the grandparents house right so they go to the grandparents so they have some type of family vacation and my husband you know he's off for Christmas but it's just JB night for the next week and a half and I'm like it would be it would be so nice to be next to my family because my mom is gonna be off you know she usually takes off you know to be next to my family I'm gonna try not to be that way y'all trying not to think about that because I was starting to go down that path those you don't know I don't live we don't live anywhere near our family everybody is back in Texas includes including my husband who has a lot of family in Dallas so we don't have any family here no close no close close friends you know like I was saying earlier I haven't seen some of my friends in four or five years the only close friend I have that it's almost family is Ms. Wanda I know she's gonna be busy with her family and quiet it's again I don't like her sister and she knows I don't like her sister so we don't really I don't reach out to her to do families type things around the holidays because I can't stand her sister and I've got to the point to where I can't control this when you say some dumbass shit in front of me one thing I'm also gonna do you guys like I have briefly mentioned I'm having some issues with my laptop these dang on computers like honestly these computers now have a shelf life if do they have a shelf life they only have a life of like five years so you spend over a thousand dollars for sometimes less than that my Dell raggedy I still my Dell which costs $800 didn't even last me a year that's a lot it lasts me like 13 14 months this laptop I got in 2000 2016 and the keyboard is dying and so to have it looked at at Apple will be $100 and then to have it replaced we're probably looking at around $300 $400 total to have the keyboard replaced now I was reading that I could do it myself you know but the pain is that there's like 20 plus of those little bitty mini screwdrivers that you have to use I'm not doing that I don't have to deal with this laptop anymore so I think one of the things I'm gonna purchase with my income tax is an iPad you can because I use my I only use my laptop for editing videos that is it a hell you can edit videos on an iPhone now as long as you record your your media on your phone there's tons of people who record edit and upload on our iPhone but I don't want to do that because I have some extra stuff I like to put in my video so my husband bought an iPad this year he spent some coins though he yeah I just want a basic iPad with the keyboard which should be no more than $500 he spent like $1100 on his iPad hey y'all this be the last week where I'm vlogging on this old camera look JB's like that's my camera I'm like I know baby so Canon has already shipped off my camera so I should get it by Tuesday and just a heads up you guys I'm doing a lot of vlogging now since I'm not doing vlog miss technically and I want to I want to hold off till I get my camera to do my hair videos because it makes a big difference I think I am gonna push out that chunky twist video out though chunky twist video because y'all been waiting on that for about a month always gonna rain y'all it's been raining here it's Friday it's Friday and I'm ready to sway you you're gonna get a backhand drop in JB off at school child JB's gonna be off for two I like y'all it's gonna be like 16 day straight this is what it looks like right now wish I could show the mountains but oh there's the mountains back there you see that yeah yeah I didn't even want to upload y'all have to excuse the side I just did a video on my camera my car off girl I just uploaded a video on blowing up my hair I was struggling on wanting to even upload that video like it's so girl I'll go ahead and do this chunky twist on this old camera it's Friday like I said I have a 101 with my manager this morning I'm still toying around where they're not I should go to the gym don't even have water on me tomorrow we're gonna take pictures with Santa right JB girl look at this hair you can't even can it can y'all see it all right you guys I got my sage in yeah I thought I was kidding got my sage in gosh I really need to sage everything open you can see here all the drawers everything open you want to make sure everything's open apparently I girl did some research on this I've seen people sage houses and stuff before even when they just bless houses not just but blessing houses why reading the Bible and so everything's open the front door will be open I'm gonna sage myself down sage JB now again make sure everything is open because energy can be trapped behind these closed doors girl so yeah you guys I know some of y'all thinking that is crazy no this is something that people have been doing for hundreds of years and as long as I feel like that as long as I believe it in my heart and I declared in the name of Jesus Christ I am good okay let me go ahead and burn this and get this started y'all why we were supposed to take pictures with Santa that line is crazy that's like it has never been this many people here JB we're not looking at drains so where are we gonna go we need to go tell me a salad you guys surprise surprise look where we're at JB got a silver dollar of a World War Navy that stopped by I guess he's handed these out during Christmas I told you we don't have these are old people anyone over 60 70 he said he was 92 he gave JB a silver dollar they reminds me of my childhood we used to always get silver dollars my sister and I you guys that was good my salad was good we're right across the street we're in Paradise Valley we're right across the street from PV mall and this mall is dying its color is a dying mall is what they call most malls in America's are dying but there's an actual YouTube video on this particular mall and JB's actually been looking at it so anyway when I first moved here this mall was the bomb mall but they've been closing shops I mean the last time we went in there a couple of months ago there was hardly anyone in this mall and a lot of stores had closed it is such a beautiful day we decide to stop at this park they also have an outdoor an outdoor market look at those beautiful ducks I think it's about 75 degrees right now it's beautiful y'all look I try not to do where is it we're gonna go to the outdoor market in a minute let's look at this leg I didn't even know they had this interesting look they can they that pigeon you need to stay about 20 feet away from us hold on baby no we ain't going to that park you still gotta go to the we go to that park we're not going to what's the name you can see from over here it looks real nice let's go over here to the to the farmers market yeah I try to stay away from these former markets because there was someone who had a crush on me hey hey JB this way we're gonna cross this way that's going out towards the street there's there was a guy who family owned a I need to be careful what I even say cuz you never know who be watching your videos girl he was sweet on me I think they just now putting stuff out too maybe they're putting stuff up I don't know vegetables my word look at these collard greens this is what this is what collard greens supposed to look like look at look at this look at how big these are are you guys that was interesting but JB right now child this is an open field so he's having fun can't even see me how about now that was interesting and look I saw the guy's father there I didn't say anything he doesn't know who I am I'm pretty sure that's his father based on the pictures that I've seen of him yeah that was his father they own a some food business as I'm gonna say like I said you never know the reason I don't want to reveal a lot you guys cuz I know people who don't have as many subscribers as I do and people in the Valley who live here will start some drama so I don't want to say much