On Fri, Oct 9, 2009 at 10:50 PM, Scott Carey sc...@richrelevance.com wrote:
On 10/9/09 2:02 PM, Merlin Moncure mmonc...@gmail.com wrote:
On Fri, Oct 9, 2009 at 1:46 PM, Scott Otis scott.o...@intand.com wrote:
Over the next couple of months we will be creating an instance of our
solution for
On Fri, Oct 9, 2009 at 11:11 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Scott Carey sc...@richrelevance.com writes:
I've got 200,000 tables in one db (8.4), and some tools barely work. The
system catalogs get inefficient when large and psql especially has
trouble.
Tab completion takes
On Sat, Oct 10, 2009 at 8:44 AM, Chris Kratz chris.kr...@vistashare.com wrote:
alter function pg_table_is_visible(oid) cost 10;
(You'll need to do it as superuser --- if it makes things worse, just
set the cost back to 1.)
Sometimes it does not match
valid tables at all, and sometimes
I am seeking advice on what the best setup for the following would be.
My company provides a hosted web calendaring solution for school
districts. For each school district we have a separate database. Each
database has 57 tables. There are a total of 649 fields in those
tables. Here is a
Scott Otis wrote:
I am seeking advice on what the best setup for the following would be.
My company provides a hosted web calendaring solution for school
districts. For each school district we have a separate database.
Each database has 57 tables.
Over the next couple of
On Fri, Oct 9, 2009 at 1:46 PM, Scott Otis scott.o...@intand.com wrote:
Over the next couple of months we will be creating an instance of our
solution for each public school district in the US which is around 18,000.
That means currently we would be creating 18,000 databases (all on one
Scott Carey sc...@richrelevance.com writes:
I've got 200,000 tables in one db (8.4), and some tools barely work. The
system catalogs get inefficient when large and psql especially has trouble.
Tab completion takes forever, even if I make a schema s with one table in
it and type s. and try and
hi
Josh Berkus wrote:
Stalin,
We are evaluating the options for having multiple databases vs. schemas on a
single database cluster for a custom grown app that we developed. Each app
installs same set of tables for each service. And the service could easily
be in thousands. so Is it better to
Hi All,
We are evaluating the options for having multiple databases vs. schemas on a
single database cluster for a custom grown app that we developed. Each app
installs same set of tables for each service. And the service could easily
be in thousands. so Is it better to have 1000 databases vs
Stalin,
We are evaluating the options for having multiple databases vs. schemas on a
single database cluster for a custom grown app that we developed. Each app
installs same set of tables for each service. And the service could easily
be in thousands. so Is it better to have 1000 databases vs
10 matches
Mail list logo