From: | ghaverla(at)freenet(dot)edmonton(dot)ab(dot)ca |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Re: Out of disk space |
Date: | 2000-06-03 15:51:37 |
Message-ID: | Pine.A41.3.95.1000603094753.50810A-100000@freenet.edmonton.ab.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-novice |
On Sun, 4 Jun 2000, Martijn van Oosterhout wrote:
> > Related question, maybe someone knows the answer to this. If
> > I am storing "words" in a tuple, I would be better trying to
> > get almost 8k worth of words in a tuple, instead of having
> > 800 tuples with words of 10 bytes each in it?
>
> Store it in the most convenient way for you and let the database
> decide on how to most efficiently store your data. Isn't that
> what databases are for?
That's what I thought originally, but it isn't working that way
it seems. Certainly with large objects, you have to treat the
data differently than just stuff it in and work with it. But,
this application could easily have tuples larger than 8k, and
apparently this isn't allowed unless I recompile PostgreSQL.
Instead of having a dbase different than most, I'm changing how
I store the data to reflect average conditions. Maybe I
am just reading the manuals wrong.
Gord
Matter Realisations http://www.materialisations.com/
Gordon Haverland, B.Sc. M.Eng. President
101 9504 182 St. NW Edmonton, AB, CA T5T 3A7
780/481-8019 ghaverla @ freenet.edmonton.ab.ca
From | Date | Subject | |
---|---|---|---|
Next Message | Nikolay Mijaylov | 2000-06-03 23:01:39 | RE: Web hosting and PostgreSQL? |
Previous Message | Martijn van Oosterhout | 2000-06-03 15:32:43 | Re: Re: Out of disk space |
From | Date | Subject | |
---|---|---|---|
Next Message | Miguel Fernandez | 2000-06-03 21:57:03 | Problems compiling test program program form pgsql |
Previous Message | Martijn van Oosterhout | 2000-06-03 15:32:43 | Re: Re: Out of disk space |