Re: [GENERAL] log_min_duration question

2016-02-08 Thread Joshua Berkus
- Original Message - > From the 9.5 docs: > > log_min_duration_statement (integer) > > Causes the duration of each completed statement to be logged if the > statement ran for at least the specified number of > milliseconds. Setting this to zero prints all statement > durations

Re: [GENERAL] Multi-Table Insert/Update Strategy - Use Functions/Procedures?

2016-01-27 Thread Joshua Berkus
> Am I on the right track, or is there some better way to set this up? My > understanding is that views really aren't meant for insert/update > operations, and I have seen on the web that using views to insert/update is > a bit tricky - and still requires a procedure with a rule on the view. Wh

Re: [GENERAL] Tutorial on How to Compile PostgreSQL 9.5 for Windows 64bit

2016-01-25 Thread Joshua Berkus
- Original Message - > Hi Everybody, > > I have posted a video tutorial on How to Compile PostgreSQL 9.5 for > Windows 64bit > https://www.youtube.com/watch?v=-BJmuZT5IPE > > It was quite difficult for me to figure it out, so hopefully it will > make life easier for > the next guy (or g

Re: [GENERAL] A motion

2016-01-24 Thread Joshua Berkus
- Original Message - > > > > On Jan 24, 2016, at 7:59 PM, Roxanne Reid-Bennett wrote: > > > >> On 1/23/2016 3:31 PM, Joshua D. Drake wrote: > >>> On 01/23/2016 03:08 PM, Adrian Klaver wrote: > On 01/23/2016 03:03 PM, Berend Tober wrote: > Adrian Klaver wrote: > > Motion:

[GENERAL] Re: [PERFORM] PostgreSQL 9.2.3 performance problem caused Exclusive locks

2013-03-13 Thread Joshua Berkus
Emre, > > LOG: process 4793 acquired ExclusiveLock on extension of relation > > 305605 of database 16396 after 2348.675 ms The reason you're seeing that message is that you have log_lock_waits turned on. That message says that some process waited for 2.3 seconds to get a lock for expanding the

[GENERAL] Re: [TESTERS] FREE hosting platforms with PostgreSQL, Java SDK, Tomcat, ecc.?

2011-08-07 Thread Joshua Berkus
Fernando, You just posted your question to multiple innappropriate mailing lists. Please do not do that again. --Josh Berkus -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] You could be a PostgreSQL Patch Reviewer!

2011-06-16 Thread Joshua Berkus
> I have no knowledge on the subject one way or the other, that's why > I'm asking.. If the answer is "no, there would be no benefit" then > that's the answer.. However, it seems like generating UUIDs in Win64 > has been broken, perhaps, forever which is why I question if there's a > better librar

Re: [GENERAL] You could be a PostgreSQL Patch Reviewer!

2011-06-16 Thread Joshua Berkus
Craig, > Well, a quick look through > https://commitfest.postgresql.org/action/commitfest_view/inprogress > suggests that these could use attention: Let me know which one of these you want to take first. I'll put your name by it. -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com San