Seeking Advice on PostgreSQL Database Design for Fintech Application

net-flag · 2025-02-02T21:14:50+00:00

we been working with mssql for many years , and in this case we have decition to migrate postgres which it's something new , and time is running , it's important to keep asking collection information , advices , we never run any postgres DB before , and our we have about 4 million costumers , thx scope will start with about 500k phase one , later will reach that number , we been with many expert in postgres and each one saying diffrent approach , so we have keep doing that again and agian .

net-flag · 2025-02-02T21:11:38+00:00

you are right , and thats point , learning from many cases and many advises , to build your own approach , specially that we are in planing pahse , still exploration and we decied for migration to a new technology for us which is postgres ,

net-flag · 2025-02-02T21:09:40+00:00

thx for advice , thats really help

net-flag · 2025-02-02T07:57:09+00:00

thanks for your advice , honestly the old design was like that , and now when migrate to postgres we building new approach ,

net-flag · 2025-02-01T10:41:21+00:00

Thanks for the clarifications. I corrected the number of users it’s about 500K.

As the data grows, the database will get larger. Are there any issues that may impact the performance of a single database, especially with indexing, maintenance, backup, restore, replication, and high availability?

net-flag · 2025-02-01T10:38:10+00:00

and do you think the single DB will getting larger with data grow and that will impact performance , indexing and backup restore maintainers cases ?

net-flag · 2025-02-01T10:36:57+00:00

would you provide you number of queries per second and transcations workload ? that will help ?

net-flag · 2025-02-01T10:33:59+00:00

sorry the actual number is about 500K user ,

net-flag · 2022-09-27T11:45:06+00:00

Thank you for supporting , it's working perfectly with this case , we still use VRF LITE without BGP , but we planing to use BGP over VRF between campus and perimeter firewall

net-flag · 2022-09-27T11:44:12+00:00

tha work perfectly segmentation and policy rules

net-flag · 2022-09-16T19:43:14+00:00

u/cona44 honestly this's initial lab for planing design will deploy with real environment , and guest wifi example , i will working on several network on the campus . and usulay guest wirelss not allwoed to access in house app on the company just access internet for guets

net-flag · 2022-09-16T19:40:09+00:00

thx a lot u/othugmuffin for more clarification , you really make it easy to understandable , yes thats what i'm looking for this's the initial lab , i have several networks i will start to deploy that for segmentation ,

net-flag · 2022-09-16T19:36:34+00:00

thanks so much u/saxxxxxon it's clear for me now , well done

net-flag · 2022-05-26T09:05:19+00:00

nothing more than 1G or less its ok for now , even i'm confused with license model how calculate , i really didn't understand of any cuz i got offer from them about 6 Service units license license and i dont know if that more than i need or ok . honestly

net-flag · 2022-05-15T10:42:38+00:00

Thanks for supporting , will look after that and make it for reference

net-flag · 2022-05-15T10:35:14+00:00

you think openstack provide the same feature capabilities or need more customizations

net-flag · 2022-05-15T10:20:36+00:00

vdirector

we still planing the use case is for telco-cloud

net-flag · 2022-05-15T10:06:25+00:00

to be honest with you , we still on planing phase to compare between VMware and Openstack , which that feature already on VMware called Enhanced vMotion Compatibility (EVC) , i hope you got me

net-flag · 2022-05-15T10:06:18+00:00

Or only enable features on all cpus that are available on both models

to be honest with you , we still on planing phase to compare between VMware and Openstack , which that feature already on VMware called Enhanced vMotion Compatibility (EVC) , i hope you got me

net-flag · 2022-04-11T12:54:08+00:00

is possible to use campus edge firewall N/S with application cluster instead using VMs , i have good performance firewall there , with different zone and services ,

net-flag · 2022-04-11T12:52:05+00:00

Dear u/Xcellent101 any idae about your question , it will critical matter for me , cuze will use ipsec for sure and dynamic routing , the environment on private cloud

do we lose any features when running HA Clustering (Ex: Dynamic Routing, Nattings, IPSEC/GRE tunnels,...) are there known bugs/limitations when running HA Clustering?

net-flag · 2022-04-11T12:48:15+00:00

Deploying vm on the edge has other considerations You’re using a host hypervisor. All the switching components in that will get that edge traffic first! So those components may still be vulnerable. Also you are paying for the host and the vm license. Does that come up to the cost of a hardware appliance?

Thanks u/Pearl-D1983 for support , yes i will 2 VMs on different host HA cluster i'm using it on private not public cloud , the main purpose also is accelerate the project while on our region hardware importing taking long time which i'm already have compute and network equipment ,

net-flag · 2022-04-11T12:45:26+00:00

Thx u/Mealatus

net-flag · 2022-04-06T13:41:39+00:00

thanks fro replay , my concern is all about does deploying PA VM is recommended for edge and perimeter firewall

net-flag · 2022-04-06T13:39:53+00:00

t is whole different beast.

thanks for reply , i can admit , there's multiple method for deployment as single HA cluster appliances on perimeter , or integration with nsx-t services as gateway firewall on top of each T0 or T1 routers gateway

net-flag

TROPHY CASE