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

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 Certified Engineer Twitter: @DevrimGunduz

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

. 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: http://twitter.com/devrimgunduz signature.asc

[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 Principal

Re: [PERFORM] The good, old times

, 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~linux.org.tr http

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

. 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 signature.asc

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

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, and once paid, it is available via RHN. -- Devrim GÜNDÜZ PostgreSQL

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ışmanı

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

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/devrimgunduz signature.asc Description

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, -- Devrim

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 :( -- Devrim GÜNDÜZ

[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)

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://twitter.com/devrimgunduz

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

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 Engineer devrim

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.tr http

Re: [PERFORM] Best suiting OS

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

. ...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 signature.asc Description: This is a digitally signed message

Re: [PERFORM] Best suiting OS

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, because they are so old. Some people call these stability . -- Devrim GÜNDÜZ, RHCE Command Prompt

Re: [PERFORM] Hot Issue

* 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://www.gunduz.org signature.asc Description: This is a digitally

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.gunduz

Re: [PERFORM] [QUESTION]Concurrent Access

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.org, devrim~PostgreSQL.org

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 PostgreSQL

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

. 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

, -- 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