Re: How can I set up Postgres to use given amount of RAM?

[Zahid Rahman]

https://severalnines.com/database-blog/architecture-and-tuning-memory-postgresql-databases


On Sun, 26 Jun 2022, 11:40 pm W.P.,  wrote:

> Question in topic:
>
> "How can I set up Postgres to use given amount of RAM?"
>
> I have now laptop with 8GB of RAM, i can see Linux uses no more than 2-3GB.
>
> So my question is how to FORCE PostgreSQL
>
> use let's say 2-4Ghow to B of RAM for caching tables  I run queries on?
>
> As I can see disk actity running queries.
>
>
> W.P..
>
>
>
>

Re: database designs ERDs

[Zahid Rahman]

This most invaluable link on database designs is now broken.
 http://databaseanswers.org/data_models/index_all_models.htm

Has it moved somewhere or is there a similar page ?

Regards
Zahid

https://github.com/zahidr/zahidr
https://www <https://Backbutton.org>.backbutton.org
¯\_(ツ)_/¯
♡۶♡ ۶♡۶

<http://www.backbutton.co.uk>


<http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
Virus-free.
www.avg.com
<http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

On Thu, 28 Oct 2021 at 19:45, Thomas Kellerer  wrote:

> Zahid Rahman schrieb am 28.10.2021 um 12:58:
> > I am looking for some database designs (ERD) on current and up to date
> > business scenarios for a project.
> >
> > By update to date I am referring to the DVD rental business ERD,
> >
> https://www.postgresqltutorial.com/wp-content/uploads/2018/03/printable-postgresql-sample-database-diagram.pdf
> >
> > Although comprehensive, it is a bit outdated.  I mean BlockBusters was
> > useful in its time.
>
> Something like this maybe?
>
> http://databaseanswers.org/data_models/index_all_models.htm
>
>
>
>

Database designs

[Zahid Rahman]

Hi,
This link with hundreds of database designs is  expired.

http://databaseanswers.org/data_models/index_all_models.htm

Is there a similar  website with database designs  ?



https://www.backbutton.org

¯\_(ツ)_/¯
♡۶♡ ۶♡۶

database designs ERDs

[Zahid Rahman]

Hi,

I am looking for some database designs (ERD) on current and up to date
business scenarios for a project.

By update to date I am referring to the DVD rental business ERD,
https://www.postgresqltutorial.com/wp-content/uploads/2018/03/printable-postgresql-sample-database-diagram.pdf

Although comprehensive, it is a bit outdated.  I mean BlockBusters was
useful in its time.


Thanks
Zahid

https://www.backbutton.org
¯\_(ツ)_/¯
♡۶♡ ۶♡۶

Re: database designs ERDs

[Zahid Rahman]

 > Something like this maybe?


 > http://databaseanswers.org/data_models/index_all_models.htm


DEFINITELY exactly   this.

A lot of Respect.


Best Regards

Zahid

On Thu, 28 Oct 2021, 15:45 Thomas Kellerer,  wrote:

> Zahid Rahman schrieb am 28.10.2021 um 12:58:
> > I am looking for some database designs (ERD) on current and up to date
> > business scenarios for a project.
> >
> > By update to date I am referring to the DVD rental business ERD,
> >
> https://www.postgresqltutorial.com/wp-content/uploads/2018/03/printable-postgresql-sample-database-diagram.pdf
> >
> > Although comprehensive, it is a bit outdated.  I mean BlockBusters was
> > useful in its time.
>
> Something like this maybe?
>
> http://databaseanswers.org/data_models/index_all_models.htm
>
>
>
>

Re: Advice on cluster architecture for two related, but distinct, use cases

[Zahid Rahman]

Perhaps a 14 minute investment in this article may prove fruitful.

https://medium.com/@martin.hodges/adding-a-postgres-high-availability-database-to-your-kubernetes-cluster-634ea5d6e4a1



On Thu, 7 Nov 2024, 21:06 Matthias Leisi,  wrote:

> Dear all,
>
> (This is a follow-up to a question I asked almost exactly a year ago,
> https://postgrespro.com/list/thread-id/2670756#726f3765-858c-4ac0-a7b0-5cb6720e4...@leisi.net
>  -
> the requirements have changed since then, and the platform has changed from
> OpenBSD to Linux, which may make some things easier.)
>
>
> I’m looking for advice on Postgres cluster architecture(s) for two related
> but distinct use cases. Ideally, the approaches for the two use cases would
> not differ too widely.
>
> The goal of clustering is low RPO (I guess we need sync clustering) and
> RTO (ideally almost-instant failover, but a failover process of up to a
> minute in the worst case could be acceptable); throughput is not a concern
> (it’s relatively low transaction volume except for some often-written
> statistics data, which is still moderate). Latency (due to the distance
> between datacenters for georedundancy) is a fact we are willing to accept.
>
>
> The first use case is in an environment under our own control (and where
> eg a DBA could intervene). We can theoretically run any number of cluster
> instances, but assume we would use an even number (split over the two
> datacenters), or potentially an odd number of nodes (eg with an arbiter).
> We could use a load balancer, but I guess this would strongly deviate from
> the second use case:
>
>
> In the second use case, the environment is not under our control, so we
> can only assume basic network connectivity from the application to the DB,
> and between the DBs (the latter potentially through an SSH tunnel if
> needed). In this use case, we can not assume a person to intervene if a
> node goes down, and would prefer some automated failover to the other node
> (this automation would also be welcome for the first use case, eg if
> something happens while nobody is watching). We can not assume eg a load
> balancer.
>
> There could be various ways how the environment in the second use case is
> set up, ranging from „application and database running on the same box“
> (well, no clustering for you then…), to dedicated two- or three node
> database cluster serving a number of application machines.
>
>
> In both use cases, we have full control over the application and the
> database code and environment.
>
> From reading various docs, it seems we would need something like Patroni
> (/Percona), at least for the first use case. However it seems relatively
> complex to set up and operate.
>
> I would appreciate your experience and input into which approach would
> best fit the two use cases. We are also willing to engage in paid
> consulting.
>
> Thanks,
> — Matthias
>
> --
> Matthias Leisi
> Katzenrütistrasse 68, 8153 Rümlang
> 
> Mobile +41 79 377 04 43
> matth...@leisi.net
>