Re: Memory and performance - Mailing list pgsql-sql

From Edipo Elder Fernandes de Melo
Subject Re: Memory and performance
Date
Msg-id 200104042215.f34MFm806586@postgresql.org
Whole thread Raw
In response to Memory and performance  (edipoelder@ig.com.br)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: UNION in a VIEW?
Next
From: Tom Lane
Date:
Subject: Re: performance inconsistency