Skip site navigation (1) Skip section navigation (2)

Re: measure database contention

From: "Robert Haas" <robertmhaas(at)gmail(dot)com>
To: "Jaime Casanova" <jcasanov(at)systemguards(dot)com(dot)ec>
Cc: "psql performance list" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: measure database contention
Date: 2008-12-17 21:14:52
Message-ID: 603c8f070812171314y4a53f244k786beb0b97e903c4@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
> as you see, explain analyze says it will execute in 175.952ms and
> because of network transfer of data executing this from pgadmin in
> another machine it runs for 17s... but from time to time pgFouine is
> shown upto 345.11 sec

Well, 86000 rows is not enough to give PostgreSQL a headache, even on
mediocre hardware.  So I think that most likely culprit is the
application that is reading the data - pgadmin or pgFouine.

...Robert

In response to

pgsql-performance by date

Next:From: Craig RingerDate: 2008-12-19 01:25:29
Subject: Re: Fwd: Not so simple query and a half million loop
Previous:From: David ReesDate: 2008-12-17 19:59:14
Subject: Re: insert and Update slow after implementing slony.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group