Question about performance - Postgres 9.5

From: Patrick B <patrickbakerbr(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Question about performance - Postgres 9.5
Date: 2016-06-12 22:37:14
Message-ID: CAJNY3itw+dNr2uz5Xs=42GC91XVuMWPhCiLzdcN2qQS5dxgaaQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Patrick B 2016-06-12 23:02:51 Re: Question about performance - Postgres 9.5
Previous Message Tom Lane 2016-06-12 15:01:38 Re: Sequences, txids, and serial order of transactions