Is there any difference in terms of performance to build my website's database using PostGreSQL than to built it using MySQL?

Is there any difference in terms of performance to build my website's database using PostGreSQL than to built it using MySQL?
by

1 Answer

Answer :

A few years back, the choice was between raw speed, in which case you chose MySQL, and features and reliability, in which case you chose PostgreSQL. (If you needed speed, features, and reliability, you sold your soul and bought a commercial RDBMS.) Since then, MySQL has added features, and PostgreSQL has improved its speed significantly, so they’re considerably closer. I don’t know precisely how close they are, since back in the MySQL 3 days I made the choice to use PostgreSQL for personal projects (because it had triggers, stored procedures, and constraints), and all the jobs I’ve worked at since have had proprietary databases. One place you really need to be aware of this difference, though, is in reference material. If you buy a MySQL book, make sure it covers MySQL 5. Because of MySQL’s former feature limitations, a lot of things like data integrity checks had to be done in the application rather than in the database. That’s a really poor architectural choice, since verifying data integrity is what databases are built to do, but in older versions of MySQL there was simply no alternative.
by

Related questions

Best tools to build a collaborative project site using only open-source Apache/Mysql/PHP tools

Description : Best tools to build a collaborative project site using only open-source Apache/Mysql/PHP tools

Last Answer : answer:We've used Trac for a few projects with success. Its not perfect but it is configurable and you can extend it. Of course its geared very much towards software development and I'm not sure ... a specific set of tracking and documenting and were glad we did later on in the development cycle.

Error message when using PHP with MySQL.

Description : Error message when using PHP with MySQL.

Last Answer : Wow! Good luck with that!

How long does it take to learn PHP & MySQL?

Description : How long does it take to learn PHP & MySQL?

Last Answer : The O’Reilly Head First book on this is great.

Approximately how many connections per second could a MySQL server with 64mb of memory handle?

Description : Approximately how many connections per second could a MySQL server with 64mb of memory handle?

Last Answer : Nevermind. The answer is between 1200/sec and 2000/sec, but obviously dependent on the load of the request.

MySQL WHERE doesn't work.

Description : MySQL WHERE doesn't work.

Last Answer : answer:Try changing the WHERE clause to: WHERE LOWER(`Title`) LIKE '%trumpet%' (using LOWER makes the search case-insensitive) In SQL, % is a wildcard that matches any number of characters (even zero ... a space in a table name. I'd recommend a migration from `Methodes Walter` to `Methodes_Walter`.

Which database is the choice of yours: MYSQL vs POSTGRESQL vs SQL?

Description : Which database is the choice of yours: MYSQL vs POSTGRESQL vs SQL?

Last Answer : I think MYSQL is the best for me and I used it also it is so easy to use and very popular. I used it since January 2018, I recommend to you it to you

How do I enable single sign in to WordPress backend from my already existing website backend?

Description : How do I enable single sign in to WordPress backend from my already existing website backend?

Last Answer : As far as I’m concerned, just keep yourself logged in

Point out the wrong statement. a) Wolf Frameworks uses a C# engine and supports both Microsoft SQL Server and MySQL database b) Applications built in Wolf are 50-percent browser-based and support mashable and multisource overlaid content c) Google applications are cloud-based applications d) None of the mentioned

Description : Point out the wrong statement. a) Wolf Frameworks uses a C# engine and supports both Microsoft SQL Server and MySQL database b) Applications built in Wolf are 50-percent browser-based ... and multisource overlaid content c) Google applications are cloud-based applications d) None of the mentioned

Last Answer : Applications built in Wolf are 50-percent browser-based and support mashable and multisource overlaid content

Point out the wrong statement. a) Wolf Frameworks uses a C# engine and supports both Microsoft SQL Server and MySQL database b) Applications built in Wolf are 50-percent browser-based and support mashable and multisource overlaid content c) Google applications are cloud-based applications d) None of the mentioned

