Re: [PERFORM] PGBOUNCER ISSUE PLEASE HELP(Slowing down the site)

Here is the output of pid postgres@symds-pg:~ $ cat /proc/15610/limits Limit Soft Limit Hard Limit Units Max cpu time unlimitedunlimitedseconds Max file size unlimitedunlimitedbytes Max

Re: [PERFORM] PGBOUNCER ISSUE PLEASE HELP(Slowing down the site)

On Thu, Jun 18, 2015 at 07:19:13PM +, Sheena, Prabhjot wrote: > Hi Ken/ Will > > I have checked the ulimit value and we are nowhere hitting the max 4096 > that we have currently set. Is there any other explanation why we should be > thinking of bumping it to like ulimit -n 5000

Re: [PERFORM] PGBOUNCER ISSUE PLEASE HELP(Slowing down the site)

-Original Message- From: pgsql-performance-ow...@postgresql.org [mailto:pgsql-performance-ow...@postgresql.org] On Behalf Of Sheena, Prabhjot Sent: Thursday, June 18, 2015 3:19 PM To: k...@rice.edu; Will Platnick Cc: pgsql-performance@postgresql.org; pgsql-gene...@postgresql.org Subject:

Re: [PERFORM] How to calculate statistics for one column

From: Irineu Ruiz [mailto:iri...@rassystem.com.br] Sent: Thursday, June 18, 2015 3:10 PM To: Igor Neyman Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] How to calculate statistics for one column I din't understood. In this case, my statistics target should be approximately 349? I

Re: [PERFORM] PGBOUNCER ISSUE PLEASE HELP(Slowing down the site)

"Sheena, Prabhjot" writes: > Hi Ken/ Will > > I have checked the ulimit value and we are nowhere hitting the max > 4096 that we have currently set. Is there any other explanation why > we should be thinking of bumping it to like ulimit -n 5 ( Add > ulimit -n 5 to the

[PERFORM] Techniques to Avoid Temp Files

We are trying to improve performance by avoiding the temp file creation. LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp8068.125071", size 58988604 STATEMENT: SELECT iiid.installed_item__id, item_detail.id, item_detail.model_id, item_detail.type FROM installed_item__item_detail AS iiid INNER

Re: [PERFORM] PGBOUNCER ISSUE PLEASE HELP(Slowing down the site)

Hi Ken/ Will I have checked the ulimit value and we are nowhere hitting the max 4096 that we have currently set. Is there any other explanation why we should be thinking of bumping it to like ulimit -n 5 ( Add ulimit -n 5 to the start of whatever you use to start pgbouncer

Re: [PERFORM] How to calculate statistics for one column

I din't understood. In this case, my statistics target should be approximately 349? I already try this range but didn't work. It's only work when I put 900 in my statistics. There is some kind of formula to calculate a good statistics for a column like this? 2015-06-18 15:24 GMT-03:00 Igor N

Re: [PERFORM] How to calculate statistics for one column

From: Irineu Ruiz [mailto:iri...@rassystem.com.br] Sent: Thursday, June 18, 2015 2:18 PM To: Igor Neyman Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] How to calculate statistics for one column SELECT COUNT(DISTINCT id_camada) FROM … equals 349 And it doesn't change significantly

Re: [PERFORM] How to calculate statistics for one column

SELECT COUNT(DISTINCT id_camada) FROM … equals 349 And it doesn't change significantly over time. []'s 2015-06-18 15:16 GMT-03:00 Igor Neyman : > > > > > *From:* pgsql-performance-ow...@postgresql.org [mailto: > pgsql-performance-ow...@postgresql.org] *On Behalf Of *Irineu Ruiz > *Sent:* Thursd

Re: [PERFORM] How to calculate statistics for one column

From: pgsql-performance-ow...@postgresql.org [mailto:pgsql-performance-ow...@postgresql.org] On Behalf Of Irineu Ruiz Sent: Thursday, June 18, 2015 1:53 PM To: pgsql-performance@postgresql.org Subject: [PERFORM] How to calculate statistics for one column Hi, I have a table with irregular distr

Re: [PERFORM] PGBOUNCER ISSUE PLEASE HELP(Slowing down the site)

On Thu, Jun 18, 2015 at 05:41:01PM +, Sheena, Prabhjot wrote: > Here is the output of OS limits > > postgres@symds-pg:~ $ ulimit -a > > core file size (blocks, -c) 0 > data seg size (kbytes, -d) unlimited > scheduling priority (-e) 0 > file size (b

[PERFORM] How to calculate statistics for one column

Hi, I have a table with irregular distribution based in a foreign key, like you can see in the end of the e-mail. Sometimes, in simples joins with another tables with the same id_camada (but not the table owner of the foreign key, the planner chooses a seq scan instead of use the index with id_ca

Re: [PERFORM] PGBOUNCER ISSUE PLEASE HELP(Slowing down the site)

Here is the output of OS limits postgres@symds-pg:~ $ ulimit -a core file size (blocks, -c) 0 data seg size (kbytes, -d) unlimited scheduling priority (-e) 0 file size (blocks, -f) unlimited pending signals (-i) 790527 max locked memory

Re: [PERFORM] PGBOUNCER ISSUE PLEASE HELP(Slowing down the site)

My guess is you are hitting an open file ulimit. Add ulimit -n 5 to the start of whatever you use to start pgbouncer (init script, etc..) On Thu, Jun 18, 2015 at 1:10 PM Sheena, Prabhjot < prabhjot.si...@classmates.com> wrote: > Guys > > I have an issue going on with PGBOUNCER whic

Re: [PERFORM] PGBOUNCER ISSUE PLEASE HELP(Slowing down the site)

On Thu, Jun 18, 2015 at 05:09:10PM +, Sheena, Prabhjot wrote: > Guys > I have an issue going on with PGBOUNCER which is slowing down the > site > > PGBOUNCER VERSION: pgbouncer-1.5.4-2.el6 (Hosted on separate machine) (16 > cpu) 98GB RAM > DATABASE VERION: postgresql 9.3 >

[PERFORM] PGBOUNCER ISSUE PLEASE HELP(Slowing down the site)

Guys I have an issue going on with PGBOUNCER which is slowing down the site PGBOUNCER VERSION: pgbouncer-1.5.4-2.el6 (Hosted on separate machine) (16 cpu) 98GB RAM DATABASE VERION: postgresql 9.3 When the total client connections to pgbouncer are close to 1000, site applicatio