Hi all, WE currently use PG for the local database on our POS workstations in shops. Data is then extracted and sent back to head office. Also product updates etc are regularly sent to the shops. I have noticed over time that the shop PG databases get slower and slower. If I do a pg_dump, recreate the database and then restore the data - all speed problems are gone and the database folder shrinks in size substantially.
>From this information could anyone tell me what are the likely causes and what we may >or may not be doing in our extractions and updates that are not good PG insert, >update, delete procedures Thanks Chris Stokes Senior Systems Consultant Bass Software Phone: +61 3 8415 9305 (Direct) Fax: +61 3 9427 1752 Mobile: +61 409 851 447 [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> www.basssoftware.com <http://www.basssoftware.com/> Level 5 534 Church Street Richmond, Victoria, 3121, Australia ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
