AND
(((LP.LOKAL_KOD = $3 AND $4 = 'K')) OR ((I.ypt_lcl_kod = $3 AND $4 =
'I'))) GROUP BY S.KALKIS_YERI,S.VARIS_YERI,S.SAAT;
$BODY$ LANGUAGE 'sql' VOLATILE;
Adnan DURSUN
ASRIN Bilişim Ltd.Şti
Turkey
From: Michael Fuhr
Date: 02/13/06
07:46:05
To: Adnan DURSUN
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM]
SQL Function Performance
On Sun, Feb 12, 2006 at 10:25:28PM +0200, Adnan DURSUN wrote:
>> My database has
From: Michael Fuhr
Date: 02/13/06
07:46:05
To: Adnan DURSUN
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] SQL
Function Performance
On Sun, Feb 12, 2006 at 10:25:28PM +0200, Adnan DURSUN wrote:
>> My database has an SQL function. The result co
>From: Mark
Liberman
>Date: 02/13/06
22:09:48
>To: Adnan DURSUN; pgsql-performance@postgresql.org
>Subject: RE: [PERFORM]
SQL Function Performance
>I've run into this issue. It basically comes down to the
plan that is being used inside the function is not the same as
---Original Message---
From: Mark Liberman
Date: 02/14/06 01:46:16
To: Adnan DURSUN; pgsql-performance@postgresql.org
Subject: RE: [PERFORM] SQL
Function Performance
>> in my case; both direct query and sql function gererate
same execution plan. Also, execution plan belo
From: Michael Fuhr
Date: 02/14/06 03:32:28
To: Tom Lane
Cc: Adnan DURSUN; pgsql-performance@postgresql.org
Subject: Re: [PERFORM] SQL
Function Performance
On Mon, Feb 13, 2006 at 07:57:07PM -0500, Tom Lane wrote:
>> "Adnan DURSUN" <[EMAIL PROTECTED]> writes:
&
---Original Message---
From: Michael Fuhr
Date: 02/14/06 23:05:55
To: Adnan DURSUN
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] SQL
Function Performance
>On Tue, Feb 14, 2006 at 11:33:57AM +0200, Adnan DURSUN wrote:
>>
-> Nested Loop
-> Index Scan using t_yer_pkey on t_yer y1 (cost=0.00..4.45
rows=1 width=14) (actual time=0.004..0.006 rows=1
loops=94)""
Index Cond: (""outer"".kalkis_yer_kod =
y1.kod)""
Filter: ((iptal)::text =
'H'::t
>From: Tom Lane
>Date: 02/16/06
19:29:21
>To: Adnan DURSUN
>Cc: pgsql-performance@postgresql.org
>Subject: Re: [PERFORM]
Why does not perform index combination
>"Adnan DURSUN" <[EMAIL PROTECTED]> writes:
>> I have query for a report. Explain anal
Hi,
I wonder how PostgreSQL caches the SQL query results. For example ;
* does postgres cache query result in memory that done by session A
?
* does session B use these results ?
Best Regards
Adnan DURSUN
---(end of broadcast
Because an execution plan is created
before..
Sincenerly
Adnan DURSUN
- Original Message -
From: "Tomeh, Husam" <[EMAIL PROTECTED]>
To: "Adnan DURSUN" <[EMAIL PROTECTED]>;
Sent: Wednesday, October 04, 2006 1:11 AM
Subject: Re: [PERFORM] PostgreSQL Cach
- Original Message -
From: "Tomeh, Husam" <[EMAIL PROTECTED]>
To: "Adnan DURSUN" <[EMAIL PROTECTED]>;
Sent: Wednesday, October 04, 2006 4:29 AM
Subject: RE: [PERFORM] PostgreSQL Caching
Query plans are not stored in the shared buffers and there
12 matches
Mail list logo
