Re: I/O on select count(*) - Mailing list pgsql-performance

From Alvaro Herrera
Subject Re: I/O on select count(*)
Date
Msg-id 20080515155232.GC8221@alvh.no-ip.org
Whole thread Raw
In response to Re: I/O on select count(*)  (Matthew Wakeling <matthew@flymine.org>)
Responses Re: I/O on select count(*)
List pgsql-performance
Matthew Wakeling wrote:

Aside from the rest of commentary, a slight clarification:

> So, as I understand it, Postgres works like this:
>
> 1. You begin a transaction. Postgres writes an entry into pg_clog.

Starting a transaction does not write anything to pg_clog.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-performance by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: I/O on select count(*)
Next
From: Guillaume Cottenceau
Date:
Subject: Re: which ext3 fs type should I use for postgresql