Description : Point out the wrong statement. a) Wolf Frameworks uses a C# engine and supports both Microsoft SQL Server and MySQL database b) Applications built in Wolf are 50-percent browser-based ... and multisource overlaid content c) Google applications are cloud-based applications d) None of the mentioned

Last Answer : Applications built in Wolf are 50-percent browser-based and support mashable and multisource overlaid content

What MySQL database admin app should I be using?

Description : What MySQL database admin app should I be using?

Last Answer : I use CocoaMySQL

Empty entries in a mysql/php5 site database,... why?

Description : Empty entries in a mysql/php5 site database,... why?

Last Answer : How are you migrating the database? What are you using to export and import?

In a school, a database named “school” is created in mysql whose password is “cbse”. Smith is trying to add a new record of a student having details -Technology

Description : In a school, a database named “school” is created in mysql whose password is “cbse”. Smith is trying to add a new record of a student having details -Technology

Last Answer : import mysql.connectormydb = mysql.connector.connect{host='localhost',user='root',passwd='cbse',database='school'}mycursor = mydb.cursor()mycursor.execute('INSERT INTO student values(3,'Michelle', 'Agartala');')mydb.commit()

Which of the following allows you to create instances of the MySQL database to support your Web sites? a) Amazon Elastic Compute Cloud b) Amazon Simple Queue Service c) Amazon Relational Database Service d) Amazon Simple Storage System

Description : Which of the following allows you to create instances of the MySQL database to support your Web sites? a) Amazon Elastic Compute Cloud b) Amazon Simple Queue Service c) Amazon Relational Database Service d) Amazon Simple Storage System

Last Answer : Amazon Relational Database Service

In JDBC ........................ imports all Java classes concerned with database connectivity. A) javax.sql.* B) java.mysql.* C) java.sql.* D) com.*

Description : In JDBC ........................ imports all Java classes concerned with database connectivity. A) javax.sql.* B) java.mysql.* C) java.sql.* D) com.*

Last Answer : C) java.sql.*

How to Find Greats Tools for MySQL SQL Performance Tuning?

Description : How to Find Greats Tools for MySQL SQL Performance Tuning?

Last Answer : Say goodbye to changing queries manually and tuning them for better performance. At Tosska Technologies, we offer efficient tools for MySQL SQL performance tuning that help you save time and resources. With ... explore our tools and make the right selection, visit our website, and get a free trial.

Is there a PHP library or API that would let me quickly build survey questionnaires and dump the captured data to MySQL?

Description : Is there a PHP library or API that would let me quickly build survey questionnaires and dump the captured data to MySQL?

Last Answer : If you are familiar with LAMP and PHP, why not build a little CRUD application?

Database applications were built directly on top of file system to overcome the following drawbacks of using file-systems (a) Data redundancy and inconsistency (b) Difficulty in accessing Data (c) Data isolation (d) Integrity problems (A) (a) (B) (a) and (d) (C) (a), (b) and (c) (D) (a), (b), (c) and (d)

Description : Database applications were built directly on top of file system to overcome the following drawbacks of using file-systems (a) Data redundancy and inconsistency (b) Difficulty in accessing Data (c) Data isolation (d) Integrity problems (A) (a) (B) ... d) (C) (a), (b) and (c) (D) (a), (b), (c) and (d)

Last Answer : (D) (a), (b), (c) and (d) 

Anyone using Spry with PHP/MySQL in Dreamweaver CS3?

Description : Anyone using Spry with PHP/MySQL in Dreamweaver CS3?

Last Answer : Why are you asking? Are you already using it, or wondering if it's a good choice of tools?

How do I check for the existence of a particular MySQL table using PHP? (Using an IF statement.)

Description : How do I check for the existence of a particular MySQL table using PHP? (Using an IF statement.)

