| From: | "Michael Lawson (mshindo)" <michael(at)sphinix(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Processing Delay |
| Date: | 2009-11-25 00:38:44 |
| Message-ID: | c97a47b90911241638v18b13a82s79d98ced4b873944@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
We have a problem with a relatively small database at the moment that is
resulting in delays times between insertions and retrievals. An update is
applied to a single entry in a table and almost straight after that the same
record is read.
The problem we are encountering is a delay before we can read the updated
value. This delay can be up to 15 seconds in some cases.
We are inserting and retrieving data using JDBC, and the database in its
current state is relatively small. What can we do to tweak this and reduce
the apparent update time.
Regards
--
Michael Lawson (mshindo)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Konstantin Izmailov | 2009-11-25 01:03:03 | pg_attribute.attnum - wrong column ordinal? |
| Previous Message | Merlin Moncure | 2009-11-24 23:51:03 | Re: Re: I need help creating a composite type with some sort of constraints. |