Re: [HACKERS] Postgres code for a query intermediate dataset

On Sun, Sep 14, 2014 at 5:18 AM, Rohit Goyal wrote: > Thanks for reply. But, I think i confused you. I am talking about access > using indexes. So, I assume that B+ tree store key-value pair where rohit is > the key and all the versions are its value. > > Another way to think is I have a secondary

Re: [HACKERS] Postgres code for a query intermediate dataset

On 14/09/14 20:43, Mark Kirkwood wrote: On 14/09/14 20:24, Atri Sharma wrote: How do you plan to do all that VACUUM does for this table then? It seems to me that you are saying to VACUUM that it need not be concerned with table 'A' and you are assuming ownership of all the tasks performed by

Re: [HACKERS] Postgres code for a query intermediate dataset

On 14/09/14 21:18, Rohit Goyal wrote: Hi Mark & Atri, :) Thanks for reply. But, I think i confused you. I am talking about access using indexes. So, I assume that B+ tree store key-value pair where rohit is the key and all the versions are its value. Another way to think is I have a secondary i

Re: [HACKERS] Postgres code for a query intermediate dataset

Hi Mark & Atri, :) Thanks for reply. But, I think i confused you. I am talking about access using indexes. So, I assume that B+ tree store key-value pair where rohit is the key and all the versions are its value. Another way to think is I have a secondary index on emp. name and there are 4 rohit

Re: [HACKERS] Postgres code for a query intermediate dataset

On 14/09/14 20:11, Rohit Goyal wrote: Hi Mark, On Sun, Sep 14, 2014 at 8:57 AM, Mark Kirkwood mailto:mark.kirkw...@catalyst.net.nz>> wrote: Currently in Postgres, these intermediate versions all exist - however a given session can only see one of them. Also VACUUM is allowed to de

Re: [HACKERS] Postgres code for a query intermediate dataset

On 14/09/14 20:24, Atri Sharma wrote: On Sun, Sep 14, 2014 at 1:30 PM, Mark Kirkwood mailto:mark.kirkw...@catalyst.net.nz>> wrote: On 14/09/14 19:25, Atri Sharma wrote: On Sunday, September 14, 2014, Mark Kirkwood mailto:mark.kirkw...@catalyst.net.nz>

Re: [HACKERS] Postgres code for a query intermediate dataset

On Sun, Sep 14, 2014 at 1:30 PM, Mark Kirkwood < mark.kirkw...@catalyst.net.nz> wrote: > On 14/09/14 19:25, Atri Sharma wrote: > >> >> >> On Sunday, September 14, 2014, Mark Kirkwood >> mailto:mark.kirkw...@catalyst.net.nz>> >> >> wrote: >> >> On 14/09/14 05:36, Rohit Goyal wrote: >> >>

Re: [HACKERS] Postgres code for a query intermediate dataset

On Sun, Sep 14, 2014 at 1:30 PM, Mark Kirkwood < mark.kirkw...@catalyst.net.nz> wrote: > On 14/09/14 19:25, Atri Sharma wrote: > >> >> >> On Sunday, September 14, 2014, Mark Kirkwood >> mailto:mark.kirkw...@catalyst.net.nz>> >> >> wrote: >> >> On 14/09/14 05:36, Rohit Goyal wrote: >> >>

Re: [HACKERS] Postgres code for a query intermediate dataset

Hi Mark, On Sun, Sep 14, 2014 at 8:57 AM, Mark Kirkwood < mark.kirkw...@catalyst.net.nz> wrote: > On 14/09/14 05:36, Rohit Goyal wrote: > >> Hi All, >> >> I want to work on the code of intermediate dataset of select and update >> query. >> >> For example. >> >> Rohit's salary has been updated 4 t

Re: [HACKERS] Postgres code for a query intermediate dataset

On 14/09/14 19:25, Atri Sharma wrote: On Sunday, September 14, 2014, Mark Kirkwood mailto:mark.kirkw...@catalyst.net.nz>> wrote: On 14/09/14 05:36, Rohit Goyal wrote: Hi All, I want to work on the code of intermediate dataset of select and update query.

Re: [HACKERS] Postgres code for a query intermediate dataset

On Sunday, September 14, 2014, Mark Kirkwood wrote: > On 14/09/14 05:36, Rohit Goyal wrote: > >> Hi All, >> >> I want to work on the code of intermediate dataset of select and update >> query. >> >> For example. >> >> Rohit's salary has been updated 4 times, so it has 4 different version >> of sa

Re: [HACKERS] Postgres code for a query intermediate dataset

On 14/09/14 05:36, Rohit Goyal wrote: Hi All, I want to work on the code of intermediate dataset of select and update query. For example. Rohit's salary has been updated 4 times, so it has 4 different version of salary. I want to select salary of person named Rohit. Now suppose , in intermed

Re: [HACKERS] Postgres code for a query intermediate dataset

On 14/09/14 06:35, Atri Sharma wrote: On Sat, Sep 13, 2014 at 11:52 PM, David G Johnston mailto:david.g.johns...@gmail.com>> wrote: Atri Sharma wrote > On Sat, Sep 13, 2014 at 11:06 PM, Rohit Goyal < Or rather even if you want to be able to reference the older versions of

Re: [HACKERS] Postgres code for a query intermediate dataset

On Sat, Sep 13, 2014 at 11:52 PM, David G Johnston < david.g.johns...@gmail.com> wrote: > Atri Sharma wrote > > On Sat, Sep 13, 2014 at 11:06 PM, Rohit Goyal < > > > > Or rather even if you want to be able to reference the older versions of > that record there is nothing in PostgreSQL to facilitat

Re: [HACKERS] Postgres code for a query intermediate dataset

Atri Sharma wrote > On Sat, Sep 13, 2014 at 11:06 PM, Rohit Goyal < > rhtgyl.87@ > > wrote: > >> >> Hi All, >> >> I want to work on the code of intermediate dataset of select and update >> query. >> >> For example. >> >> Rohit's salary has been updated 4 times, so it has 4 different version of >

Re: [HACKERS] Postgres code for a query intermediate dataset

On Sat, Sep 13, 2014 at 11:06 PM, Rohit Goyal wrote: > > Hi All, > > I want to work on the code of intermediate dataset of select and update > query. > > For example. > > Rohit's salary has been updated 4 times, so it has 4 different version of > salary. > > I want to select salary of person nam

[HACKERS] Postgres code for a query intermediate dataset

Hi All, I want to work on the code of intermediate dataset of select and update query. For example. Rohit's salary has been updated 4 times, so it has 4 different version of salary. I want to select salary of person named Rohit. Now suppose , in intermediate result, I found 4 different version