Skip site navigation (1) Skip section navigation (2)

BUG #4559: performance issue

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 (view raw or flat)
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

Responses

pgsql-bugs by date

Next:From: chris woodDate: 2008-12-02 17:27:18
Subject: BUG #4560: bug 4528
Previous:From: Martin PittDate: 2008-12-02 13:29:28
Subject: Re: Fall back to alternative tsearch dictionary directory

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group