Re: [BUGS] BUG #5055: Invalid page header error

2009-09-15 Thread postgres bee
> Was there any particular event that marked the onset of these issues? > Anything in the system logs (dmesg / syslog etc) around that time? Unfortunately, cannot recall anything abnormal. > Was Pg forcibly killed and restarted, or the machine hard-reset? (This > _shouldn't_ cause data corrupti

[BUGS] Inserts taking exponentially longer as table size grows

2009-12-15 Thread postgres bee
We have seen a strange situation with postgres 8.3.6 taking longer times for inserting a fixed amount of data. The insertion time is increasing as the data in the table is growing. We tried to use COPY command but to no avail. The increase is also not linear. Insert is one of the basic oper