Re: Scalability with large numbers of tables

From: Phil Endecott <spam_from_postgresql_general(at)chezphil(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Scalability with large numbers of tables
Date: 2005-02-21 18:45:01
Message-ID: 421A2C2D.6040300@chezphil.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thanks to all who've responded to my concern about scalability with
large numbers of tables. I am reasonably reassured.

I don't really care about the tab-completion speed - it's just that its
slowness was my "heads-up" to the fact that there could be something
related to number of tables to worry about. Interestingly, however,
bash tab completion on the files in the database directory is still
instantaneous.

The quoted linux-kernel thread about filesystem performance is related
to creating and deleting files (the typical "untar" and "mail server"
benchmarks) which is not typical of what postgres does - it simply opens
them. I was unaware that ext3 had a tree structure - I assumed that its
backward compatibility with ext2 made that impossible. So that's
another thing I don't need to worry about.

Regards,

--Phil.

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2005-02-21 18:50:52 Re: is there anyway to get the backends IP address from the
Previous Message Noel Whelan 2005-02-21 18:10:32 ideally a non-volatile function?