Thread: Re: Statistical Reporting

Re: Statistical Reporting

From
"Mendola Gaetano"
Date:
"Dennis Oudijk" <dennis@emg.ca> 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