queries on different tables

Поиск
Список
Период
Сортировка
От preetika tyagi
Тема queries on different tables
Дата
Msg-id AANLkTim1FKqVVotxGF+1aMPWQjwy2B6izWkUM-FYr7aj@mail.gmail.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Ludovico Bonifacio
Дата:
Сообщение: TRigger catch delete on cascade from different table
Следующее
От: preetika tyagi
Дата:
Сообщение: Slow INSERT as compared to UPDATE