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