> From: Aleksei Valikov > <snip> > Moreover, what I find very strange is that when I log in with psql (or > any other SQL client) onto the production database and execute the same > query, it runs fast - even in peak hours! > <snip> That is strange. Is this a networking issue? Are your clients becoming memory bound (e.g. not enough RAM or poor garbage collection/memory leakage on the client side)? Best regards, Jim Wilson ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org