[check_postgres] Schema check is taking longer... why?

[Greg Sabino Mullane]

On Fri, Apr 08, 2011 at 01:38:53PM -0700, Aleksey Tsalolikhin wrote:
> Our same schema check used to take under 10 seconds to run, but now
> takes 8 - 45 seconds, and the time really varies.
> 
> Server and network loads appear the same, database load appears the
> same...   what might make the schema check take longer?  What should I
> look at?

I've held off replying to this as the same_schema action was being 
completely redesigned. It is mostly complete now - you might give 
the version in git a try and see how fast that is. If it's still slow, 
I'd like to know so we can improve it. The best way to check would be to 
look in your Postgres logs and see which of the queries it runs are the 
slowest, by setting log_min_duration_statement = 0.


-- 
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 163 bytes
Desc: not available
Url : https://mail.endcrypt.com/pipermail/check_postgres/attachments/20110711/27674cbe/attachment.bin