Re: How to read query plan

From: Harald Fuchs
Subject: Re: How to read query plan
Date: ,
Msg-id: puekei9vb3.fsf@srv.protecting.net
(view: Whole thread, Raw)
In response to: How to read query plan  (Miroslav Šulc)
Responses: Re: How to read query plan  (Miroslav Šulc)
List: pgsql-performance

Tree view

How to read query plan  (Miroslav Šulc, )
 Re: How to read query plan  (John Arbash Meinel, )
  Re: How to read query plan  (Miroslav Šulc, )
   Re: How to read query plan  (John Arbash Meinel, )
    Re: How to read query plan  (Miroslav Šulc, )
    Re: How to read query plan  (Tom Lane, )
     Re: How to read query plan  (Miroslav Šulc, )
      Re: How to read query plan  (Tom Lane, )
       Re: How to read query plan  (Miroslav Šulc, )
        Re: How to read query plan  (Tom Lane, )
   Re: How to read query plan  (John Arbash Meinel, )
    Re: How to read query plan  (Miroslav Šulc, )
     Re: How to read query plan  (John Arbash Meinel, )
      Re: How to read query plan  (Miroslav Šulc, )
      Re: How to read query plan  (Miroslav Šulc, )
       Re: How to read query plan  (Christopher Kings-Lynne, )
        Re: How to read query plan  (Miroslav Šulc, )
         Re: How to read query plan  (Greg Stark, )
       Re: How to read query plan  (PFC, )
        Re: How to read query plan  (Miroslav Šulc, )
         Re: How to read query plan  (Tom Lane, )
          Re: How to read query plan  (Miroslav Šulc, )
           Re: How to read query plan  (Kaloyan Iliev Iliev, )
            Re: How to read query plan  (Miroslav Šulc, )
         Re: How to read query plan  (John Arbash Meinel, )
 Re: How to read query plan  (Ragnar Hafstað, )
  Re: How to read query plan  (Miroslav Šulc, )
 Re: How to read query plan  (Tom Lane, )
  Re: [HACKERS] How to read query plan  (Tom Lane, )
   Re: [HACKERS] How to read query plan  (Miroslav Šulc, )
    Re: [HACKERS] How to read query plan  (Tom Lane, )
  Re: How to read query plan  (Miroslav Šulc, )
   Re: How to read query plan  (Tom Lane, )
    Re: How to read query plan  (Miroslav Šulc, )
   Re: How to read query plan  (John Arbash Meinel, )
 Re: How to read query plan  (Harald Fuchs, )
  Re: How to read query plan  (Miroslav Šulc, )
 Avoiding tuple construction/deconstruction during joining  (Tom Lane, )
  Re: Avoiding tuple construction/deconstruction during joining  (Miroslav Šulc, )
   Re: Avoiding tuple construction/deconstruction during joining  (Tom Lane, )
    Re: Avoiding tuple construction/deconstruction during joining  (Miroslav Šulc, )
  Re: Avoiding tuple construction/deconstruction during joining  (PFC, )
  Re: Avoiding tuple construction/deconstruction during joining  (PFC, )

In article <>,
=?ISO-8859-15?Q?Miroslav_=A6ulc?= <> writes:

>> Instead of a varchar(1) containing 'y' or 'n' you could use a
>> BOOL or an  integer.

> Sure I could. The problem is our project still supports both MySQL and
> PostgreSQL. We used enum('Y','N') in MySQL so there would be a lot of
> changes in the code if we would change to the BOOL data type.

Since BOOL is exactly what you want to express and since MySQL also
supports BOOL (*), you should make that change anyway.

(*) MySQL recognizes BOOL as a column type and silently uses
TINYINT(1) instead.


pgsql-performance by date:

From: Arshavir Grigorian
Date:
Subject: Re: Postgres on RAID5
From: "Jim Buttafuoco"
Date:
Subject: Re: Postgres on RAID5