Hello, I´ve installed postgresql 9.1 on ubuntu 12.04 with pgpoolII-3.3.3 and
pgPoolAdmin.
I´m trying to make a test with pgbench-tools to measure the performance of
postgresql.
So I move to the directory where is pgbench-tools and configure the config
file.
I try to execute this order:
sudo -u
You´ve been very helpful for me. Solved after downloading pgbench tools from
github https://github.com/gregs1104/pgbench-tools, it seems like I was using
an old version of pgbench-tools. Thanks for your help!
--
View this message in context:
http://postgresql.nabble.com/trying-to-run-pgbench-t
Hi, Carlos,
Wouldn't it be better if you used INT in 'codcep' in both tables (as
CEP/ZIP numbers are [0-9]{8})? Casting as Tom Lane suggested is also a
good alternative, yet I think it'd be much better if you used int in
both columns.
Regards,
Cesar
Let's se
Hi, im César, im developing an app that saves information included in
"pg_stat_activity" view in order to monitor querys. The objective of this
app is to gather information about querys that take to long to finish and
overload the server. I was wandering if I could see somehwere the
implementation
Hi, I have a Server with Fedora Core 11, Tomcat and Postgresql 8.3.
With Hardware:
* 8GB RAM
* 8 processors Intel Xeon E5520 @2.27GHz
* 250GB SATA DISK
Actually, it serves at most 250 connections.
The problem happends when it serves many many connections at a time, tables
and queries began to get
Hi, I wanted to know, if there is some configuration in order tables dont
get blocked for too long time?
Hello there,
I am having performance problem with new DELL server. Actually I have this
two servers
Server A (old - production)
-
2xCPU Six-Core AMD Opteron 2439 SE
64GB RAM
Raid controller Perc6 512MB cache NV
- 2 HD 146GB SAS 15Krpm RAID1 (SO Centos 5.4 y pg_xlog) (XFS no barr
;
> On Apr 3, 2012, at 8:20 AM, Cesar Martin wrote:
>
> Hello there,
>
> I am having performance problem with new DELL server. Actually I have this
> two servers
>
> Server A (old - production)
> -
> 2xCPU Six-Core AMD Opteron 2439 SE
> 64GB RAM
>
15:21, Tomas Vondra escribió:
> On 3.4.2012 14:59, Cesar Martin wrote:
> > Hi Mike,
> > Thank you for your fast response.
> >
> > blockdev --getra /dev/sdc
> > 256
>
> That's way too low. Is this setting the same on both machines?
>
> Anyway, set
OK Scott. I go to change this kernel parameter and will repeat the tests.
Tanks!
El 3 de abril de 2012 17:34, Scott Marlowe escribió:
> On Tue, Apr 3, 2012 at 9:32 AM, Scott Marlowe
> wrote:
> > On Tue, Apr 3, 2012 at 6:20 AM, Cesar Martin wrote:
> >> Hello there,
OK Scott. I go to change this kernel parameter and will repeat the tests.
Tanks!
El 3 de abril de 2012 17:34, Scott Marlowe escribió:
> On Tue, Apr 3, 2012 at 9:32 AM, Scott Marlowe
> wrote:
> > On Tue, Apr 3, 2012 at 6:20 AM, Cesar Martin wrote:
> >> Hello there,
uot;.
What is your opinion about the results??
I have noticed that since I changed the setting vm.zone_reclaim_mode = 0,
swap is totally full. Do you recommend me disable swap?
Thanks!!
El 3 de abril de 2012 20:01, Tomas Vondra escribió:
> On 3.4.2012 17:42, Cesar Martin wrote:
> >
nents, is
not the first problem we have with hardware in new machines.
El 4 de abril de 2012 19:16, Merlin Moncure escribió:
> On Wed, Apr 4, 2012 at 4:42 AM, Cesar Martin wrote:
> > Hello,
> >
> > Yesterday I changed the kernel setting, that said
> > Scott, vm.zone_r
me - I wonder if
> this is the issue with adaptive read policy, as mentioned in the
> xbitlabs report.
>
> Cesar, can you set the read policy to a 'read ahead'
>
> megacli -LDSetProp RA -LALL -aALL
>
> or maybe 'no read-ahead'
>
> me
.
Thank you all for your advice.
El 9 de abril de 2012 18:24, Cesar Martin escribió:
> Hi,
>
> Today I'm doing new benchmarks with RA, NORA, WB and WT in the controller:
>
> With NORA
> -
> dd if=/vol02/bonnie/DD of=/dev/null bs=8M count=16
Hello there,
I have PostgreSQL 8.3.18 server running on Centos 6.2 (2.6.32-220.7.1) with
this specs:
2x CPU AMD Opteron 6282
128GB RAM
Raid 10 (12HD 15k rpm 1GB cache) with data
Raid 10 (4HD 15k rpm 1GB cache) with xlog
Raid 1 (15k rpm 1GB cache shared with xlog) with system
On this server I hav
dware problem...
Thanks for your help.
2012/10/30 Josh Berkus
> Cesar,
>
> > On this server I have only one database with 312GB of data. The database
> > had run fine during 4 months, but from two months ago, during high work
> > load periods, the server is collapsed
Finally I resolv the problem
setting /sys/kernel/mm/redhat_transparent_hugepage/enabled to "never"
2012/11/2 Cesar Martin
> Hi Josh,
>
> Today is not the worse day for this issue, because Fridays DB have little
> workload... But I have this output:
>
> http://paste
unsubscribe-digest
19 matches
Mail list logo
