> -Original Message-
> From: Greg Smith [mailto:g...@2ndquadrant.com]
> Sent: Monday, August 08, 2011 9:42 PM
> To: mark
> Cc: pgsql-performance@postgresql.org
> Subject: Re: [PERFORM] benchmark woes and XFS options
>
> I think your notion that you have an HP CCISS driver in this older
>
Sumeet Jauhar wrote:
Our application is running on Postgres 7.4.X . I agree that this is a
very old version of Postgres and we should have upgraded .
It's important to know the .X here. The latest 7.4 is 7.4.30:
http://www.postgresql.org/docs/7.4/static/release.html
If you're running a
Kevin Grittner wrote:
Claire Chang wrote:
shared_buffers = 32GB
I seem to remember seeing some benchmarks showing that performance
falls off after 10GB or 20GB on that setting.
Not even quite that high. I've never heard of a setting over 10GB being
anything other than worse th
Dusan Misic wrote:
I had done some testing for my application (WIP) and I had executed
same SQL script and queries on real physical 64-bit Windows 7 and on
virtualized 64-bit CentOS 6.
Both database servers are tuned with real having 8 GB RAM and 4 cores,
virtualized having 2 GB RAM and 2 v
I think your notion that you have an HP CCISS driver in this older
kernel that just doesn't drive your card very fast is worth exploring.
What I sometimes do in the situation you're in is boot a Linux
distribution that comes with a decent live CD, such as Debian or
Ubuntu. Just mount the susp
Hello PG perf junkies,
Sorry this may get a little long winded. Apologies if the formatting gets
trashed. Also apologies if this double posts. (I originally set it yesterday
with the wrong account and the message is stalled - so my bad there) if
someone is a mod and it's still in the wait queue
tuanhoanganh wrote:
> I can not change the query because it is generate by SymmetricDS
> program. So I only can create index on table and change config of
> postgres to tunning the query. Is there any way to do that?
I'm not familiar with SymetricDS. Would it be possible for you to
create a V
Thanks for your help. But I can not change the query because it is generate
by SymmetricDS program. So I only can create index on table and change
config of postgres to tunning the query. Is there any way to do that?
Sorry for my English
Tuan Hoang ANh
On Sat, Aug 6, 2011 at 11:26 PM, Kevin Grit
