Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: I/O on select count(*)
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: Greg Smith <gsmith(at)gregsmith(dot)com>
- Cc: Matthew Wakeling <matthew(at)flymine(dot)org>, pgsql-performance(at)postgresql(dot)org
- Subject: Re: I/O on select count(*)
- Date: Mon, 19 May 2008 11:53:49 -0400
- Message-id: <5899(dot)1211212429(at)sss(dot)pgh(dot)pa(dot)us>
Greg Smith <gsmith(at)gregsmith(dot)com> writes: > The real question in my mind is why this turns into a bottleneck before > the similar task of cleaning the 16MB XLOG segment does. Because we do the latter off-line, or at least try to. regards, tom lane
- References:
- I/O on select count(*)
- From: Doug Eck
- Re: I/O on select count(*)
- From: Kevin Grittner
- Re: I/O on select count(*)
- From: Greg Smith
- Re: I/O on select count(*)
- From: Alvaro Herrera
- Re: I/O on select count(*)
- From: Matthew Wakeling
- Re: I/O on select count(*)
- From: Alvaro Herrera
- Re: I/O on select count(*)
- From: Greg Smith
- Re: I/O on select count(*)
- From: Alvaro Herrera
- Re: I/O on select count(*)
- From: Tom Lane
- Re: I/O on select count(*)
- From: Matthew Wakeling
- Re: I/O on select count(*)
- From: Greg Smith
- I/O on select count(*)
- Prev by Date: Re: I/O on select count(*)
- Next by Date: Re: I/O on select count(*)
- Previous by thread: Re: I/O on select count(*)
- Next by thread: Re: I/O on select count(*)
- Indexes: