Re: [GENERAL] GCC error while trying to install 9.4 via brew on MAC OS

2015-01-09 Thread Alvaro Herrera
Jimmy Jack wrote: > I sent the message, it is pending review due its sizeā€¦ meanwhile there is the > cache part I rejected it -- it contained 400kB of gcc output plus a second copy of the same thing in HTML format. I have no desire to pointlessly cause 3 GB of outgoing traffic in our mailing list

Re: [GENERAL] PSQL/pgAdmin - Column Completion

2015-01-09 Thread Adrian Klaver
On Wed, Dec 31, 2014, at 12:01 PM, dvlsg wrote: > Yeah, I think that would be problematic. All other sql query > applications I've used in the past with autocomplete seem to parse the > entire query and find table references for autocompletion based on the > whole query, whereas psql seems to typi

Re: [GENERAL] PSQL/pgAdmin - Column Completion

2015-01-09 Thread dvlsg
That looks perfect. I'll look into it, and pass the link along to the pgAdmin developers. I did bring up the suggestion to Dave Page who was kind enough to take the auto complete request under consideration for the future when they get to later stages of the product. -- View this message in con

Re: [GENERAL] How to monitor locks (max_pred_locks_per_transaction)?

2015-01-09 Thread Kevin Grittner
Andrey Lizenko wrote: > does max_locks_per_transaction limit all others modes of locks by > the same way? In the sense that the count of all other locks must be less than max_locks_per_transaction * max_connections, yes. Most other locks do not persist past the end of transactions or the closin

[GENERAL] How to analyze a slowdown in 9.3.5?

2015-01-09 Thread Michael Nolan
I'm running 9.3.5 on a virtual machine with 5 cores and 24 GB of memory. Disk is on a SAN. I have a task that runs weekly that processes possibly as many as 120 months worth of data, one month at a time. Since moving to 9.3.5 (from 8.2!!) the average time for a month has been 3 minutes or less.

[GENERAL] unexpected PQresultStatus: 8 with simple logical replication

2015-01-09 Thread Brent Tubbs
Hi all, I'm trying to learn about how to subscribe to events in a logical replication slot. I'm finding that the documentation is sparse and mostly focused on binary WAL replication. I'd like to get a toy example working where I can see changes in my terminal. I'm able to create a replication sl

Re: [GENERAL] How to analyze a slowdown in 9.3.5?

2015-01-09 Thread Tomas Vondra
On 9.1.2015 23:14, Michael Nolan wrote: > I'm running 9.3.5 on a virtual machine with 5 cores and 24 GB of > memory. Disk is on a SAN. > > I have a task that runs weekly that processes possibly as many as > 120 months worth of data, one month at a time. Since moving to 9.3.5 > (from 8.2!!) the a