On Mon, 2007-10-22 at 15:40 +0200, Cédric Villemain wrote:
> Does postgresql use posix_fallocate ?
No.
-Neil
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL P
Deblauwe Gino wrote:
> a) I didn't see a reindex in your mail. That's why a backup and a
> restore work and a vacuum doesn't
> http://www.postgresql.org/docs/current/static/sql-reindex.html
> Do this at least daily with that many inserts
>
Hello
I'am sorry to say that this advice does not soun
On Mon, 2007-10-22 at 05:13 -0700, Tiago J. Adami wrote:
> Hi all, I'm working for a brazillian company developing and
> maintaining a ERP sw that uses PostgreSQL as it main OLTP database
> system. We're just to start the migration to IBM DB2 because of many
> performance issues. I searched the so
Gregory Stark a écrit :
"Tiago J. Adami" <[EMAIL PROTECTED]> writes:
The issue topics:
1) As the database grows on our customers, lower performance occurs. After
one week of use, the I/O on database is extremely high. It appears that
VACUUM FULL and/or VACUUM ANALYZE doesn't work on this dat
Tiago J. Adami schreef:
Hi all, I'm working for a brazillian company developing and
maintaining a ERP sw that uses PostgreSQL as it main OLTP database
system. We're just to start the migration to IBM DB2 because of many
performance issues. I searched the solution for these performance
problems
"Tiago J. Adami" <[EMAIL PROTECTED]> writes:
> The issue topics:
> 1) As the database grows on our customers, lower performance occurs. After
> one week of use, the I/O on database is extremely high. It appears that
> VACUUM FULL and/or VACUUM ANALYZE doesn't work on this databases.
VACUUM FULL i
Tiago J. Adami wrote:
> The issue topics:
> 1) As the database grows on our customers, lower performance occurs. After
> one week of use, the I/O on database is extremely high. It appears that
> VACUUM FULL and/or VACUUM ANALYZE doesn't work on this databases.
That sounds like a classic case of "y
