Nicolas,
The more data your tables contain the more work
PostgreSQL needs to do. Adding indexes on your tables
makes the INSERTS slower due to additional overhead.
Indexes speed up SELECT but slow down INSERT.
Therefore OLTP systems tend to have few indexes and
data warehouses many.
Instead o
Hi all,I have developped a perl script to populate a database with two tables: sessionsand actions.the table actions contains the following columns: session_id, url, timestamp.The column session_id references to the table sessions.the table sessions contains the following columns: session_id, remo
