large table vs multiple smal tables - Mailing list pgsql-performance

From Nicolas Beaume
Subject large table vs multiple smal tables
Date
Msg-id 42D4E836.9020607@univ-nantes.fr
Whole thread Raw
Responses Re: large table vs multiple smal tables
Re: large table vs multiple smal tables
List 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


pgsql-performance by date:

Previous
From: Jean-Max Reymond
Date:
Subject: size of cache
Next
From: Mark Rae
Date:
Subject: Re: General DB Tuning