Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

PostgresqlDBA interview questions and answers

-

Questions :I have three  tables which contains around 20millions of records. I am planning to update these three tables for all records. Could you suggest me best approaches to meet this, please?
Ans:
1.I think disable index before update ? And autovacuum off,arhvive off if possible.
2.Increase the check point time out
Increase shared buffer or wall beffer if archive enable.
3.Check any parallel option is there.

Comments

Post a Comment

Popular posts from this blog

VMWARE WORKSTATION 3,4,5,6,7,8,9,10,11,12,14,15...etc LICENSE KEYS COLLECTION

-
Image
Below tutorialdba.com collected and sorted out hundreds of universal License Keys for all major versions of VMware Workstation Pro (not for VMware Workstation Player) 4.x, 5.x, 6.x, 7.x, 8.x, 9.x, 10.x, 11.x, 12.x and v14.x on Windows and Linux platforms (support both 32-bit and 64-bit operating system) in this single post. Besides, we also provide some license keys for VMware other projects. Just enjoy and share them. // 4~14 Universal License Keys // Version License Keys VMware Workstation VMware Workstation 4.x.x ZHDH1-UR90N-W844G-4PTN6 G1NP0-T88AL-M016F-4P8N2 ZC14J-4U16A-0A04G-4MEZP J1WF8-58LDE-881DG-4M8Q3 VMware Workstation 5.x.x LUXRM-WP0DN-A256U-4M9Q3 DJXDR-NDT27-Y2NDU-4YTZK DA925-HP80U-Z8HDC-4WXXP 3KW2W-AYR2C-88M6F-4MDQ2 VMware Workstation 6.x.x A0E8R-YUDFV-6AK2F-4GAN2 CRX0D-VWL0V-7CJ6C-46C7A NA8RX-QPNDU-D2LA9-4WAZL 1H4WM-N21FZ-7GK2A-44U5U 6AJ6N-THY2P-42KEF-4WTFG FK8R9-LPCDT-88H4Y-4WRN3 KAR8R-T8MAL-K8J6A-4WDXQ YJEKW-JMFF4-YA1DC-4WTQ...
Read more

PostgreSQL DOMAIN Data Type -2

-
PRACTICAL 2 .CREATION OF DOMAIN WITHOUT CONSTRAINT: Consider the following scenario on PostgreSQL 9.3: Step 1 .Create a domain with no constraints: postgres=# CREATE DOMAIN zipcode AS text; CREATE DOMAIN Step 2 .Add a named constraint: postgres=# ALTER DOMAIN zipcode ADD CONSTRAINT zipcheck CHECK (char_length(VALUE) = 3); ALTER DOMAIN Step 3 .Check the Domain whether created or not: postgres=# \dD List of domains Schema | Name | Type | Modifier | Check --------+-------------+------+----------+------------------------------------------------------------------ public | postal_code | text | | CHECK (VALUE ~ '^\d{5}$'::text OR VALUE ~ '^\d{5}-\d{4}$'::text) public | zipcode | text | | CHECK (char_length(VALUE) = 3) (2 rows) Step 4 .Ctreate a table using "zipcode" Data type postgres=# create table details (name...
Read more

10. Global Sequences

-
10.1.  Purpose of global sequences 10.2.  When to use global sequences 10.3.  Using global sequences 10.4.  Listing global sequences 10.5.  Global sequence limitations 10.6.  Global sequence voting 10.7.  Traditional approaches to sequences in distributed DBs 10.7.1.  Step/offset sequences 10.7.2.  Composite keys 10.7.3.  UUIDs BDR  global sequences provide an easy way for applications to use the database to generate unique synthetic keys in an asynchronous distributed system. Global sequences should be considered deprecated. See  When to use global sequences  and  Global Sequence Limitations . Most deployments are better off using step/offset sequences as described 
Read more

Oracle to Postgresql migration

-
Oracle migration: For migration first we need to install oracle database and ora2pg software and DBD oracle packages. =>first install oracle database in server and note down the paths,username,password needed For installing the oracle database follow the below steps: From the root user: create group "groupadd oinstall" create group "dba" create user "useradd oracle -G dba -g oinstall create directory "mkdir /home/oracle/software" Change ownership permissions to software directory chown oracle:oinstall /home/oracle/software copy the downloaded files to /home/oracle/software and untar the files After untaring we can find "database" directory in /home/oracle/software In database directory we find runinstaller file we need to run that file ./runinstaller and finish the oracle database installation. ======================================================================= After finishing the installation switch to oracle use...
Read more

How to Configure Oracle Dataguard and How to Perform Switchover and Failover

-
Answer: In this article i will explained about how to configure oracle dataguard without using Rman utility and also explained what type of errors you will be faced at the time of configuring oracle dataguard and also i gave some real time interview questions and answer related to oracle dataguard   Before Dataguard configure you need to perform some postrequest oracle version and os version should be same. Ping the both server from primary to standby and standby to primary ( ping 192.168.1.100) check fairewal;l status if enaled or not using service iptables status check the port number whether available or not using netstat -plunts |grep port_number Primary database : nijam                       standby database : benz       server : 192.168.1.100               ...
Read more