pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
few admin questions
2+ messages / 2 participants
[nested] [flat]

* few admin questions
@ 2002-03-15 15:41  Laurent N <laurent.nonnenmacher@wimba.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Laurent N @ 2002-03-15 15:41 UTC (permalink / raw)
  To: pgsql-sql

Hello, i begin to learn how to admin a postgreSQL database.
I would like to know some things like :
How do you calculate the length of a record in a table ?
How do you estimate the access time to a data in a table ?
How many records can i insert in this database (before the system
falls down) ?
If you had to insert a multimedia file (.wav) in this database, would
you do it or not ?

And where can i find these information ? (i read FAQ and technotes, no
results...)

Thanks a lot.





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

* Re: [SQL] few admin questions
@ 2002-03-20 22:35  Josh Berkus <josh@agliodbs.com>
  parent: Laurent N <laurent.nonnenmacher@wimba.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Josh Berkus @ 2002-03-20 22:35 UTC (permalink / raw)
  To: Laurent N <laurent.nonnenmacher@wimba.com>; +Cc: pgsql-novice@postgresql.org

Laurent,

As your question is not SQL-specific, I am posting my reply to
 pgsql-novice instead of pgsql-sql.

> I would like to know some things like :
> How do you calculate the length of a record in a table ?

For an estimate:  INT4 = 4 bytes
		VARCHAR (30) = 30bytes + 2 bytes = 32bytes
Look in the interactive docs under "data types" for the byte-storage
 requirements for other data types.  Then do some arithmatic.

> How do you estimate the access time to a data in a table ?

That is dependant on so many factors:  Disk storage size, speed and
 configuration, your PostgreSQL runtime settings, processor type,
 speed, what else is running on the system and its resource usage ...
 etc.

> How many records can i insert in this database (before the system
> falls down) ?

See the litany above.  It's the same answer.  Our current highest
 actual reported number of records in any one table is 300 million.
  But you'd better have the right hardware and configuration for that.

> If you had to insert a multimedia file (.wav) in this database, would
> you do it or not ?

I would  save it as a file and store a link in the database.  But not
 everyone agrees with me about that.

> And where can i find these information ? (i read FAQ and technotes,
>  no
> results...)

If you want direct answers, you will need to hire a consultant.  The
 online documentation has all of the data you need to figure out the
 above on your own, but it takes significant calculation and testing.

To summarize:  PostgreSQL is fully configurable.  As a result, nobody
 can tell the limits of your Postgres database without examining your
 actual system and experimenting with Postgres settings.

-Josh Berkus





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


end of thread, other threads:[~2002-03-20 22:35 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-03-15 15:41 few admin questions Laurent N <laurent.nonnenmacher@wimba.com>
2002-03-20 22:35 ` Josh Berkus <josh@agliodbs.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