carl garland writes:
> This didnt really answer the initial question of how long does it take
> to locate a table in a large 100+ table db and where and when do
> these lookups occur.
In the current system there are several places that do sequential scans on
pg_class (which holds information
In a previous post Ed Loer wrote:
> Don't even think about 10 separate tables in a database :-(.It's
>not so much that PG's own datastructures wouldn't cope,as thatvery
>few Unix filesystems can cope with 10 filesin a directory.You'd
>be killed on directory search
