Re: [PERFORM] Postgresql in a Virtual Machine

2013-11-28 Thread Dong Ye
> There was some earlier comment in this discussion about not using NFS > datastores for Postgres VMDK's. Would you think you'd see a difference in > scalability behavior or performance in these tests if a NFS datastore would > be used instead? Provided the architecture is properly setup for tha

Re: [PERFORM] Postgresql in a Virtual Machine

2013-11-27 Thread Dong Ye
On Mon, Nov 25, 2013 at 4:00 PM, Gudmundsson Martin (mg) wrote: > > I would also make sure to check that the hypervisor does write to permanent > storage before returning to the VM with acknowledgement. > In the case of ESX, there is no such concern per http://kb.vmware.com/kb/1008542. As Heikki

Re: [PERFORM] dbt2 performance regresses from 9.1.6 to 9.2.1

2012-11-05 Thread Dong Ye
> You are using prepared statements, this makes me think that this > regression might be due to support for parameter specific plans for > prepared statements. [1] Can you run the test on both versions without > prepared statements and see if the regressions remains. Without prepare statement, we

[PERFORM] dbt2 performance regresses from 9.1.6 to 9.2.1

2012-11-01 Thread Dong Ye
Hi there, I work for VMware with our Postgres performance team. We recently came across a dbt2 performance regression from 9.1.6 to 9.2.1. We have done some profiling and don't see anything obvious. Would like to get some suggestions from the community where to investigate further. The average

[PERFORM] dbt2 performance regresses from 9.1.6 to 9.2.1

2012-10-31 Thread Dong Ye
Hi there, I work for VMware with our Postgres performance team. We recently came across a dbt2 performance regression from 9.1.6 to 9.2.1. We have done some profiling and don't see anything obvious. Would like to get some suggestions from the community where to investigate further. The average