Statistical Reporting

From: "Dennis Oudijk" <dennis(at)emg(dot)ca>
To: pgsql-admin(at)postgresql(dot)org
Subject: Statistical Reporting
Date: 2003-09-16 22:47:02
Message-ID: bk83tj$13t5$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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?

Thanks in Advance.

Dennis (a non-technical person)

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Vasilis Ventirozos 2003-09-17 07:06:18 Re: File Sytems Types and Os Recomendations
Previous Message Gustavo Pérez 2003-09-16 22:22:50 After many tests to dump