Last Answer : answer:I don't know of a preexisting function, so here's one I wrote real quick (untested): function checkTable ($table_name, $database_name) { $my_tables [equal] mysql_list_tables($database_name); while (list($foo) ... , your_database )) { // Table exists } else { // Table does not exist }

Ms. Archana, a class XI student has just started learning MySQL. Help her in understanding the basic difference between -Technology

Description : Ms. Archana, a class XI student has just started learning MySQL. Help her in understanding the basic difference between -Technology

Last Answer : ALTERUPDATEIt s a DDL command.It s a DML command.It can be used for the following purpose:To add a new column.To remove an existing column.To modify a column.To add/remove a constraint.It s ... Delhi ;suitable command:(i)Show Databases(ii) Use City(iii) Drop Database Clients(iv) Drop table Club

Shewani has recently started working in MySQL. Help her in understanding the difference between the following : -Technology

Description : Shewani has recently started working in MySQL. Help her in understanding the difference between the following : -Technology

Last Answer : (i) Where clause is used to show data set for a table based on a condition and having clause is used to put condition on the result set that comes after using Group by clause.(ii) COUNT ... unique as single column or combined multiple columns to the table. They are all candidates for Primary Key.

List the Optional Flexible Architecture (OFA) of Oracle database? or How can we organize the tablespaces in Oracle database to have maximum performance ?

Description : List the Optional Flexible Architecture (OFA) of Oracle database? or How can we organize the tablespaces in Oracle database to have maximum performance ?

Last Answer : SYSTEM - Data dictionary tables. DATA - Standard operational tables. DATA2- Static tables used for standard operations INDEXES - Indexes for Standard operational tables. INDEXES1 - Indexes of ... - Temporary purpose tablespace TEMP_USER - Temporary tablespace for users. USERS - User tablespace.

What are the advantages of activating the automatic Program Global Area (PGA) inSAP system that have an Oracle database? Note: there are 2 correct answered to this question A. Higher system performance is gained B. Shorter response time for queries is achieved C. Large sort processes will use more memory for efficient sorting D. Less PGA memory is allocated in advance

Description : What are the advantages of activating the automatic Program Global Area (PGA) inSAP system that have an Oracle database? Note: there are 2 correct answered to this question A. Higher system ... sort processes will use more memory for efficient sorting D. Less PGA memory is allocated in advance

Last Answer : A. Higher system performance is gained

State which of the one is false A. In performance testing, usage of tool is a must B. In database testing, database knowledge is a must. C. In Functional Testing, knowledge of business logic is a must D. None of the above.

Description : State which of the one is false A. In performance testing, usage of tool is a must B. In database testing, database knowledge is a must. C. In Functional Testing, knowledge of business logic is a must D. None of the above.

Last Answer : D. None of the above.

Data which improves the performance and accessibility of the database are called: (A) Indexes (B) User Data (C) Application Metadata (D) Data Dictionary

Description : Data which improves the performance and accessibility of the database are called: (A) Indexes (B) User Data (C) Application Metadata (D) Data Dictionary

Last Answer : (A) Indexes

A database of information that is maintained by human editors and lists websites by category and subcategory with categorization is known as: 1. A search directory 2. Automated voice response (AVR) 3. Apps 4. Search Engine Optimization (SEO

Description : A database of information that is maintained by human editors and lists websites by category and subcategory with categorization is known as: 1. A search directory 2. Automated voice response (AVR) 3. Apps 4. Search Engine Optimization (SEO

Last Answer : A search directory

The cost of quality quality is a. An expression of expression of an organizatio organization’s performance in performance in quality in quality in financial terms financial terms b. The difference between customers’ expectations of a product or service and their perceptions of their experience of it. c. A proactive approach proactive approach towards quality towards quality management by management by seeking to seeking to prevent defects prevent defects ever being produced. d. The inspection and inspection and testing of testing of the outputs from outputs from a transformation process.

Description : The cost of quality quality is a. An expression of expression of an organizatio organization's performance in performance in quality in quality in financial terms financial terms b. The ... inspection and inspection and testing of testing of the outputs from outputs from a transformation process.

Last Answer : b. The difference between customers’ expectations of a product or service and their perceptions of their experience of it.

Which of the following statements about Google App Engine (GAE) is INCORRECT. A. It’s a Platform as a Service (PaaS) model. B. Automatic Scalability is built in with GAE. As a developer you don’t need to worry about application scalability C. You can decide on how many physical servers required for hosting your application. D. The applications deployed on GAE have the same security, privacy and data protection policies as that of Google’s applications. So, applications can take advantage of reliability, performance and security of Google’s infrastructure.

Description : Which of the following statements about Google App Engine (GAE) is INCORRECT. A. It's a Platform as a Service (PaaS) model. B. Automatic Scalability is built in with GAE. As ... s applications. So, applications can take advantage of reliability, performance and security of Google's infrastructure.

Last Answer : You can decide on how many physical servers required for hosting your application.

MySQL help!

Description : MySQL help!

Last Answer : answer:You spelled “propeller” wrong, for one thing. Table SERVICE_REQUEST has a primary key, SERVICE_ID, which is a DECIMAL field. In your attempt to load the table with the error record, the secondary key value you attempted to insert for SERVICE_ID, ‘7’ is a CHAR value. That’s a show-stopper.

What are the best web sites to get help with Apache, PHP, and MySQL?

Description : What are the best web sites to get help with Apache, PHP, and MySQL?

Last Answer : stackoverflow is the best site programming q & a site I know of. Looks like there is a fair amount of LAMP-related questions there.

MySQL order by primary key, put one row on top.

Description : MySQL order by primary key, put one row on top.

Last Answer : answer:If you can guarantee that there is only one or zero active records select * from presets order by active asc, id asc

As a specialist PHP/MySQL programmer at my (not so fun to work at) job, what's my future?

Description : As a specialist PHP/MySQL programmer at my (not so fun to work at) job, what's my future?

Last Answer : It depends if you want to continue doing programming or not. If you have good people skills, and good business sense, you could get PMP certified, or learn VersionOne and move to the business ... business side. We also prize business analysts with SQL knowledge in order to manage data and metrics.

If I already know basic PHP/MySQL, what else should I learn to use Google App Engine?

Description : If I already know basic PHP/MySQL, what else should I learn to use Google App Engine?

Last Answer : answer:I am not an expert, I just started reading up on this myself, but here are a couple of starting points on data storage. Rather than a separately maintained SQL database, ... .com/appengine/articles/datastore/overview.html http://code.google.com/appengine/docs/python/datastore/overview.html

What takes more computing power, serving HTTP or MySQL?

Description : What takes more computing power, serving HTTP or MySQL?

Last Answer : this is not exactly my field, but i would say http has much more to do that mysql. with http you are loading everything, where mysql is just loading data. i guess it could depend on the site and whats on it, but for the most part http will be doing most the work.

What is apache or perl or php or mySQL?

Description : What is apache or perl or php or mySQL?

Last Answer : Apache, Perl, PHP, MySQL Seriously, Wikipedia does wonders. Also try searching with Google.

PHP/MySQL question.... (please read on)

Description : PHP/MySQL question.... (please read on)

Last Answer : Have you looked through these?

What is a good book for learning PHP and MySQL?

Description : What is a good book for learning PHP and MySQL?

Last Answer : I’d start here: http://www.php.net/manual/en/ Get a feel for PHP, then buy books to fill in the gaps or get deeper into particular areas.

Add an ID column to an already existing MySQL table?

Description : Add an ID column to an already existing MySQL table?

Last Answer : I’m not an expert on MySQL [@stewartwb?], but in SQLServer that works just fine. Add the column and set the identity property and it autogenerates. What happens when you try that in MySQL? Do you get an error? or does it just not populate?

Do you know webhosting server including with these details: free, about 1-2 gigabytes, php script OK, mysql OK, no adds on site?

Description : Do you know webhosting server including with these details: free, about 1-2 gigabytes, php script OK, mysql OK, no adds on site?

Last Answer : Hosting a free Wordpress blog. Interesting. Did you try wordpress.com? Most hosts aren’t going to offer those serviced ad-free for free. I can’t think of a single one. Everyone needs a business model. And even if I found one, I certainly wouldn’t trust it for stability and security.

How can I create an ordered list of the most common substrings inside of a MySQL varchar column?

Description : How can I create an ordered list of the most common substrings inside of a MySQL varchar column?

Last Answer : SQL is definitely not my specialty but you can use regular expressions within your select statement is this something you want to pull on the fly each time though? It seems like as your data set grows it ... ve got me wondering if I can write one SQL statement for it though, let me take a look.

Can someone please explain to me exactly how PHP, mySQL, Javascript, and HTML/CSS are related?

Description : Can someone please explain to me exactly how PHP, mySQL, Javascript, and HTML/CSS are related?

Last Answer : PHP is a serverside language, while JavaScript and mySQL are clientside languages. I think the difference is that PHP/HTML is the language used by the server to encode instructions for the web browser, ... have no idea whether it's accurate or not. I just started learning this stuff this week.

MySQL Sort by every other row?

Description : MySQL Sort by every other row?

Last Answer : Couldn’t you just grab the males in a query and do the same for the females. Then loop through them in PHP. If that made any sense.

Getting certified in PHP and MySQL?

Description : Getting certified in PHP and MySQL?

Last Answer : I think Zend, the company behind PHP, has some kind of certification. Is this required for something? I’ve honestly never seen a job requiring a “certified” PHP programmer. Edit: This looks like it.

How do I do a MySQL Insert statement into 2 different tables?

Description : How do I do a MySQL Insert statement into 2 different tables?

Last Answer : sounds to me like two separate insert statements... or maybe i don't understand the question...

How can I search for a specific column name in MySQL?

Description : How can I search for a specific column name in MySQL?

Last Answer : SELECT table_name, column_name from information_schema.columns WHERE column_name LIKE 'Name';

Good advanced MySQL tutorial?

Description : Good advanced MySQL tutorial?

Last Answer : I don’t know of a specific one but I know http://www.pixel2life.com/ has lots of web-related tutorials, I’ve always found it to be a great resource. Joining irritates me, covered it in SQL w/ Oracle, hated every minute of it! If I find anything in the mean time I’ll post it here.

What MySQL engine would you recommend?

Description : What MySQL engine would you recommend?

Last Answer : answer:I'm a big fan of the whole foreign key' concept, so I really only use InnoDB (since MyISAM doesn't support it). If I remember correctly, general statements run faster on InnoDB than ... a determining factor. Though if you plan on implementing a full-text search, go with MyISAM for sure.

Are there any resources that you can recommend for me to learn LAMP (Linux Apache MySQL Perl/Python/PHP?

Description : Are there any resources that you can recommend for me to learn LAMP (Linux Apache MySQL Perl/Python/PHP?

Last Answer : I’m not educated in this type of stuff, but I did a little research and got these. http://lamphowto.com http://onlamp.com

Does MySQL have a native counter function for its results?

Description : Does MySQL have a native counter function for its results?

Last Answer : I know that with PHP when you query the database and it returns any results it'll provide an array of results I think so you can loop through them and get the data from them, however nativly I don't ... and report what I find, if anything at all :) what langauge are you programming in by the way?

What the hell is wrong when i create connection btw navicat and mysql?

Description : What the hell is wrong when i create connection btw navicat and mysql?

Last Answer : answer:This probably isn’t a bug or issue with the MySQL server. The possibilities are: 1) Login password for root is wrong 2) The account doesn’t have a password Have you tried connecting without a password?