It is good practice if you execute vacuum command in once of week in database .It is remove dead tuples and increased performance .
Subscribe to:
Post Comments (Atom)
Popular
-
[root@dev ~]#yum install docker Installed: docker.x86_64 2:1.13.1-162.git64e9980.el7.centos [root@dev ~]# systemctl start do... -
SETOF RECORD : select * from employee -- drop function fn_withouttable() select * from fn_record_emp() as tbl(empid int,empname varchar) ...
-
Refcursor : is used for return multiple rows & used to process a sql statement . Task : Used in Function & Stored Procedure cre...
-
PostgreSQL ALTER TABLE Add column alter table employee_clone add column dept_id integer ; Change data type alter table employee_clone alt...
-
Create table account drop table if exists accounts; create table accounts ( id int generated by default as identity, name varchar(...
No comments:
Post a Comment