[SQL] select across two database

hi guys. I want know if it's possible create a select from 2 database or create a view in one of them. -- Jorge Andrés Medina Oliva. Systems Manager and Developer. BSDCHiLE. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql

[SQL] index find method?

hi list, when I do: CREATE INDEX name_index ON some_table (some_col); what method(hash,btree,rtree,etc.) use by default? -- Jorge Andrés Medina Oliva. Systems Manager and Developer. BSDCHiLE. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: htt

[SQL] more than 1000 connections

hi guys I know this list it's about SQL, but if somebody have a pgsql engine with 1000 or more concurrent connections please show me the postgresql.conf or if the pgpool work as a solution to this problem. thanks. -- Jorge Andrés Medina Oliva. Evolve or die! -- Sent via pgsql-sql mailing list

Re: [SQL] more than 1000 connections

On Wed, Aug 6, 2008 at 11:54 AM, Mark Roberts <[EMAIL PROTECTED]> wrote: > > On Wed, 2008-08-06 at 08:06 +0800, Craig Ringer wrote: >> Out of interest - why 1000 connections? >> >> Do you really expect to have 1000 jobs concurrently active and doing >> work? If you don't, then you'll be wasting res

Re: [SQL] more than 1000 connections

On Wed, Aug 6, 2008 at 1:38 PM, Scott Marlowe <[EMAIL PROTECTED]> wrote: > On Wed, Aug 6, 2008 at 11:29 AM, Jorge Medina <[EMAIL PROTECTED]> wrote: >> On Wed, Aug 6, 2008 at 12:47 PM, Scott Marlowe <[EMAIL PROTECTED]> wrote: >>> On Wed, Aug 6, 2008 at 10:4