Re: Scalability with large numbers of tables
| От | Phil Endecott |
|---|---|
| Тема | Re: Scalability with large numbers of tables |
| Дата | |
| Msg-id | 421A2C2D.6040300@chezphil.org обсуждение исходный текст |
| Ответ на | Scalability with large numbers of tables (Phil Endecott <spam_from_postgresql_general@chezphil.org>) |
| Список | 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.
В списке pgsql-general по дате отправления: