[PERFORM] Are there any performance penalty for opposite edian platform combinations....

mall edian host, are there any performance loss due to the edian difference? Thanks in advance for your opinions. Regards, Guoping Zhang ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [PERFORM] Performance penalty for remote access of postgresql (8.1.3)? any experiance?

't try now. Thanks for all the answers... Regards, Guoping Zhang -Original Message- From: Florian Weimer [mailto:[EMAIL PROTECTED] Sent: 2006Ae7OA20EO 0:18 To: Guoping Zhang Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] Performance penalty for remote access of postgres

Re: [PERFORM] Performance penalty for remote access of postgresql (8.1.3)? any experiance?

doing so as we do have performance requirement. I guess there shall be quite number of people out there facing the similar problem, right? No alternative solution? Regards, Guoping Zhang -Original Message- From: Florian Weimer [mailto:[EMAIL PROTECTED] Sent: 2006Ae7OA19EO 16:30 To

[PERFORM] Performance penalty for remote access of postgresql (8.1.3)? any experiance?

2.5 sys 3.2 c) Obviously, CPU time for (user + sys) for both tests are very similar, but the overall time is quite different. I assume the time used on TCP stack makes the difference. Many thanks, Regards, Guoping Zhang ---(end of bro

Re: [PERFORM] Is postgresql ca do the job for software deployed in ASP ou SaaS mode?

Hi, Chris,   In your deployment, can you put a bit more detail if available? Many thanks!   My questions are:    a)  How do you resolve the connection pool issue?   b)  If each client application has many threads of connections to the remote server, what is the likely performance penalt

Re: [PERFORM] how unsafe (or worst scenarios) when setting fsync OFF for postgresql

Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: 2006Äê4ÔÂ28ÈÕ 14:57 To: [EMAIL PROTECTED] Cc: pgsql-performance@postgresql.org; 'Guoping Zhang (E-mail)' Subject: Re: [PERFORM] how unsafe (or worst scenarios) when setting fsync OFF for postgresql "Guoping Zhang&quo

Re: [PERFORM] how unsafe (or worst scenarios) when setting fsync OFF for postgresql

erformance@postgresql.org; Guoping Zhang (E-mail) Subject: Re: [PERFORM] how unsafe (or worst scenarios) when setting fsync OFF for postgresql Guoping, On 4/27/06, Guoping Zhang <[EMAIL PROTECTED]> wrote: > We have to looking at setting fsync OFF option for performance reason, Did you try

Re: [PERFORM] how unsafe (or worst scenarios) when setting fsync

n Riggs Cc: [EMAIL PROTECTED]; pgsql-performance@postgresql.org; Guoping Zhang (E-mail) Subject: Re: [PERFORM] how unsafe (or worst scenarios) when setting fsync Simon Riggs <[EMAIL PROTECTED]> writes: > On Thu, 2006-04-27 at 16:31 +1000, Guoping Zhang wrote: >> Can we set fsync OFF fo

Re: [PERFORM] how unsafe (or worst scenarios) when setting fsync OFF for postgresql

Lane Sent: 2006Äê4ÔÂ28ÈÕ 0:53 To: [EMAIL PROTECTED] Cc: pgsql-performance@postgresql.org; Guoping Zhang (E-mail) Subject: Re: [PERFORM] how unsafe (or worst scenarios) when setting fsync OFF for postgresql "Guoping Zhang" <[EMAIL PROTECTED]> writes: > Our application has a st

[PERFORM] how unsafe (or worst scenarios) when setting fsync OFF for postgresql

Hi,. We are new to Postgresql. I am appreciated if the following question can be answered. Our application has a strict speed requirement for DB operation. Our tests show that it takes about 10secs for the operation when setting fsync off, but takes about 70 seconds when setting fsync ON (with ot