‫To do that, we need actually a large table and to do a large table, we need to actually populated
‫with, I don't know, like a million rows.
‫OK, so let's go ahead and do that, OK?
‫And I'm going to speed up through this process, maybe through the video.
‫But essentially what we're going to do is create a new project.
‫And this is called server versus client courser.
‫Right.
‫So new projects are going to go ahead and then go ahead and create a file here called insert one million
‫pie.
‫And that's the file that we will use to essentially create a lot of rows in this table.
‫OK.
‫All right.
‫So the first thing we need to do is in part be Syco two.
‫And then I want to have obviously establish a connection.
‫Right.
‫So that is how you do a connection.
‫What's your host?
‫My machine name is called Hosain Mac.
‫That's where my postcrisis instance is.
‫Database equals Hussein DB and obviously the user is postscripts.
‫The password is Postgres and the port is five, four, three, two, which is the default port.
‫Right.
‫So obviously you have to close the connection, make it a habit.
‫OK, and then what we need to do is essentially create a cursor.
‫Right.
‫And to create a cursor, you ask the connection, give me a cursor then what do you do?
‫As for I in range does a million.
‫I think that's a million.
‫Right.
‫Go ahead and execute millions or statements.
‫That's the easiest way.
‫Right.
‫Obviously there is like a most optimal ways of doing things, but we're just inserting here.
‫Obviously I'm going to skip through this and I'm not going to wait for all the million stuff to get
‫inserted.
‫OK, is this right, I.D.?
‫And then obviously I want I and I don't know the employee's name or test.
‫I think that's a great name.
‫It's a beautiful name.
‫OK, and then obviously, once you're done, you have to do a connection that out.
‫And the reason is you want to commit your changes.
‫You don't want to create a million rows and then say that you closed.
‫The whole thing will be rolled back.
‫All right.
‫So let's go ahead and run this guy's.
‫And what happened, I think we got to give it an error here.
‫I know, looks good was going on, it's going okay to 51, go ahead to 50 to nice.
‫All right, this is chugging, let us chug and whenever it's ready, guys, I will come back.
‫All right, guys, we have a million euros, I think so let's make sure that this is true.
‫Oh, that's wrong.
‫OK, that's the Canstar.
‫Yep.
‫We have a million euros.