| From: | Andrew Sullivan <andrew(at)libertyrms(dot)info> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Is there any limitations |
| Date: | 2002-12-03 12:34:04 |
| Message-ID: | 20021203073404.A5868@mail.libertyrms.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Mon, Dec 02, 2002 at 09:46:43PM -0800, li li wrote:
>
> for the maximum number of tables in a database.
<http://www.ca.postgresql.org/users-lounge/limitations.html>
For practical purposes, probably not.
> to get it separated once the size grows up to a limit. So there
> will be a large amount of tables (having same structure) in a database. Is
> there any potential performance problem with this design?
It depends on what you're going to do. If the idea is to join across
the tables, it'll probably perform worse than just ahving a large
table. OTOH, if what you're doing is, say, archiving from time to
time, it doesn't seem unreasonable.
A
--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nikk Anderson | 2002-12-03 13:41:14 | Re: Is there any limitations |
| Previous Message | Frank van Vugt | 2002-12-03 09:38:10 | Re: v7.2.3 versus v7.3 -> huge performance penalty for JOIN with UNION |