Question about performance - Postgres 9.5 - Mailing list pgsql-general

From Patrick B
Subject Question about performance - Postgres 9.5
Date
Msg-id CAJNY3itw+dNr2uz5Xs=42GC91XVuMWPhCiLzdcN2qQS5dxgaaQ@mail.gmail.com
Whole thread Raw
Responses Re: Question about performance - Postgres 9.5
Re: Question about performance - Postgres 9.5
List pgsql-general
Hi guys,

In the db I'm working one, it will be three tables:

visits, work, others.

Everything the customer do, will be logged. All inserts/updates/deletes will be logged.

Option 1: Each table would have its own log table.
visits_logs, work_logs, others_logs

Option 2: All the logs would be stored here...
log_table

Can you please guys tell me which option would be faster in your opinion, and why?

I'll be using PostgreSQL 9.5 - It's for a new product in the company that I work for, and it's being builded from the beginning. 


Cheers
Patrick

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Sequences, txids, and serial order of transactions
Next
From: Patrick B
Date:
Subject: Re: Question about performance - Postgres 9.5