"Dennis Oudijk" <[EMAIL PROTECTED]> wrote: > We run an apartment rental websites where people can post the rental > properties that are available to rent. > > We currently have a statistics feature that provides landlords with > information such as 'how many time has their property come up in a search' > and 'how many times have people clicked on the rental property in the search > result to view the complete details'. > > This queries our database and seems to place a heavy load on our server. we > are thinking of using replication so that we can query the offline server > (backup server) so that we do not task the live server however we understand > that currently there is not a stable replication solution for Postgresql > 7.32 > > Does anybody have any suggestion on how to handle this query more > efficiently?
Which query ? Show as, the query, table definition, and the explain analyze on that query. Regards Gaetano Mendola ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
