Re: More 8.2 client issues (Was: [Slow dump?)

From: "Guillaume Smet" <guillaume(dot)smet(at)gmail(dot)com>
To: "Erik Jones" <erik(at)myemma(dot)com>
Cc: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-performance(at)postgresql(dot)org
Subject: Re: More 8.2 client issues (Was: [Slow dump?)
Date: 2007-01-03 16:50:41
Message-ID: 1d4e0c10701030850h78f19e74hfa7c25c01ded9a61@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Erik,

Could you set log_min_duration_statement=0 on your server and enable
logging (tutorial here if you don't know how to do that:
http://pgfouine.projects.postgresql.org/tutorial.html)

You should see which queries are executed in both cases and find the
slow one easily.

Regards,

--
Guillaume

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2007-01-03 16:56:20 Re: More 8.2 client issues (Was: [Slow dump?)
Previous Message Erik Jones 2007-01-03 16:40:56 Re: More 8.2 client issues (Was: [Slow dump?)