| From: | Rob Sargent <robjsargent(at)gmail(dot)com> |
|---|---|
| To: | Judith Altamirano <jaltamirano(at)lux(dot)com(dot)mx> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Working slow |
| Date: | 2009-09-22 02:45:02 |
| Message-ID: | 4AB83A2E.6090404@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Judith Altamirano wrote:
> hello every body, I'm having a data base in a point of sale that is
> getting frozen, I already have run a vacuum -z -d to reindex the data
> base and nothing happens...... Some suggestions to speed the process,
> Do you guys think that the data base is nearly to broke?
>
>
As well as the good points Scott Marlow raised, does the application
perform well immediately after a reboot and then slowdown or do all
queries take longer than they should (and by how much)?
Do you have the sql for typical queries and can you run them with ANALYSE?
PS. (Based on the post time vs clock time, I suspect the you machine's
clock is out of sync)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Louis-David Mitterrand | 2009-09-22 09:44:57 | selecting latest record |
| Previous Message | Scott Marlowe | 2009-09-22 01:56:06 | Re: Working slow |