[HACKERS] buffer assertion tripping under repeat pgbench load

2012-12-22 Thread Greg Smith
I'm testing a checkout from a few days ago and trying to complete a day long pgbench stress test, with assertions and debugging on. I want to make sure the base code works as expected before moving on to testing checksums. It's crashing before finishing though. Here's a sample: 2012-12-20 2

Re: [HACKERS] pgcrypto seeding problem when ssl=on

2012-12-22 Thread Andres Freund
On 2012-12-22 14:20:56 -0500, Tom Lane wrote: > Marko Kreen writes: > > On Fri, Dec 21, 2012 at 10:27 PM, Noah Misch wrote: > >> How about instead calling RAND_cleanup() after each backend fork? > > > Not "instead" - the gettimeofday() makes sense in any case. Considering > > that it's immediate

Re: [HACKERS] CommitFest 2012-11 Progress

2012-12-22 Thread Noah Misch
On Sat, Dec 08, 2012 at 05:34:08PM +0100, Andres Freund wrote: > I made a pass through most of the commitfest entries to update their > state to something sensible and where it seemed necessary inquired the > newest status. > Not sure thats really welcome, but it was the only thing I could think >

Re: [HACKERS] Feature Request: pg_replication_master()

2012-12-22 Thread Josh Berkus
> Forgive me because I have been up for 28 hours on a 9.0 to 9.2 migration > with Hot Standby and PgPool-II for load balancing but I was excessively > irritated that I had to go into recovery.conf to configure things. I am > one of the software authors that breaking recovery.conf will cause > prob

Re: [HACKERS] pgcrypto seeding problem when ssl=on

2012-12-22 Thread Noah Misch
On Sat, Dec 22, 2012 at 02:20:56PM -0500, Tom Lane wrote: > I believe that we'd be better off doing something in postmaster.c to > positively ensure that each session has a distinct seed value. Notice > that BackendRun() already takes measures to ensure that's the case for > the regular libc rando

[HACKERS] Pg_upgrade faster, again!

2012-12-22 Thread Bruce Momjian
I promised to research allowing parallel execution of schema dump/restore, so I have developed the attached patch, with dramatic results: tables git patch 1000 22.2918.30 2000 30.7519.67 4000 46.3322.31 8000

Re: [HACKERS] Review of Row Level Security

2012-12-22 Thread Kevin Grittner
Kohei KaiGai wrote: > RLS entry of wiki has not been updated for long time, I'll try to > update the entry for high-level design in a couple of days. Thanks, I think that is essential for a productive discussion of the issue. For me, it would help tremendously if you could provide a very short s

Re: [HACKERS] pgcrypto seeding problem when ssl=on

2012-12-22 Thread Tom Lane
Marko Kreen writes: > On Fri, Dec 21, 2012 at 10:27 PM, Noah Misch wrote: >> How about instead calling RAND_cleanup() after each backend fork? > Not "instead" - the gettimeofday() makes sense in any case. Considering > that it's immediate problem only for pgcrypto, this patch has higher chance

Re: [HACKERS] WIP: store additional info in GIN index

2012-12-22 Thread Alexander Korotkov
Hi! On Thu, Dec 6, 2012 at 5:44 AM, Tomas Vondra wrote: > Then I've run a simple benchmarking script, and the results are not as > good as I expected, actually I'm getting much worse performance than > with the original GIN index. > > The following table contains the time of loading the data (no

Re: [HACKERS] foreign key locks

2012-12-22 Thread Andres Freund
On 2012-12-22 10:53:47 +0100, Erik Rijkers wrote: > On Thu, November 29, 2012 17:16, Alvaro Herrera wrote: > > Here it is. > > > > fklocks-26.patch.gz > > This applies today after removing, not only the infamous catversion.h chunk, > but also a file_fdw > chunk. (It's not really a problem.) > >

Re: [HACKERS] foreign key locks

2012-12-22 Thread Erik Rijkers
On Thu, November 29, 2012 17:16, Alvaro Herrera wrote: > Here it is. > > fklocks-26.patch.gz This applies today after removing, not only the infamous catversion.h chunk, but also a file_fdw chunk. (It's not really a problem.) I also wondered if anyone has any perl/python/bash programs handy th