Dear all,

Would it be possible to have to different symbols for index scans and sequence scans? Just like there is a different symbol for bitmap scans.. (although this is not a very clear one: a question mark). These clues are very important for performance boosting and having different symbols would benefit this really!

Futhermore I would like to ask if it is possible that the hints (the yellow messages with the details of each step) start with a mouse-over-event instead of an on-click-event. This saves a lot of clicking ;-)

Your sincerely,

Aarjan Langereis

A.j. Langereis wrote:
> Dear all,
>
> Would it be possible to have to different symbols for index scans and
> sequence scans? Just like there is a different symbol for bitmap scans..

Generally speaking yes; would you provide images?

Currently, bitmap scans aren't recognized, and thus shown as unknown
(question mark).

Ideally, we'd need these images:

- Seq Scan
- Index Scan
- Bitmap Index Scan
- Bitmap Heap Scan
- Tid Scan

Regards,
Andreas

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Hi Niko,


On 27/11/05 7:06 pm, "Andreas Pflug" <pgadmin@pse-consulting.de> wrote:

> A.j. Langereis wrote:
>> Dear all,
>>
>> Would it be possible to have to different symbols for index scans and
>> sequence scans? Just like there is a different symbol for bitmap scans..
>
> Generally speaking yes; would you provide images?
>
> Currently, bitmap scans aren't recognized, and thus shown as unknown
> (question mark).
>
> Ideally, we'd need these images:
>
> - Seq Scan
> - Index Scan
> - Bitmap Index Scan
> - Bitmap Heap Scan
> - Tid Scan

Would you be able to find some time to design some icons for this please?

Also, if you can find another few minutes; Andreas replaced the delete icon
on the main toolbar with one of his own because there was some confusion
over the X symbol you had used. If you can redo that one with a waste paper
bin or similar that would be great - Andreas' one just looks subtly
different to the rest of yours and stands out as a result :-(

Regards, Dave



---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Dave Page wrote:

>Hi Niko,
>
>
>On 27/11/05 7:06 pm, "Andreas Pflug" <pgadmin@pse-consulting.de> wrote:
>
>
>
>>A.j. Langereis wrote:
>>
>>
>>>Dear all,
>>>
>>>Would it be possible to have to different symbols for index scans and
>>>sequence scans? Just like there is a different symbol for bitmap scans..
>>>
>>>
>>Generally speaking yes; would you provide images?
>>
>>Currently, bitmap scans aren't recognized, and thus shown as unknown
>>(question mark).
>>
>>Ideally, we'd need these images:
>>
>>- Seq Scan
>>- Index Scan
>>- Bitmap Index Scan
>>- Bitmap Heap Scan
>>- Tid Scan
>>
>>
>
>Would you be able to find some time to design some icons for this please?
>
>Also, if you can find another few minutes; Andreas replaced the delete icon
>on the main toolbar with one of his own because there was some confusion
>over the X symbol you had used. If you can redo that one with a waste paper
>bin or similar that would be great - Andreas' one just looks subtly
>different to the rest of yours and stands out as a result :-(
>
>

Ah ok so my images are not good enough for you.... sniff....

Regards,
Andreas


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

I'll find the time to do this, no problem.

Regards,
Niko.

-----Message d'origine-----
De*: Dave Page [mailto:dpage@vale-housing.co.uk]
Envoyé*: dimanche 27 novembre 2005 21:01
À*: Ennixo
Cc*: pgadmin-support@postgresql.org; A.j. Langereis; Andreas Pflug
Objet*: Re: [pgadmin-support] Graphical explain

Hi Niko,


On 27/11/05 7:06 pm, "Andreas Pflug" <pgadmin@pse-consulting.de> wrote:

> A.j. Langereis wrote:
>> Dear all,
>>
>> Would it be possible to have to different symbols for index scans and
>> sequence scans? Just like there is a different symbol for bitmap scans..
>
> Generally speaking yes; would you provide images?
>
> Currently, bitmap scans aren't recognized, and thus shown as unknown
> (question mark).
>
> Ideally, we'd need these images:
>
> - Seq Scan
> - Index Scan
> - Bitmap Index Scan
> - Bitmap Heap Scan
> - Tid Scan

Would you be able to find some time to design some icons for this please?

Also, if you can find another few minutes; Andreas replaced the delete icon
on the main toolbar with one of his own because there was some confusion
over the X symbol you had used. If you can redo that one with a waste paper
bin or similar that would be great - Andreas' one just looks subtly
different to the rest of yours and stands out as a result :-(

Regards, Dave





---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings