public inbox for [email protected]help / color / mirror / Atom feed
PostgreSQL Objects design 3+ messages / 3 participants [nested] [flat]
* PostgreSQL Objects design @ 2023-04-20 16:01 kunwar singh <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: kunwar singh @ 2023-04-20 16:01 UTC (permalink / raw) To: [email protected] Hi Listers, I want to learn more about Table/Columns/Indexes design. - How big the columns should be? - How many number of columns should a table have at max? - How many rows a tables should have at max - What are size limitations of different data types Any books, blogs , videos, courses that you recommend I go over? I have been an Oracle DBA , but only from a support and tuning standpoint. I have never done this kind of work before, even in Oracle. So interested in learning in this area? Any approach that will speed up my learning? -- Cheers, Kunwar ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: PostgreSQL Objects design @ 2023-04-20 16:25 Steve Midgley <[email protected]> parent: kunwar singh <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Steve Midgley @ 2023-04-20 16:25 UTC (permalink / raw) To: kunwar singh <[email protected]>; +Cc: [email protected] On Thu, Apr 20, 2023 at 9:01 AM kunwar singh <[email protected]> wrote: > Hi Listers, > I want to learn more about Table/Columns/Indexes design. > > - How big the columns should be? > - How many number of columns should a table have at max? > - How many rows a tables should have at max > - What are size limitations of different data types > > > Any books, blogs , videos, courses that you recommend I go over? > > I have been an Oracle DBA , but only from a support and tuning standpoint. > I have never done this kind of work before, even in Oracle. So interested > in learning in this area? > > Any approach that will speed up my learning? > The Postgres docs, IMO, are astonishingly good. https://www.postgresql.org/docs/ -- Not what I tend to expect from open source projects, but there's a reason (again IMO) Postgres is the best database solution ever built. Regarding your specific question here are the current "hard" limits https://www.postgresql.org/docs/current/limits.html But recognize that the effective limits on your system are going to be lower, and based on your available ram, disk, and other resources. Stackoverflow might be a good place to understand more about these kinds of limits. I'll say that for my use cases, I've never had to worry about anything other than applying the right index or reworking my SQL statement to solve a particular problem in Postgres. So I'd say try to learn about various index techniques and how to use Postgres' SQL, as the starting place to learn. I think EnterpriseDB has good resources for those coming from Oracle as well.. Welcome to the light side! Steve ^ permalink raw reply [nested|flat] 3+ messages in thread
* PostgreSQL Objects design @ 2023-04-20 18:40 Wetmore, Matthew (CTR) <[email protected]> parent: Steve Midgley <[email protected]> 0 siblings, 0 replies; 3+ messages in thread From: Wetmore, Matthew (CTR) @ 2023-04-20 18:40 UTC (permalink / raw) To: Steve Midgley <[email protected]>; kunwar singh <[email protected]>; +Cc: [email protected] <[email protected]> Database Soup<http://www.databasesoup.com/; Also, create an account and sign up for postgres listservs. There are a couple to choose from. From: Steve Midgley <[email protected]> Sent: Thursday, April 20, 2023 11:25 AM To: kunwar singh <[email protected]> Cc: [email protected] Subject: [EXTERNAL] Re: PostgreSQL Objects design On Thu, Apr 20, 2023 at 9:01 AM kunwar singh <[email protected]<mailto:[email protected]>> wrote: Hi Listers, I want to learn more about Table/Columns/Indexes design. * How big the columns should be? * How many number of columns should a table have at max? * How many rows a tables should have at max * What are size limitations of different data types Any books, blogs , videos, courses that you recommend I go over? I have been an Oracle DBA , but only from a support and tuning standpoint. I have never done this kind of work before, even in Oracle. So interested in learning in this area? Any approach that will speed up my learning? The Postgres docs, IMO, are astonishingly good. https://www.postgresql.org/docs/<https://urldefense.com/v3/__https:/www.postgresql.org/docs/__;!!...; -- Not what I tend to expect from open source projects, but there's a reason (again IMO) Postgres is the best database solution ever built. Regarding your specific question here are the current "hard" limits https://www.postgresql.org/docs/current/limits.html<https://urldefense.com/v3/__https:/www.postgr...; But recognize that the effective limits on your system are going to be lower, and based on your available ram, disk, and other resources. Stackoverflow might be a good place to understand more about these kinds of limits. I'll say that for my use cases, I've never had to worry about anything other than applying the right index or reworking my SQL statement to solve a particular problem in Postgres. So I'd say try to learn about various index techniques and how to use Postgres' SQL, as the starting place to learn. I think EnterpriseDB has good resources for those coming from Oracle as well.. Welcome to the light side! Steve ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2023-04-20 18:40 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2023-04-20 16:01 PostgreSQL Objects design kunwar singh <[email protected]> 2023-04-20 16:25 ` Steve Midgley <[email protected]> 2023-04-20 18:40 ` Wetmore, Matthew (CTR) <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox