| From: | "Mendola Gaetano" <mendola(at)bigfoot(dot)com> |
|---|---|
| To: | <pgsql-admin(at)postgresql(dot)org> |
| Cc: | "Dennis Oudijk" <dennis(at)emg(dot)ca> |
| Subject: | Re: Statistical Reporting |
| Date: | 2003-09-17 09:56:15 |
| Message-ID: | 006d01c37d01$ef3da620$152aa8c0@GMENDOLA2 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
"Dennis Oudijk" <dennis(at)emg(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vasilis Ventirozos | 2003-09-17 10:02:02 | Recycle The Wal logs |
| Previous Message | Gustavo Pérez | 2003-09-17 08:43:08 | dump among different versions of postgreSQL |