pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Miroslav Šulc <miroslav.sulc@startnet.cz>
To: John Arbash Meinel <john@arbash-meinel.com>
Cc: PGSQL mailing list <pgsql-performance@postgresql.org>
Subject: Re: How to read query plan
Date: Sun, 13 Mar 2005 20:51:05 +0100
Message-ID: <423499A9.5080504@startnet.cz> (raw)
In-Reply-To: <423493E5.6040203@arbash-meinel.com>
References: <42345D24.8070104@startnet.cz>
	<4234692E.3050802@arbash-meinel.com>
	<42347407.2000202@startnet.cz>
	<42347D5E.9000900@arbash-meinel.com>
	<42348F54.1000408@startnet.cz>
	<423493E5.6040203@arbash-meinel.com>

John Arbash Meinel wrote:

> Is there a reason to use varchar(1) instead of char(1). There probably
> is 0 performance difference, I'm just curious.

No, not at all. I'm just not used to char().

> Well, with cursors you can also do "FETCH ABSOLUTE 1 FROM
> <cursor_name>", which sets the cursor position, and then you can "FETCH
> FORWARD 30".
> I honestly don't know how the performance will be, but it is something
> that you could try.

This is science for me at this moment :-)

>> For display of single page consisting of 30 rows. The reason I query
>> all rows is that this is one of the filters users can use. User can
>> display just bigboards or billboards (or specify more advanced
>> filters) but he/she can also display AdDevices without any filter
>> (page by page). Before I select the 30 row, I need to order them by a
>> key and after that select the records, so this is also the reason why
>> to ask for all rows. The key for sorting might be different for each 
>> run.
>>
> How are you caching the information in the background in order to
> support paging? Since you aren't using limit/offset, and you don't seem
> to be creating a temporary table, I assume you have a layer inbetween
> the web server and the database (or possibly inside the webserver) which
> keeps track of current session information. Is that true?

I just need three information:
1) used filter (stored in session, identified by filter index in query 
string)
2) page length (static predefined)
3) what page to display (in query string)

>> In fact, on MySQL I didn't see any slow reactions so I didn't measure
>> and inspect it. But I can try it if I figure out how to copy the
>> database from PostgreSQL to MySQL.
>
>
> I figured you still had a copy of the MySQL around to compare to. You
> probably don't need to spend too much time on it yet.

It's not so simple because there are some differences between MySQL and 
PostgreSQL in how they handle case sensitivity etc. The database table 
structures are not the same too because of different data types support 
and data values support.

>
> John
> =:->

Miroslav

Attachments:

miroslav.sulc.vcf (text/x-vcard, 385B) download begin:vcard fn;quoted-printable:Miroslav =C5=A0ulc n;quoted-printable:=C5=A0ulc;Miroslav org:StartNet s.r.o. adr;quoted-printable;quoted-printable:;;Vrchlick=C3=A9ho 161/5;Praha 5;;150 00;=C4=8Cesk=C3=A1 republika email;internet:miroslav.sulc@startnet.cz title:CEO tel;work:+420 257 225 602 tel;cell:+420 603 711 413 x-mozilla-html:TRUE url:http://www.startnet.cz version:2.1 end:vcard

view thread (37+ messages)  latest in thread

Message-ID: <423499A9.5080504@startnet.cz>
Permalink:  ../423499A9.5080504@startnet.cz/
Also on:    postgresql.org/message-id/423499A9.5080504@startnet.cz

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: miroslav.sulc@startnet.cz, john@arbash-meinel.com
  Subject: Re: How to read query plan
  In-Reply-To: <423499A9.5080504@startnet.cz>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox