Re: [HACKERS] Adding new joining alghoritm to postgresql

2013-07-20 Thread Amit kapila
On Friday, July 19, 2013 7:17 PM tubadzin wrote: Hi. I'm a little confused. 1.I have source code 9.2.4. version from http://www.postgresql.org/ftp/source/ 2.I want to add new alghoritm to index nested loops join, merge join and hash join. I have Executor catalog in src catalag

Re: [HACKERS] Improvement of checkpoint IO scheduler for stable transaction responses

2013-07-20 Thread didier
Hi With your tests did you try to write the hot buffers first? ie buffers with a high refcount, either by sorting them on refcount or at least sweeping the buffer list in reverse? In my understanding there's an 'impedance mismatch' between what postgresql wants and what the OS offers. when it

[HACKERS] create index does change pages?

2013-07-20 Thread mohsen soodkhah mohammadi
hello. dose one create index on the large table changes the place of some tuples in some pages?

Re: [HACKERS] confusing typedefs in jsonfuncs.c

2013-07-20 Thread Peter Eisentraut
On Thu, 2013-07-18 at 21:34 -0400, Tom Lane wrote: Yeah, this is randomly different from everywhere else in PG. The more usual convention if you want typedefs for both the struct and the pointer type is that the pointer type is FooBar and the struct type is FooBarData. I think that is more

Re: [HACKERS] create index does change pages?

2013-07-20 Thread Heikki Linnakangas
On 20.07.2013 12:56, mohsen soodkhah mohammadi wrote: hello. dose one create index on the large table changes the place of some tuples in some pages? No, creating an index doesn't move any tuples in the heap. - Heikki -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To

Re: [HACKERS] create index does change pages?

2013-07-20 Thread Atri Sharma
Sent from my iPad On 20-Jul-2013, at 15:26, mohsen soodkhah mohammadi mohsensoodk...@gmail.com wrote: hello. dose one create index on the large table changes the place of some tuples in some pages? No, making an index involves keeping some metadata about your tables in an auxiliary

Re: [HACKERS] [v9.4] row level security

2013-07-20 Thread Kohei KaiGai
2013/7/19 Stephen Frost sfr...@snowman.net: * Greg Smith (g...@2ndquadrant.com) wrote: On 7/18/13 7:57 PM, Karol Trzcionka wrote: Current head 4cbe3ac3e86790d05c569de4585e5075a62a9b41 - patch applies correct (only change needed in parallel_schedule). However it fails on own regression tests

Re: [HACKERS] [v9.4] row level security

2013-07-20 Thread Kohei KaiGai
2013/7/19 Dean Rasheed dean.a.rash...@gmail.com: On 19 July 2013 04:09, Greg Smith g...@2ndquadrant.com wrote: On 7/18/13 11:03 PM, Stephen Frost wrote: Wasn't there a wiki page about this feature which might also help? Bigger question- is it correct for the latest version of the patch?

[HACKERS] Error compiling Postgresql source code in Visual Studio 2010

2013-07-20 Thread tubadzin
Hi. 1.I downloaded source code PostgreSql version 9.2.4. from  http://www.postgresql.org/ftp/source/ 2.Next, I downloaded ActivePerl and installed it. Next, I used Visual Studio x64 Win64 command prompt 2010. Later I used visual studio command prompt for get into path source code :

Re: [HACKERS] Improvement of checkpoint IO scheduler for stable transaction responses

2013-07-20 Thread Greg Smith
On 7/20/13 4:48 AM, didier wrote: With your tests did you try to write the hot buffers first? ie buffers with a high refcount, either by sorting them on refcount or at least sweeping the buffer list in reverse? I never tried that version. After a few rounds of seeing that all changes I

Re: [HACKERS] Improvement of checkpoint IO scheduler for stable transaction responses

2013-07-20 Thread Heikki Linnakangas
On 20.07.2013 19:28, Greg Smith wrote: On 7/20/13 4:48 AM, didier wrote: With your tests did you try to write the hot buffers first? ie buffers with a high refcount, either by sorting them on refcount or at least sweeping the buffer list in reverse? I never tried that version. After a few

[HACKERS] InvokeObjectPostAlterHook() vs. CommandCounterIncrement()

2013-07-20 Thread Noah Misch
objectaccess.h has this to say: * OAT_POST_ALTER should be invoked just after the object is altered, * but before the command counter is incremented. An extension using the * hook can use SnapshotNow and SnapshotSelf to get the old and new * versions of the tuple. That's a clever design,

Re: [HACKERS] updated emacs configuration

2013-07-20 Thread Greg Stark
On Thu, Jun 27, 2013 at 10:31 PM, Tom Lane t...@sss.pgh.pa.us wrote: AFAIR, no one has ever done a serious comparison to anything except GNU indent, and (at least at the time) it seemed to have bugs as bad as pgindent's, just different ones. I'm certainly open to another choice as long as we

[HACKERS] proposal - psql - show longest tables

2013-07-20 Thread Pavel Stehule
Hello all I very often use a little bit adjusted psql system queries to detection TOP N sized tables. I am thinking so it can be useful for all users I propose a few new commands \dts [N|size] ... show N largest tables | show tables larger than size ordered by size \dis [N|size] ... show N

Re: [HACKERS] Error compiling Postgresql source code in Visual Studio 2010

2013-07-20 Thread Amit kapila
On Saturday, July 20, 2013 9:53 PM tubadzin wrote: Hi. 1.I downloaded source code PostgreSql version 9.2.4. from http://www.postgresql.org/ftp/source/ 2.Next, I downloaded ActivePerl and installed it. Next, I used Visual Studio x64 Win64 command prompt 2010. Later I used visual studio

Re: [HACKERS] Re: Request for Patch Feedback: Lag Lead Window Functions Can Ignore Nulls

2013-07-20 Thread Jeff Davis
On Fri, 2013-07-19 at 09:39 -0700, Josh Berkus wrote: So ... are you doing a final review of this for the CF, Jeff? We need to either commit it or bounce it to the next CF. I am going on vacation tomorrow, and I just didn't quite find time to take this to commit. Sorry about that, Nicholas.