From: Francisco Reyes <lists@stringsutils.com>
To: Michael Riess <mlriess@gmx.de>
Cc: pgsql-performance@postgresql.org
Subject: Re: 15,000 tables
Date: Fri, 02 Dec 2005 18:00:53 -0500
Message-ID: <cone.1133564453.66650.45724.5001@35st-server.simplicato.com> (raw)
References: <dmmujf$2rgd$1@news.hub.org>
<11360.1133453022@sss.pgh.pa.us>
<dmn8bs$254u$1@news.hub.org>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: lists@stringsutils.com, mlriess@gmx.de
Subject: Re: 15,000 tables
In-Reply-To: <cone.1133564453.66650.45724.5001@35st-server.simplicato.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox