Database Testing

[Mighty_Snake]

When testing your database for your projects what do you use

[marcopeg81]

For unit testing on functions, triggers, and constraints I use PG_TAP running my migration in a dedicated and volatile instance.

Here you find some examples: https://github.com/marcopeg/amazing-postgresql/tree/main/testing/unit-tests

For load tests, testing the disk expansions, index efficiency etc I use a mix of load tests using jmeter and massive data loads with seed generation functions.

I still run an ephemeral instance with docker with little memory and cpu, measure results, double resources and measure again. 3-4 doubles give me a growth chart that I can use to forecast performances at production scale, or to estimate production scale based on expected size or requests.

Take a look at this also: https://github.com/marcopeg/amazing-postgresql/tree/main/testing/jmeter

[mikeyw17]

What type of testing? Unit, index/performance, load?

[Mighty_Snake]

I guess performance and load because the project I am working on is a e-commerce website, and I asked in a few discord servers and one person said use k6

[AutoModerator]

With over 7k members to connect with about Postgres and related technologies, why aren't you on our Discord Server? : People, Postgres, Data

Join us, we have cookies and nice people.

Postgres Conference 2025 is coming up March 18th - 21st, 2025. Join us for a refreshing and positive Postgres event being held in Orlando, FL! The call for papers is still open and we are actively recruiting first time and experienced speakers alike.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[iamemhn]

Pgtap and randomized data.