| From: | Francisco Reyes <lists(at)stringsutils(dot)com> |
|---|---|
| To: | Michael Riess <mlriess(at)gmx(dot)de> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: 15,000 tables |
| Date: | 2005-12-02 23:00:53 |
| Message-ID: | cone.1133564453.66650.45724.5001@35st-server.simplicato.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-es-ayuda pgsql-performance |
Michael Riess writes:
> Sorry, I should have included that info in the initial post. You're
> right in that most of these tables have a similar structure. But they
> are independent and can be customized by the users.
>
How about creating 50 databases and give each it's own tablespace?
It's not only whether PostgreSQL can be optimized, but also how well your
filesystem is handling the directory with large number of files. by
splitting the directories you will likely help the OS and will be able to
perhaps better determine if the OS or the DB is at fault for the slowness.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joan Manuel Ventura | 2005-12-03 13:51:14 | Split de un Backup |
| Previous Message | Jaime Casanova | 2005-12-02 22:33:40 | Re: Consultas sobre vistas |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-12-02 23:00:59 | Re: Database restore speed |
| Previous Message | Michael Stone | 2005-12-02 21:46:02 | Re: Database restore speed |