Re: Beginner Question

From: Tom Lane
Subject: Re: Beginner Question
Date: ,
Msg-id: 27869.1176130157@sss.pgh.pa.us
(view: Whole thread, Raw)
In response to: Beginner Question  ("s d")
List: pgsql-performance

Tree view

Beginner Question  ("s d", )
 Re: Beginner Question  (Tom Lane, )
 Re: Beginner Question  ("s d", )
  Re: Beginner Question  (Mike Gargano, )
  Re: Beginner Question  ("Dave Dutcher", )
 Re: Beginner Question  ("Jan de Visser", )

"s d" <> writes:
> 1. i can undestand where the cost=11.53 came from but where did the
> 1192.09 come form? The values are in milli right ?

No, the unit of estimated cost is 1 disk page fetch.  See
http://www.postgresql.org/docs/8.2/static/using-explain.html

            regards, tom lane


pgsql-performance by date:

From: Drew Wilson
Date:
Subject: how to efficiently update tuple in many-to-many relationship?
From: Tom Lane
Date:
Subject: Re: DELETE with filter on ctid