GeekInterview.com
Series: Subject: Topic:

PostgreSQL Interview Questions

Showing Questions 1 - 20 of 24 Questions
First | Prev | | Next | Last Page
Sort by: 
 | 

MySQL to postgre migration

Asked By: Noah_Raj | Asked On: Jul 15th, 2009

What are the common bugs found while migrating to MySQL db to postgre?

Answered by: santhanapandi on: Mar 21st, 2013

Mostly Its not possible because of it will comes on syntax error..

Answered by: leecher on: Oct 22nd, 2011

Syntax and datatypes

What is the maximum size for a table in postgresql?

Asked By: RajivPrasad | Asked On: Jan 3rd, 2007

Answered by: postgresql on: Jul 1st, 2010

Max table size = 32 TB

Answered by: bhawesh on: Aug 6th, 2007

NO LIMIT

It depends on physical space avaliable with you.

PostgreSQL disadvantages

Asked By: Noah_Raj | Asked On: Jul 15th, 2009

List out the disadvantages of postgreSQL database.

Answered by: gakorde on: Jul 5th, 2010

Replication is not that much powerful as compared to other databases.

What are the character types that are available in postgresql?

Asked By: JohnMathew | Asked On: Jan 3rd, 2007

Answered by: postgresql on: Jul 1st, 2010

character varaying(n), varchar(n), character(n), char(n), text.

Answered by: varkalaRekha on: Apr 13th, 2007

POSTGRESQL Supports Char(n),varchar(n),text data types

What does geqo stands for in postgresql?

Asked By: JamesMike | Asked On: Jan 3rd, 2007

Answered by: postgresql on: Jul 1st, 2010

The genetic query optimizer (GEQO) is an algorithm that does query planning using heuristic searching

Answered by: nehalshah on: May 5th, 2007

GEQO stands for Genetic Query Optimization. As the name implies this is used for query optimization in POSTGRESQL. The Genetic Query Optimization is used along with POSTGRESQL query evaluator and opti...

How many byte unique integers does oids in postgreSQL have?

Asked By: GregMark | Asked On: Jan 3rd, 2007

Answered by: postgresql on: Jul 1st, 2010

4 unsigned

Answered by: JohnMathew on: May 5th, 2007

OIDs in POSTGRESQL have 4 byte unique integers. That is each row in POSTGRESQL would be assigned a unique OID. Though the concept of unique OID exists in POSTGRESQL for each row after sufficient number of rows overflowing occurs and the OID value gets repeated from this stage.

What is the command that can be used to allocate memory in postgresql?

Asked By: scott | Asked On: Jan 3rd, 2007

Answered by: postgresql on: Jul 1st, 2010

set work_mem=size

Answered by: SachinDeo on: May 5th, 2007

palloc is used to allocate memory in POSTGRESQL. POSTGRESQL memory allocation follows interesting concept of allocating memory within memory contexts. This concept helps in efficiency way of managing memory preventing many problems that pccurs due to improper memory allocation like memory leaks.

Why update is too slow

Asked By: dbadba123 | Asked On: Jul 18th, 2008

Why the update statement works very slowly in postgresql?

Answered by: postgresql on: Jul 1st, 2010

Because of the MVCC architecture of PostgreSQL but is greatly improved starting PostgreSQL 8.3.x if you are not updating the index field.

What does the option pSQL -l of postgreSQL display?

Asked By: RajivPrasad | Asked On: Jan 3rd, 2007

Answered by: postgresql on: Jul 1st, 2010

It will display list of DB's

Answered by: Sivakumar on: Feb 23rd, 2007

It will display the databases that are currently available in the server.EXample:-bash-2.05b$ psql -l        List of databases   Name    |&n...

What is the operator that is used for case-insensitive regular expression searches in postgresql?

Asked By: JohnMathew | Asked On: Jan 3rd, 2007

Answered by: postgresql on: Jul 1st, 2010

ILIKE or ~~*

Answered by: gobisankar on: May 7th, 2010

Example for using ilike we can get it

SELECT city_name FROM cities WHERE city_name ilike '%chennai%';

this will print both CHENNAI and chennai

Regards,
Gobi S.

Does postgrSQL support column constraints? If so how is it done?

Asked By: nehalshah | Asked On: Jan 3rd, 2007

Answered by: postgresql on: Jul 1st, 2010

Yes, Can be given at the time of table creation or can be with alter table

Triggers are supported and can be attached in postgreSQL to tables or views?

Asked By: nancyphilips | Asked On: Jan 3rd, 2007

Answered by: postgresql on: Jul 1st, 2010

Triggers for tables and rules for view

Update and delete statement is too slow

Asked By: dbadba123 | Asked On: Jul 16th, 2008

Why the updation and deletion is too slow in greenplum as compared to insertion?

Answered by: postgresql on: Jul 1st, 2010

Because of MVCC architecture of PostgreSQL

To identify specific physical rows with block and offset values what can be used in postgresql?

Asked By: scott | Asked On: Jan 3rd, 2007

Answered by: SriramKrishna on: May 5th, 2007

OID are used for unique row identification in POSTGRESQL. For identifying specific physical rows with block and offset values in POSTGRESQL TIDs are used. The relationship between OID and TID exists in such a way that whenever a row is altered the corresponding TID also gets altered.

What are the ODBC drivers that are available for postgresql?

Asked By: SachinDeo | Asked On: Jan 3rd, 2007

Answered by: nehalshah on: May 5th, 2007

psqlODBC, OpenLink, Mac ODBC driver  are some of the generally and widely used ODBC drivers that are available for POSTGRESQL.

First | Prev | | Next | Last Page

 

 

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Ads

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.