pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedMaximum Number Tables
3+ messages / 3 participants
[nested] [flat]
* Maximum Number Tables
@ 2004-04-12 04:28 Ashvinder Singh <ashvindersingh@hfcl.com>
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-15 14:26 Robert Treat <xzilla@users.sourceforge.net>
parent: Ashvinder Singh <ashvindersingh@hfcl.com>
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-15 23:33 Tom Lane <tgl@sss.pgh.pa.us>
parent: Robert Treat <xzilla@users.sourceforge.net>
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