Java Buzz Forum - Don't forget to index your PostgreSQL foreign keys

Articles |
News |
Weblogs |
Books |
Forums

Artima Forums | Articles | Weblogs | Java Answers | News

Sponsored Link •

Java Buzz Forum
Don't forget to index your PostgreSQL foreign keys

0 replies on 1 page.

Welcome Guest
Sign In

Back to Topic List

Reply to this Topic

Search Forum

Threaded View


Previous Topic		Next Topic

Flat View: This topic has 0 replies on 1 page

Christopher Wong

Posts: 128
Nickname: cwong15
Registered: Sep, 2009

Christopher Wong is a senior software engineer at lifeIMAGE.

Don't forget to index your PostgreSQL foreign keys

Posted: Feb 24, 2010 8:48 PM

This post originated from an RSS feed registered with Java Buzz by Christopher Wong.
Original Post: Don't forget to index your PostgreSQL foreign keys Feed Title: Chris Wong's Development Blog Feed URL: http://chriswongdevblog.blogspot.com/feeds/posts/default Feed Description: This is a development-focused blog covering BlackBerry and Java software development.	Latest Java Buzz Posts Latest Java Buzz Posts by Christopher Wong Latest Posts From Chris Wong's Development Blog

One thing that surprised me with PostgreSQL after spending a lot of time with MySQL is that setting foreign key constraints do not automatically generate indexes on those columns. PostgreSQL will implicitly generate indexes for primary keys, but not foreign keys. Since those foreign key columns are precisely the ones you tend to use for joins (either explicitly or implicitly by ORMs like

Read: Don't forget to index your PostgreSQL foreign keys

Previous Topic

Next Topic


	Web Artima.com