pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Maximum Number Tables
3+ messages / 3 participants
[nested] [flat]

* Maximum Number Tables
@ 2004-04-12 04:28 Ashvinder Singh <ashvindersingh@hfcl.com>
  2004-04-15 14:26 ` Re: Maximum Number Tables Robert Treat <xzilla@users.sourceforge.net>
  0 siblings, 1 reply; 3+ messages in thread

From: Ashvinder Singh @ 2004-04-12 04:28 UTC (permalink / raw)
  To: pgsql-admin

Hi All, 
I have a query.
What is the maximum number of tables I can have in a PGSql Database, without affecting performance?
Thanks in advance.
Regards,
Ashvinder

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Maximum Number Tables
  2004-04-12 04:28 Maximum Number Tables Ashvinder Singh <ashvindersingh@hfcl.com>
@ 2004-04-15 14:26 ` Robert Treat <xzilla@users.sourceforge.net>
  2004-04-15 23:33   ` Re: Maximum Number Tables Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 3+ messages in thread

From: Robert Treat @ 2004-04-15 14:26 UTC (permalink / raw)
  To: Ashvinder Singh <ashvindersingh@hfcl.com>; +Cc: pgsql-admin

On Mon, 2004-04-12 at 00:28, Ashvinder Singh wrote:
> Hi All, 
> I have a query.
> What is the maximum number of tables I can have in a PGSql Database,
> without affecting performance?
> Thanks in advance.
> Regards,
> Ashvinder

The number of tables is irrelevant, it's whats stored in the tables and
how you plan on using them that makes the difference. And even then it's
dependent on your hardware more than PostgreSQL itself. 

Robert Treat
-- 
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Maximum Number Tables
  2004-04-12 04:28 Maximum Number Tables Ashvinder Singh <ashvindersingh@hfcl.com>
  2004-04-15 14:26 ` Re: Maximum Number Tables Robert Treat <xzilla@users.sourceforge.net>
@ 2004-04-15 23:33   ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 3+ messages in thread

From: Tom Lane @ 2004-04-15 23:33 UTC (permalink / raw)
  To: Robert Treat <xzilla@users.sourceforge.net>; +Cc: Ashvinder Singh <ashvindersingh@hfcl.com>; pgsql-admin

Robert Treat <xzilla@users.sourceforge.net> writes:
> On Mon, 2004-04-12 at 00:28, Ashvinder Singh wrote:
>> What is the maximum number of tables I can have in a PGSql Database,
>> without affecting performance?

> The number of tables is irrelevant,

Not necessarily ... if you are using a filesystem in which directory
lookups in large directories are inefficient, you could have a problem,
since each table will correspond to a file within the database
directory.  If you're planning on having more than a few thousand
tables you'll want to choose a filesystem that copes well with large
directories.

But having said that, an application that needs several thousand
distinct tables is usually an application that needs a redesign.
Consider folding the data into fewer tables with more key columns.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2004-04-15 23:33 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-04-12 04:28 Maximum Number Tables Ashvinder Singh <ashvindersingh@hfcl.com>
2004-04-15 14:26 ` Robert Treat <xzilla@users.sourceforge.net>
2004-04-15 23:33   ` Tom Lane <tgl@sss.pgh.pa.us>

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