queries on different tables - Mailing list pgsql-students

From preetika tyagi
Subject queries on different tables
Date
Msg-id AANLkTim1FKqVVotxGF+1aMPWQjwy2B6izWkUM-FYr7aj@mail.gmail.com
Whole thread Raw
List pgsql-students
Hi

Could anyone please help me in understanding the internals of PostgreSQL? Whenever I execute queries on two different tables (same database) from two different clients simultaneously, it takes longer to execute that query for one of the client (execution time is less if I do not execute these queries simultaneously). I am confused why should the queries on completely different tables interfere with each other?

Thank you in advance!

Regards,
Preetika

pgsql-students by date:

Previous
From: Ludovico Bonifacio
Date:
Subject: TRigger catch delete on cascade from different table
Next
From: preetika tyagi
Date:
Subject: Slow INSERT as compared to UPDATE