Re: [HACKERS] tables > 1 gig

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] tables > 1 gig
Date: 1999-06-20 14:51:33
Message-ID: 12660.929890293@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu> writes:
> Would it be possible to make BLCKSZ and/or RELSEG_SIZE (the latter
> perhaps the most important, and perhaps the easiest?) a configurable
> parameter which is read out of a global variable for each database?

Doable, perhaps, but I'm not quite sure why it's worth the trouble...
there doesn't seem to be that much value in running different DBs with
different values inside a single installation. Tweaking BLCKSZ, in
particular, will become fairly uninteresting once we solve the tuples-
bigger-than-a-block problem.

regards, tom lane

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 1999-06-20 15:00:44 Re: [HACKERS] /usr/local/include search
Previous Message Michael Alan Dorman 1999-06-20 14:40:20 Re: [HACKERS] BSD vs. GPL