Dear Ramakrishna,
"two different transactions can update the same version of the row"
This answer itself is wrong.
In my point of view, the drawback of MVCC is just holding multiple versions
of tuple in a table which leads to slowness in application access. the more
your table is bloated the mor
On Mon, Jul 13, 2020 at 10:41:28AM +0200, Francisco Olarte wrote:
> Rama:
>
> On Mon, Jul 13, 2020 at 9:52 AM Rama Krishnan wrote:
> > I m preparing for interview one of the recruiter asked me mvcc drawbacks as
> > i told due to mvcc it use more space and need to perform maintenance
> > activit
On Mon, 2020-07-13 at 13:01 +0530, Rama Krishnan wrote:
> I m preparing for interview one of the recruiter asked me mvcc drawbacks as i
> told due
> to mvcc it use more space and need to perform maintenance activity.
Yes. Generally speaking, you have to pay a price for keeping old versions of
t
On 7/13/20 12:31 AM, Rama Krishnan wrote:
Hi sir,
I m preparing for interview one of the recruiter asked me mvcc drawbacks
as i told due to mvcc it use more space and need to perform maintenance
activity.
Another one is the same data causes an update conflict because two
different transac
Rama:
1st of all, please do not top post, specially if you want to discuss
examples, I'm not goint to hunt up and down for the relevant sections.
On Mon, Jul 13, 2020 at 10:52 AM Rama Krishnan wrote:
> Still, I have a doubt as per your example both are trying to update the same
> tuple so it ma
On 7/13/2020 4:52 AM, Rama Krishnan wrote:
For example, two transactions are going to increase the amount on the
same account by $100 . The first transaction reads the current value
($1000) and then the second transaction reads the same value. The first
transaction increases the amount (thi
Hi Francisco,
Still, I have a doubt as per your example both are trying to update the
same tuple so it may produce two different copies right?
I read some blocks they mentioned drawback above two things
It may lead to lost update also
For example, two transactions are going to increase the a
Rama:
On Mon, Jul 13, 2020 at 9:52 AM Rama Krishnan wrote:
> I m preparing for interview one of the recruiter asked me mvcc drawbacks as i
> told due to mvcc it use more space and need to perform maintenance activity.
> Another one is the same data causes an update conflict because two different
Hi sir,
I m preparing for interview one of the recruiter asked me mvcc drawbacks as
i told due to mvcc it use more space and need to perform maintenance
activity.
Another one is the same data causes an update conflict because two
different transactions can update the same version of the row.
he
