large table vs multiple smal tables

From: Nicolas Beaume <nicolas(dot)beaume(at)univ-nantes(dot)fr>
To: pgsql-performance(at)postgresql(dot)org
Subject: large table vs multiple smal tables
Date: 2005-07-13 10:08:54
Message-ID: 42D4E836.9020607@univ-nantes.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hello

I have a large database with 4 large tables (each containing at least
200 000 rows, perhaps even 1 or 2 million) and i ask myself if it's
better to split them into small tables (e.g tables of 2000 rows) to
speed the access and the update of those tables (considering that i will
have few update but a lot of reading).

Do you think it would be efficient ?

Nicolas, wondering if he hadn't be too greedy

--

-------------------------------------------------------------------------
« soyez ce que vous voudriez avoir l'air d'être » Lewis Caroll

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Kenneth Marshall 2005-07-13 12:33:05 Re: large table vs multiple smal tables
Previous Message Mark Rae 2005-07-13 10:07:40 Re: General DB Tuning