[GENERAL] How to distribute budget value to actual rows in Postgresql

Budget table contains jobs with loads: create temp table budget ( job char(20) primary key, load numeric(4,1) not null check (load0 ) ); insert into budget values ( 'programmer', 3 ); insert into budget values ( 'analyst', 1.5 ); Actual table contains actual loads by

Re: [GENERAL] How to distribute budget value to actual rows in Postgresql

Andrus Moor wrote Budget table contains jobs with loads: create temp table budget ( job char(20) primary key, load numeric(4,1) not null check (load0 ) ); insert into budget values ( 'programmer', 3 ); insert into budget values ( 'analyst', 1.5 ); Actual

[GENERAL] Optimizing tables for known queries?

Hello! This is my first time on this list, so forgive me if it is not he correct place to discuss things like this. I have a question and answer tables right now that have grown large enough that my querying of them has become extremely slow and was wondering if anyone had tips on ways of

Re: [GENERAL] WAL archive on slave

Thanks for the reply Albe. I have WAL archiving enabled on both my servers, but it only happens on the master. When I promote the slave to be the new master then it will start archiving automatically, which suggests that my configuration is correct. Can you think of anything else which might

Re: [GENERAL] WAL archive on slave

Hi again, I just realised I asked this question around a year ago (for a different reason actually) and you answered me then! Amazing! Your answer then was: It works fine, only the server will not generate WAL while it is in recovery. As soon as you promote the standby, it will archive ist

Re: [GENERAL] WAL archive on slave

On Mon, Feb 10, 2014 at 9:43 AM, James Sewell james.sew...@lisasoft.comwrote: Hi again, I just realised I asked this question around a year ago (for a different reason actually) and you answered me then! Amazing! Your answer then was: It works fine, only the server will not generate WAL

Re: [GENERAL] Better Connection Statistics

On Sun, Feb 9, 2014 at 4:52 AM, Greg Sabino Mullane g...@turnstep.com wrote: For instance, I want the number of transactions a specific connection has submitted. The number of queries. Total amount of CPU time consumed, etc. So far as I know, there is no module, statistic, or view that

Re: [GENERAL] client encoding that psql command sets

Thanks for your support. Best regards, Tsubasa Sakamoto -Original Message- From: Albe Laurenz [mailto:laurenz.a...@wien.gv.at] Sent: Friday, February 07, 2014 6:12 PM To: Tsubasa Sakamoto *EXTERN*; 'Adrian Klaver' Cc: pgsql-general@postgresql.org; pgsql-hack...@postgresql.org

[GENERAL] Xlogdump compiling error : undefined reference to `ber_sockbuf_io_udp'

Hi, Any body faced the similar issue while compiliing xlogdump :- [root@db1002 xlogdump]# make /usr/bin/gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv strlcpy.o xlogdump.o

Re: [GENERAL] Xlogdump compiling error : undefined reference to `ber_sockbuf_io_udp'

On Sun, Feb 9, 2014 at 10:02 PM, Adarsh Sharma eddy.ada...@gmail.com wrote: I need to use xlogdump to analyse my xlog files in postgresql to understand why there are so much xlog generation on Master. Only PostgreSQL is supported. EDB's product is not. -- Regards, Peter Geoghegan -- Sent