pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedBig number of schemas (3500) into a single database
3+ messages / 3 participants
[nested] [flat]
* Big number of schemas (3500) into a single database
@ 2004-11-22 07:44 Constantin Teodorescu <teo@flex.ro>
0 siblings, 1 reply; 3+ messages in thread
From: Constantin Teodorescu @ 2004-11-22 07:44 UTC (permalink / raw)
To: pgsql-hackers@postgresql.org
Hello to everybody again,
thought you didn't hear any news from me for a very long time, the news are
good :-)
I'm still here and promoting PostgreSQL.
I am involved in the developing of a big romanian project for the vets that
will put Linux & PostgreSQL on 3500 computers in the whole country, linked
together with dial-up connections that will keep track of the animal
movements.
The central database (also PostgreSLQ) will hold billions of records with
animal events (births, movements, slaughter and so on) and my question is:
If I will choose to keep a mirror of every workstation database in a
separate schema in the central database that mean that I will have 3500
different schemas.
Is there any limit or any barrier that could stop this kind of approach or
make things go slower?
Constantin Teodorescu
Ancient PgAccess developer
P.S. Please Cc: me at teo@flex.ro
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Big number of schemas (3500) into a single database
@ 2004-11-24 05:32 Tom Lane <tgl@sss.pgh.pa.us>
parent: Constantin Teodorescu <teo@flex.ro>
0 siblings, 1 reply; 3+ messages in thread
From: Tom Lane @ 2004-11-24 05:32 UTC (permalink / raw)
To: teo@flex.ro; +Cc: pgsql-hackers@postgresql.org
"Constantin Teodorescu" <teo@flex.ro> writes:
> If I will choose to keep a mirror of every workstation database in a
> separate schema in the central database that mean that I will have 3500
> different schemas.
> Is there any limit or any barrier that could stop this kind of approach or
> make things go slower?
Would you need to put them all into "search_path" at once?
I'm not sure what the scaling issues might be for long search_paths, but
I wouldn't be surprised if it's bad. But as long as you don't do that,
I don't believe there will be any problems.
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [PERFORMANCE] Big number of schemas (3500) into a single database
@ 2004-11-24 17:11 Jaime Casanova <systemguards@yahoo.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 3+ messages in thread
From: Jaime Casanova @ 2004-11-24 17:11 UTC (permalink / raw)
To: pgsql-performance
--- Tom Lane <tgl@sss.pgh.pa.us> escribió:
> "Constantin Teodorescu" <teo@flex.ro> writes:
> > If I will choose to keep a mirror of every
> > workstation database in a
> > separate schema in the central database that mean
> > that I will have 3500 different schemas.
>
> > Is there any limit or any barrier that could stop
> > this kind of approach or make things go slower?
>
> Would you need to put them all into "search_path" at
> once?
>
> I'm not sure what the scaling issues might be for
> long search_paths, but I wouldn't be surprised if
> it's bad. But as long as you don't do that,
> I don't believe there will be any problems.
>
if i do a select with fully qualified table names it
will search in the search_path or it will go directly
to the schema?
Just for know.
regards,
Jaime Casanova
_________________________________________________________
Do You Yahoo!?
Información de Estados Unidos y América Latina, en Yahoo! Noticias.
Visítanos en http://noticias.espanol.yahoo.com
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2004-11-24 17:11 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-11-22 07:44 Big number of schemas (3500) into a single database Constantin Teodorescu <teo@flex.ro>
2004-11-24 05:32 ` Tom Lane <tgl@sss.pgh.pa.us>
2004-11-24 17:11 ` Jaime Casanova <systemguards@yahoo.com>
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