Re: [PERFORM] Any advice tuning this query ?

Hi, On Fri, 2016-11-11 at 16:19 +0100, Henrik Ekenberg wrote: > Sort Method: external merge  Disk: 16782928kB This query is generating 16GB temp file on disk. Is this the amount of data you want to sort? Regards, -- Devrim GÜNDÜZ EnterpriseDB: http://www.enterprisedb.com Postgre

Re: [PERFORM] Error install -pgmemcache

package. Still, I just uploaded the RPM package to yum repo: http://yum.postgresql.org/9.3/redhat/rhel-6-x86_64/repoview/pgmemcache-93.html Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certif

Re: [PERFORM] HT on or off for E5-26xx ?

ther 6-core CPU would give more benefit. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter:

[PERFORM] Cost of creating an emply WAL segment

we see a delay? I was looking at how Oracle manages this, and I was told that you can create empty segments during installation, so I'm wondering whether it might be a good addition to initdb or not: initdb -S 30 -- create 30 empty segments during initdb Regards, -- Devrim GÜNDÜZ Prin

Re: [PERFORM] The good, old times

too, but I won't promise that now. Please keep looking at http://yum.pgrpms.org for updates. Regards, -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org, devrim.gunduz~l

Re: [PERFORM] Running PostgreSQL as fast as possible no matter the consequences

have enough RAM. It will fast, really. -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz s

Re: [PERFORM] Slow count(*) again...

it under the official RedHat Network channels if you're > using a subscription from them. I'm not sure exactly what the support > situation is with it, but it's definitely available as an RPM from > RedHat. Right. It is called "Red Hat Scalable File System", a

Re: [PERFORM] sudden spurt in swap utilization (was:cpu bound postgresql setup.)

On Fri, 2010-06-25 at 15:25 +0530, Rajesh Kumar Mallah wrote: > shared_buffers = 10GB # min 128kB > work_mem = 512MB# min 64kB These are still pretty high IMHO. How many *concurrent* connections do you have? -- Devrim GÜNDÜZ PostgreSQL Dan

Re: [PERFORM] Large (almost 50%!) performance drop after upgrading to 8.4.4?

ew packages were built with debugging options or not. -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgun

Re: [PERFORM] File system choice for Red Hat systems

On Wed, 2010-06-02 at 15:06 +1200, Mark Kirkwood wrote: > What are Red Hat using people choosing for a good performing > filesystem? ext2 (xlogs) and ext3 (data). For xfs, you may want to read this: http://blog.2ndquadrant.com/en/2010/04/the-return-of-xfs-on-linux.html Regards, --

Re: [PERFORM] Testing FusionIO

On Mon, 2010-03-08 at 09:38 -0800, Ben Chobot wrote: > We've enjoyed our FusionIO drives very much. They can do 100k iops > without breaking a sweat. Yeah, performance is excellent. I bet we could get more, but CPU was bottleneck in our test, since it was just a demo server :( -- De

[PERFORM] Testing FusionIO

Hi, I have a FusionIO drive to test for a few days. I already ran iozone and bonnie++ against it. Does anyone have more suggestions for it? It is a single drive (unfortunately). Regards, -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository

Re: [PERFORM] bgwriter, checkpoints, curious (seeing delays)

utes, and bump it to 30 mins if needed. Also you may want to decrease segments value based on your findings, since increasing only one of them won't help you a lot. As I wrote before, pg_stat_bgwriter is your friend here. -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified E

Re: [PERFORM] bgwriter, checkpoints, curious (seeing delays)

there, if you are running 8.3+, pg_stat_bgwriter will help you to tune checkpoint & bgwriter settings. -HTH. -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twi

Re: [PERFORM] New server to improve performance on our large and busy DB - advice?

On Thu, 2010-01-21 at 13:44 -0300, Alvaro Herrera wrote: > I think Devrim publishes debuginfo packages which you need to install > separately. Right. -- Devrim GÜNDÜZ, RHCE Command Prompt - http://www.CommandPrompt.com devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.t

Re: [PERFORM] Best suiting OS

tream is releasing a security update, I'd like to be able to find new packages as upstream announces updated sets. Yes, I'm talking about PostgreSQL here. -- Devrim GÜNDÜZ, RHCE Command Prompt - http://www.CommandPrompt.com devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr

Re: [PERFORM] Best suiting OS

'd use Ubuntu. Nothing else. ...and disclaimer: I don't work for Red Hat. -- Devrim GÜNDÜZ, RHCE Command Prompt - http://www.CommandPrompt.com devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signatu

Re: [PERFORM] Best suiting OS

r "own version" ;) -- Devrim GÜNDÜZ, RHCE Command Prompt - http://www.CommandPrompt.com devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part

Re: [PERFORM] Best suiting OS

to Linux-2.6.31.1 right now: > http://www.kernel.org/ > > So any comparisons between operating system *distributions* should be > fair. Comparing a 2007 release to a 2009 release, for example, is not > fair. RHEL / CentOS are basically out of the running right now, > b

Re: [PERFORM] Best suiting OS

> unlikely to suffer the same fate. This is nonsense. Both Debian, Fedora, Red Hat, CentOS and OpenSUSE has automated build tools and QA. -- Devrim GÜNDÜZ, RHCE Command Prompt - http://www.CommandPrompt.com devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.g

Re: [PERFORM] [QUESTION]Concurrent Access

epends on the size of your database. See the link below. > How big could be my database Depends on your disk ;) There is no PostgreSQL limitation for that. Well, there is a limit for tables, etc: http://www.postgresql.org/docs/faqs.FAQ.html#item4.4 -HTH. -- Devrim GÜNDÜZ devrim~gunduz.or

Re: [PERFORM] Hot Issue

On Wed, 2008-07-02 at 18:41 +0530, Gauri Kanekar wrote: > hot have a limitation that it do not work if, the index column is > updated. It is one of the conditions -- it also needs to fit in the same block. Regards, -- Devrim GÜNDÜZ devrim~gunduz.org, devrim~PostgreSQL.org, devrim.

Re: [PERFORM] Hot Issue

77724* *6237242* *0* *2924948* > * > 18460676* *131103* table2 435558 1579613 0 763397 1171497 42476 Maybe those updates were not qualified for HOT between these days? Regards, -- Devrim GÜNDÜZ devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://w

Re: [PERFORM] More shared buffers causes lower performances

Hi, On Wed, 2007-12-26 at 18:35 -0500, Greg Smith wrote: > Probably need to put a disclaimer about that fact *somewhere*. We mention about that in README.rpm-dist file, but I think we should mention about that at a more visible place. Regards, -- Devrim GÜNDÜZ , RHCE PostgreSQL Replicat

Re: [PERFORM] Replication

Hello, On Thu, 2007-06-14 at 16:14 -0700, Craig James wrote: > Cluster > Seems pretty good, but web site is not current, http://www.pgcluster.org is a bit up2date, also http://pgfoundry.org/projects/pgcluster is up2date (at least downloads page :) ) Regards, -- Devrim GÜNDÜZ Post

Re: [PERFORM] Do I need to rebuild php-pgsql for 8.2.3

stall compat-3 package * Install 8.2.3 packages. * Reload your dump. Regards, -- Devrim GÜNDÜZ PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/ signature.asc Description: This is a digitally signed message part

Re: [PERFORM] Do I need to rebuild php-pgsql for 8.2.3

egards, -- Devrim GÜNDÜZ PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/ signature.asc Description: This is a digitally signed message part