Re: Inserting values into a variable table

On 11/27/06, Bo Berglund <bo(dot)berglund(at)telia(dot)com> wrote:

> >> I'm not sure if PostGreSQL will handle this better. But my main concern over
> >> this matter is the problem with Disk I/O on one big table.
> >Me neither - I wouldn't think it does make a difference for the better, but
> > to be sure I'd try to bench-mark it, with the same data-volume once in
> >one big table, and once indisparate tables (and see what indexing does
> >in both cases).
> Look out for file fragmentation too!
> If the volume where you store the data does not have a *large* free
> area any big file would be fragmented and the head starts jumping like
> mad.
> Before benchmarking I would shut down the server and then defrag the
> disk.
I wouldn't; my logic tells me that disparate tables will cause MORE
head-movement than a single (well-indexed) table ... and my Linux
file systems a) don't fragment to begin with and b) don't have any
defragmentation tools for that reason. ;}

> Bo Berglund
Cheers,
Andrej