Re: [PERFORM] Suspected Postgres Datacorruption

2011-08-09 Thread Sumeet Jauhar
Yes the very fact that we are using a very very old version of Postgres is certainly causing alot of problems . On Fri, Aug 5, 2011 at 2:51 AM, Scott Marlowe wrote: > On Wed, Aug 3, 2011 at 1:35 AM, Sumeet Jauhar > wrote: > > > > > > Our application is running on Postgres 7.4.X . I agree that th

Re: [PERFORM] Suspected Postgres Datacorruption

2011-08-09 Thread Sumeet Jauhar
Thank you . Scott and Brad . Valuable information for sure . I plan to browse through the documentation for Postgres 9 and identify all the potential advantages that it will bring to our application . As rightly pointed out 8.2 may be on the path to obsolescence . On Friday, August 5, 2011, Scott

[PERFORM] XFS options and benchmark woes

2011-08-09 Thread mark
Hello PG perf junkies, Sorry this may get a little long winded. Apologies if the formatting gets trashed. Background: I have been setting up some new servers for PG and I am getting some odd numbers with zcav, I am hoping a second set of eyes here can point me in the right direction. (other

Re: [PERFORM] XFS options and benchmark woes

2011-08-09 Thread mark
> -Original Message- > From: mark [mailto:m...@sm-a.net] > Sent: Monday, August 08, 2011 12:15 AM > To: 'pgsql-performance@postgresql.org' > Subject: XFS options and benchmark woes > > Hello PG perf junkies, > > > Sorry this may get a little long winded. Apologies if the formatting > g

Re: [PERFORM] Performance die when COPYing to table with bigint PK

2011-08-09 Thread Robert Ayrapetyan
Yes, you are right. Performance become even more awful. Can some techniques from pg_bulkload be implemented in postgres core? Current performance is not suitable for any enterprise-wide production system. 2011/8/5 Віталій Тимчишин : > > In my tests it greatly depends on if index writes are random