Re: How to read query plan

From: Miroslav Šulc
Subject: Re: How to read query plan
Date: ,
Msg-id: 423554D2.9000207@startnet.cz
(view: Whole thread, Raw)
In response to: Re: How to read query plan  (Christopher Kings-Lynne)
Responses: Re: How to read query plan  (Greg Stark)
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, )

Christopher Kings-Lynne wrote:

>> 1) in PostgreSQL I use 'varchar(1)' for a lot of fields and in MySQL
>> I use 'enum'
>> 2) in PostgreSQL in some cases I use connection fields that are not
>> of the same type (smallint <-> integer (SERIAL)), in MySQL I use the
>> same types
>
>
> Well both those things will make PostgreSQL slower...

I think so. I'll change the varchar(1) fields to char(1) where possible
and will think out what I will do with the smallint <-> integer JOINs.
Something like SMALLSERIAL would be pleasant :-) I thought I will wait
for Tom Lane's reaction to my improvement suggestions I have posted in
other mail but maybe he has a deep night because of different time zone.

>
> Chris

Miroslav

Attachment

pgsql-performance by date:

From: Tom Lane
Date:
Subject: Re: [HACKERS] How to read query plan
From: Harald Fuchs
Date:
Subject: Re: How to read query plan