Re: [HACKERS] Polecat "quit unexpectdly"

2011-06-15 Thread Robert Creager
On Jun 14, 2011, at 2:11 PM, Kevin Grittner wrote: > Robert Creager wrote: > >> Stack trace, nothing else. > >> 3 postgres 0x00010005cafa >> multixact_twophase_postcommit + 74 (multixact.c:1367) >> 4 postgres 0x00010005deab >> Proces

Re: [HACKERS] procpid?

2011-06-15 Thread Greg Smith
Here's the sort of thing every person who writes a monitoring tool involving pg_stat_activity goes through: 1) Hurray! I know how to see what the database is doing now! Let me try counting all the connections so I can finally figure out what to set [max_connections | work_mem | other] to. 2)

Re: [HACKERS] creating CHECK constraints as NOT VALID

2011-06-15 Thread Dean Rasheed
On 15 June 2011 07:09, Jaime Casanova wrote: > On Tue, Jun 14, 2011 at 4:14 PM, Alvaro Herrera > wrote: >> Excerpts from Alvaro Herrera's message of lun jun 13 18:08:12 -0400 2011: >>> Excerpts from Dean Rasheed's message of sáb jun 11 09:32:15 -0400 2011: >> >>> > I think that you also need to u

Re: [HACKERS] use less space in xl_xact_commit patch

2011-06-15 Thread Leonardo Francalanci
> On Tue, Jun 14, 2011 at 2:31 PM, Simon Riggs wrote: > Well, we certainly have the option to review and commit the patch any > time up until feature freeze. However, I don't want the CommitFest > application to be full of entries for patches that are not actually > being worked on, because it

Re: [HACKERS] WIP: Fast GiST index build

2011-06-15 Thread Alexander Korotkov
On Wed, Jun 15, 2011 at 11:21 AM, Alexander Korotkov wrote: > I've tried index tuples sorting on penalty function before buffer > relocation on split. But it was without any success. Index quality becomes > even worse than without sorting. > The next thing I've tried is buffer relocation between a

Re: [HACKERS] WIP: Fast GiST index build

2011-06-15 Thread Alexander Korotkov
I've tried index tuples sorting on penalty function before buffer relocation on split. But it was without any success. Index quality becomes even worse than without sorting. The next thing I've tried is buffer relocation between all neighbor buffers. Results of first tests is much more promising. N

Re: [HACKERS] use less space in xl_xact_commit patch

2011-06-15 Thread Leonardo Francalanci
> We don't need to be in a hurry here. As the reviewer I'm happy to give > Leonardo some time, obviously no more than the end of the commit fest. > > If he doesn't respond at all, I'll do it, but I'd like to give him the > chance and the experience if possible. Sorry I couldn't update the pat

<    1   2