| From: | "M(dot) Alaa ElGohary" <alaa(dot)elgohary(at)backandfront(dot)ws> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #4559: performance issue |
| Date: | 2008-12-02 13:40:56 |
| Message-ID: | 200812021340.mB2Deu1A025096@wwwmaster.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 4559
Logged by: M. Alaa ElGohary
Email address: alaa(dot)elgohary(at)backandfront(dot)ws
PostgreSQL version: 7.4.19
Operating system: FreeBSD 6.3
Description: performance issue
Details:
I have a POS application that performs end of day process in which data is
transfered from a set of tables to another this process stops completely
with no reason when i make a dump of the database and drop then create and
restore the dump the end of day process performs extremely fast with no
stopage
i need to know whats the reason that stops this process and why is it
overcome when i drop and restore the database and how can i solve this
without needing to drop and restore the database
thanks
| From | Date | Subject | |
|---|---|---|---|
| Next Message | chris wood | 2008-12-02 17:27:18 | BUG #4560: bug 4528 |
| Previous Message | Martin Pitt | 2008-12-02 13:29:28 | Re: Fall back to alternative tsearch dictionary directory |