[GENERAL] Ubuntu 14.04 LTS install problem

I installed Ubuntu 14.04 LTS apg-get update ... apt-get upgrade ... and looked at www.postgresql.org/download/linux/ubuntu then added apt repository /etc/apt/sources.list.d/pgdg.list When I try apt-get install postgresql-9.4 error: depends on postgresql-common (>= 142~) what should not ge

Re: [GENERAL] how to extract the page "address" from the ctid

On Tue, Jun 30, 2015 at 10:56 PM, Marc Mamin wrote: > while waiting for the new BRIN and improved GIN Indexes :-) > > I'd like to get a rough feeling, how some column's values are distributed on > the internal pages. > Is there a quicker way to extract the page reference from the ctid? Isn't it

[GENERAL] Streaming Questions and Sizing

I have db of 123GB Currently and this is streaming to a secondary DB which also shows a size of 123GB (Using pgAdmin) The db's both reside on a 250GB directorys and on the Master i'm using 60% of capacity which seems expected On the secondary i am using 88% of the disks capacity. I assume this is

Re: [GENERAL] very slow queries and ineffective vacuum

How about your start by giving us a little useful information? Show us your_longest_query and the output from EXPLAIN your_longest_query; Although you say you have indexes, they may not be the correct indexes that you really need. Also, how many physical disks do you have? Do you have multiple tabl

Re: [GENERAL] very slow queries and ineffective vacuum

