pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / 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