Re: Building a DB with performance in mind

Поиск
Список
Период
Сортировка
От Steinar H. Gunderson
Тема Re: Building a DB with performance in mind
Дата
Msg-id 20050317160934.GB16434@uio.no
обсуждение исходный текст
Ответ на Building a DB with performance in mind  (Alexander Ranaldi <alexranaldi@gmail.com>)
Список pgsql-performance
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 "Private" column?

You could do a partial index if you'd like (ie. one only indexing rows where
Private=FALSE), but I'm not sure if it's the best solution.

/* Steinar */
--
Homepage: http://www.sesse.net/

В списке pgsql-performance по дате отправления:

Предыдущее
От: Alexander Ranaldi
Дата:
Сообщение: Building a DB with performance in mind
Следующее
От: John Arbash Meinel
Дата:
Сообщение: Re: Building a DB with performance in mind