Re: [PERFORM] Building a DB with performance in mind

2005-03-17 Thread John Arbash Meinel
Alexander Ranaldi wrote: Greetings everyone, I am about to migrate to Postgres from MySQL. My DB isn't enormous (< 1gb), consists mostly of just text, but is accessed quite heavily. Because size isn't a huge issue, but performance is, I am willing to normalize as necessary. Currently I have a table

Re: [PERFORM] Building a DB with performance in mind

2005-03-17 Thread Steinar H. Gunderson
On Thu, Mar 17, 2005 at 10:56:10AM -0500, Alexander Ranaldi wrote: > Most of my queries return rows based on UserID, and also only if > Private is FALSE. Would it be in the interest of best performance to > split this table into two tables: "EntriesPrivate", > "EntriesNotPrivate" and remove the "Pr

[PERFORM] Building a DB with performance in mind

2005-03-17 Thread Alexander Ranaldi
Greetings everyone, I am about to migrate to Postgres from MySQL. My DB isn't enormous (< 1gb), consists mostly of just text, but is accessed quite heavily. Because size isn't a huge issue, but performance is, I am willing to normalize as necessary. Currently I have a table "Entries" containing 5