Skip site navigation (1) Skip section navigation (2)

Re: Inserting values into a variable table

From: "Andrej Ricnik-Bay" <andrej(dot)groups(at)gmail(dot)com>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Inserting values into a variable table
Date: 2006-11-26 17:20:50
Message-ID: b35603930611260920y67b9b479gbcf434bfcd90f2f9@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
On 11/26/06, Greg Quinn <greg(at)officium(dot)co(dot)za> wrote:

> Every time a user clicks on a mail folder, it pulls their message headers
> from the headers table. Every time a user clicks on a message, it needs to
> pull The message body etc. from the message source table.
Ok.


> Now as you can imagine, on the server side, if you have 100 users, and all
> their message source sitting in one big table, it can slow down read
> operations because of all the disk i/o.
OK, I have a problem with this one intellectually.  As far as I'm concerned
I'd think I get a higher latency and bigger head-movement if the heads
have to dash back and forth over a larger are of disk to get to individual
tables than when manipulating a single bit of data?


> Previously, I was using MySQL and placing all the users data into separate
> tables gave me a huge performance increase.
>
> 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).


Cheers,
Andrej

In response to

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2006-11-26 18:23:50
Subject: Re: Inserting values into a variable table
Previous:From: Stephan SzaboDate: 2006-11-26 17:12:04
Subject: Re: Inserting values into a variable table

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group