Lukasz Wrobel wrote: > Hello. > > I have multiple problems with my database, the biggest of which is how to > find out what is actually wrong. > > First of all I have a 9.3 postgres database that is running for about a > month. Right now the queries on that database are running very slowly > (sel

Re: [GENERAL] very slow queries and ineffective vacuum

Jerry, On Tue, Jun 30, 2015 at 5:31 PM, Jerry Sievers wrote: > > foodb/postgres > =# \d pg_stat_activity|pg_prepared_xacts > View "pg_catalog.pg_prepared_xacts" >Column| Type | Modifiers > -+--+--- > transaction |

Re: [GENERAL] very slow queries and ineffective vacuum

William Dunn writes: > Sorry I meant to say, "To track transactions that have been left idle but not > committed or rolled back you would..." > Typo foodb/postgres =# \d pg_stat_activity|pg_prepared_xacts View "pg_catalog.pg_prepared_xacts" Column| Type | Mod

Re: [GENERAL] very slow queries and ineffective vacuum

Hi What is an output of VACUUM VERBOSE statement? VACUUM can be blocked by some forgotten transaction. Check your pg_stat_activity table for some old process in "idle in transaction" state. Then connection should not be reused, and you can see a error messages about missing connections. I found t

Re: [GENERAL] very slow queries and ineffective vacuum

Sorry I meant to say, "To track transactions that *have been* left idle but not committed or rolled back you would..." Typo *Will J. Dunn* *willjdunn.com * On Tue, Jun 30, 2015 at 4:33 PM, William Dunn wrote: > On Tue, Jun 30, 2015 at 8:57 AM, Lukasz Wrobel < > lukasz.wro.

Re: [GENERAL] very slow queries and ineffective vacuum

On Tue, Jun 30, 2015 at 8:57 AM, Lukasz Wrobel < lukasz.wro...@motorolasolutions.com> wrote: > > > Perhaps I'm missing some indexes on the tables (creating them on the > columns on which the where clause was used in the long queries seemed to > halve their times). Also how can I monitor my transact

Re: [GENERAL] very slow queries and ineffective vacuum

Hello Lukasz, On Tue, Jun 30, 2015 at 8:57 AM, Lukasz Wrobel < lukasz.wro...@motorolasolutions.com> wrote: > > There doesn't seem to be any issues with disk space, memory or CPU, as > neither of those is even 50% used (as per df and top). > Are you using the default PostgreSQL configuration sett

[GENERAL] very slow queries and ineffective vacuum

Hello. I have multiple problems with my database, the biggest of which is how to find out what is actually wrong. First of all I have a 9.3 postgres database that is running for about a month. Right now the queries on that database are running very slowly (select with a simple "where" on a non-in

Re: [GENERAL] Which replication is the best for our case ?

On 6/30/2015 9:57 AM, ben.play wrote: To be more precise : We have a database with more than 400 Gb and ONE table with more than 100 Gb of data. This is huge for doctrine. When the cron runs, it writes a lot on the disks in temporary file (although we have 128 GB of Ram...). Of course, each table

Re: [GENERAL] Which replication is the best for our case ?

On Tue, Jun 30, 2015 at 1:57 PM, ben.play wrote: > Hi guys, > > Thank you a lot for your answers. > > In fact, I tried to write the easiest explanation of my problem in order to > be understood... > My project is developed with Symfony and Doctrine (BERK, i know ...). > > The project has more tha

Re: [GENERAL] Which replication is the best for our case ?

Hi guys, Thank you a lot for your answers. In fact, I tried to write the easiest explanation of my problem in order to be understood... My project is developed with Symfony and Doctrine (BERK, i know ...). The project has more than 2 years and Doctrine makes some bad decisions and lock all the

Re: [GENERAL] PgPool Configuration Document required

On 06/30/2015 09:35 AM, Jimit Amin wrote: Dear Sir, Sorry for this type of question, I have already configured PgPool but facing 3 issue. That's why I thought that I may have done wrong setup. I would suggest the pgpool mailing lists. JD -- Command Prompt, Inc. - http://www.commandprompt.c

Re: [GENERAL] PgPool Configuration Document required

Dear Sir, Sorry for this type of question, I have already configured PgPool but facing 3 issue. That's why I thought that I may have done wrong setup. Issue faced I have streaming replication setup 1 master and 1 read-only server and PgPool 1. I have already mentioned nextval in blacklistfunctio

Re: [GENERAL] PgPool Configuration Document required

On 06/30/2015 09:05 AM, Jimit Amin wrote: Dear Sir/Mam, Can I have technical documentation for configuration of PgPool? http://www.pgpool.net/mediawiki/index.php/Main_Page -- Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564 PostgreSQL Centered full stack support, consultin

Re: [GENERAL] PgPool Configuration Document required

google search works fine for that: http://pgpool.net/mediawiki/index.php/Documentation http://www.pgpool.net/mediawiki/images/pgpool-en-3.3.0.pdf On Tue, Jun 30, 2015 at 12:05 PM, Jimit Amin wrote: > Dear Sir/Mam, > > Can I have technical documentation for configuration of PgPool? > -- *

[GENERAL] PgPool Configuration Document required

Dear Sir/Mam, Can I have technical documentation for configuration of PgPool?

[GENERAL] how to extract the page "address" from the ctid

Hello, while waiting for the new BRIN and improved GIN Indexes :-) I'd like to get a rough feeling, how some column's values are distributed on the internal pages. e.g.: SELECT c, count(*) FROM ( SELECT substring(ctid::text, '^.([^,]+)'), count(distinct myColumn) as c F

[GENERAL] Hardware question

Hoping to tap into the hive mind here. I'm looking to upgrade drives on some of our db servers and am hoping someone has run/tested a similar setup in the past and can share their wisdom. I have a pair of Dell R910s with H700 controllers and am looking to replace the existing drives with SSDs. Ri

Re: [GENERAL] plpgsql question: select into multiple variables ?

Hi Yari, Thanks for the response. You did make the “simplified concept” function more rational. However, This was kind of a non-sense function to demonstrate the problem I was having with the “select fields” and the “into variables”. As pointed out by Adrian Klaver and Tom Lane, the real probl

Re: [GENERAL] Feature request: fsync and commit_delay options per database

On Tue, Jun 30, 2015 at 3:43 AM, Jeff Janes wrote: > 2015-06-29 15:18 GMT-07:00 Bráulio Bhavamitra : >> >> Hello all, >> >> After reading >> http://stackoverflow.com/questions/9407442/optimise-postgresql-for-fast-testing >> I've tried to use commit_delay to make commits really slow on a test >> en