Re: Memory and performance

Поиск
Список
Период
Сортировка
От Edipo Elder Fernandes de Melo
Тема Re: Memory and performance
Дата
Msg-id 200104042215.f34MFm806586@postgresql.org
обсуждение исходный текст
Ответ на Memory and performance  (edipoelder@ig.com.br)
Список pgsql-sql
Em 05 Apr 2001, Cedar Cox escreveu:

>To this I say, remember that you are using a database!  I would split this 

>into 3 tables (people, exams, answers).  Then only the 'answers' table 
>would contain 3M records.  Should be a bit faster.  You don't want to have 

>to store the <person> and <exam> with each <answer>. 
>
>(If this is what you are doing then ignore me.  I don't take you for an 
>idiot :) 
   Yeah... I'm doing this... (I'm not a idiot! :)))) I'm just asking if 
exist any way to optimize PostgreSQL to handle a great quantity of tuples. 
(I will try the 7.1. By the way... in the URI 
http://www.postgresql.org/ftpsite/dev/ we found a RC2 version, but in the 
URI ftp://ftp.postgresql.org/pub/dev/ don't!)
   Hugs,
   Edipo Elder   [edipoelder@ig.com.br]

_________________________________________________________
Oi! Voc� quer um iG-mail gratuito?
Ent�o clique aqui: http://www.ig.com.br/paginas/assineigmail.html



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: UNION in a VIEW?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: performance inconsistency