[postgis-users] Re: How to store many tables

[Robert Coup]

On 26/09/2007, Peter.Tolkewitz at gmx.de <Peter.Tolkewitz at gmx.de> wrote:
>
> Regina, thank you very much for this information. How many tables can I
> store at most per tablespace without running into performance problems due
> to directory scans?


If you use a filesystem like xfs,jfs,reiser4,etc the directory entries are
stored in b-tree indexes, so the number of files per directory is much less
relevant (cf ext*,etc which do linear scans).

Rob :)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070926/2a3df2b6/attachment.html>