Hi,
Chris,
In
your deployment, can you put a bit more detail if available? Many
thanks!
My
questions are:
a) How do you resolve the connection
pool issue?
b) If each client application has many threads of connections to the
remote server, what is the likely performance penalt
On Mon, 2006-07-03 at 22:31 +0200, Tomasz Ostrowski wrote:
> I have a very slow query when enable_seqscan=on and very fast when
> enable_seqscan=off. My schema looks like this (relevant columns
> only):
> PS. Actual table and column names are different (they're in Polish)
> but I've translated them
Richard Broersma Jr wrote:
Each table with-in the database is assigned an OID and is located inside the DB
directory. So if
there is a file-system limitation on the number of files with-in a given
directory it would also
be a limit to the number of tables that could be created for each databas
On 7/3/06, David Gagnon <[EMAIL PROTECTED]> wrote:
Can I hope having several hundred of db on 1 db server? Like 250 dbs =250 client = 360 000 tables !!!So is there a limit for the number of db in the db server ?(this spec isnot on the website)What about the performance? Can I expect to have the sa
> Typically I will have 1db per client and around 150 tables per db. So
> since I hope I didn`t work all those year for nothing .. I expect to
> have bunch of clients witch means the same amount of db since I have 1
> db/client.
>
> Can I hope having several hundred of db on 1 db server? Lik
Hi all,
I've been working on my personal project for 3.5 years now. I
developed an ERP system in web/java. Now the people I will work with
suggest to offers it in Saas mode. Which means my customer will connect
to my website and found they ERP software and data there. It's not the
deploy
Am Sonntag, 2. Juli 2006 23:50 schrieb Gene:
> Is there any way to create a reverse index on string columns so that
> queries of the form:
>
> where column like '%2345';
>
> can use an index and perform as fast as searching with like '2345%'?
>
> Is the only way to create a reverse function and cre
