Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Why so slow?
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: K C Lau <kclau60(at)netvigator(dot)com>
- Cc: pgsql-performance(at)postgresql(dot)org
- Subject: Re: Why so slow?
- Date: Fri, 28 Apr 2006 22:39:28 -0400
K C Lau <kclau60(at)netvigator(dot)com> writes: > Without knowing the internals, I have this simplistic idea: if Postgres > maintains the current lowest transaction ID for all active transactions, it > probably could recycle dead tuples on the fly. [ yawn... ] Yes, we've heard that before. The hard part is getting rid of index entries. regards, tom lane
- Follow-Ups:
- Re: Why so slow?
- From: K C Lau
- Re: Why so slow?
- References:
- Re: Why so slow?
- From: Jim C. Nasby
- Re: Why so slow?
- From: Bealach-na Bo
- Re: Why so slow?
- From: Bruno Wolff III
- Re: Why so slow?
- From: K C Lau
- Re: Why so slow?
- Prev by Date: Re: Why so slow?
- Next by Date: Re: Why so slow?
- Previous by thread: Re: Why so slow?
- Next by thread: Re: Why so slow?
- Indexes: