Re: [GENERAL] Problems with query in highly concurrent environment

2005-02-25 Thread Aleksei Valikov
Hi. 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! That is strange. Is this a networking issue? It is not. psql was executed on the same machine as the runnin

[GENERAL] Problems with query in highly concurrent environment

2005-02-24 Thread Aleksei Valikov
Hi. We have a very strange problem and no idea how to solve it. We have a PROGRESSION table that stores information about various telephony events. Rows are never updated, only inserted, about 20-30 thousand rows a day. Based on this table, we need to produce certain statistics, which are creat