On Sat, Oct 10, 2009 at 8:44 AM, Chris Kratz 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 regex match
On Fri, Oct 9, 2009 at 11:11 PM, Tom Lane wrote:
> Scott Carey 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" wit
On Fri, Oct 9, 2009 at 10:50 PM, Scott Carey wrote:
> On 10/9/09 2:02 PM, "Merlin Moncure" wrote:
>
>> On Fri, Oct 9, 2009 at 1:46 PM, Scott Otis 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 aroun
Scott Carey 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 tab complete --
On 10/9/09 2:02 PM, "Merlin Moncure" wrote:
> On Fri, Oct 9, 2009 at 1:46 PM, Scott Otis 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
On Fri, Oct 9, 2009 at 1:46 PM, Scott Otis 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 server
> right now – w
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 months
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 ta
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 ha
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 1000
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
11 matches
Mail list logo
