From: | paragasu <paragasu(at)gmail(dot)com> |
---|---|
To: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
Cc: | Jignesh Shah <jignesh(dot)shah1980(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: What is statement ID of table? |
Date: | 2009-10-12 06:40:06 |
Message-ID: | 89b35b8d0910112340v6a0fc470p527ffb35769227cb@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
you can create a primary key to associate with each row in the table
On 10/12/09, A. Kretschmer <andreas(dot)kretschmer(at)schollglas(dot)com> wrote:
> In response to Jignesh Shah :
>> Thanks Andreas. Sorry for confusion here. I mean statement ID that can be
>> associated with prepared query(not table) to improve performance of
>> building
>> query. I just need to find plan using statement ID and execute it. I don't
>> know
>> how to do this.
>
> Please, answer to the list and not to me, and please try to avoid html and
> top-posting.
>
> I don't know if i understand you correctly. There isn't such an ID, but
> you can look at pg_prepared_statements, this view contains name,
> statement and other informations about all (currently) prepared
> statements.
>
>
> Andreas
> --
> Andreas Kretschmer
> Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
From | Date | Subject | |
---|---|---|---|
Next Message | Thom Brown | 2009-10-12 08:13:09 | Window function order changing order of whole query |
Previous Message | Martijn van Oosterhout | 2009-10-12 06:25:56 | Re: table full scan or index full scan? |