[HACKERS] hello

hello: I have Order china Product Apple iPad Wi-Fi 32GB I have received the product! this website:Toradeo.com I believe you will find what you want there and have an good experience on shopping from them. Regards! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make chang

[HACKERS] hello

hello: I have good news for you. Last week ,I have Order china New Apple iPad Wi-Fi 32GB this website: www.Toradeo.com I have received the product! I believe you will find what you want there and have an good experience on shopping from them. Regards! -- Sent via pgsql-hackers mailing list (pgsq

[HACKERS] costing for arbitrary path

I wish to estimate the total cost for a given path of a query. This path is a tree consists of nestloop, hashjoin, mergejoin as internal nodes with seqscan or idxscan at the leaves. My approach is to cost the path bottom-up, and invoke the "cost_nestloop", "cost_merge_join" etc. The problem is t

[HACKERS] SearchSysCache

My program (indirectly) calls the following function twice, tuple = SearchSysCache(STATRELATT, ObjectIdGetDatum(relid), Int16GetDatum(colnum), 0, 0); The first time it assigns NULL to tuple, while the second time it assigns a valid pointer. Why is it like that? BTW, my program only optimize q

[HACKERS] undescribe

unsubscribe  pgsql-hackers 

Re: [HACKERS] postgresql query string length limit

i am using psql client. On Fedora core (linux core: 2.4.20-8 ) as well on Suze 10.0 (core: 2.6.13-15.7-smp). Both has the same problem. thanks /19/06, Mark Kirkwood <[EMAIL PROTECTED]> wrote: > uwcssa wrote: > > I am using version 8.0.3. i installed using the > &g

Re: [HACKERS] postgresql query string length limit

I am using version 8.0.3. i installed using the --without-readline option. is there a quick workaround? On 2/19/06, Douglas McNaught <[EMAIL PROTECTED]> wrote: > uwcssa <[EMAIL PROTECTED]> writes: > > > I found any query exceeds 4096 charactors will be prun

[HACKERS] postgresql query string length limit

 I found any query exceeds 4096 charactors will be pruned automatically. i am wondering which knob should i change to make it larger , say, 1 charactors.  i searched for a while but was not able to find it online.  so if anyone has a quick nswer that will be highly appreciated.    

[HACKERS] postgresql bug?

i am using version 8.0.3 if you run the following query: select count(*) from T1 where  (T1.a>10 and T1.a<20) or (T1.a>90 and T1.a<100) the set_baserel_size_estimate will accurately estimate the selectivity on T1. However, if you run select count(*) from T1, T2 where T1.b=T2.c and  (T1.a>10 an

Re: [HACKERS] un-vacuum?

. > On 1/19/06, Hannu Krosing <[EMAIL PROTECTED]> wrote: > > Ühel kenal päeval, N, 2006-01-19 kell 14:25, kirjutas uwcssa: > > > I have a simple question here, not sure if i should posted here but > > > if you have the quick answer, it helps a lot > > > &g

[HACKERS] un-vacuum?

I have a simple question here, not sure if i should posted here but if you have the quick answer, it helps a lot i have a table that is already "vacuum"ed. for some reason i want to un-vacuum it instead of dropping the table and recreate the table and indexes on it. is there a existing command t

[HACKERS] suppress output for benchmarking

 I am testing the performance of postgresql on a set of workloads. However, the output significantly affects the performance evaluation. Is there a way to by-pass all output of select statements so the timing reflects only the query evaluation process? thanks a lot

[HACKERS] function caching problem

I modified postgresql 8.1 for its optimization part. Basically I reset the whole memory context after query optimization (but store the query plan in top level memory context so it is not lost). Later at certain time, I match queries to the pre-computed query plans (to avoid re-compiling the whole

Re: [HACKERS] equivalence class not working?

proving this code as foreseen by Nels."   Therefore, equivalence class should be detected and used for index selection...  or anyone could tell me if after 7.1  Postgresql has determined not to use equi-join for index selection...   On 1/16/06, Tom Lane <[EMAIL PROTECTED]> wrote: uwcssa <[EMA

[HACKERS] equivalence class not working?

not sure if this is the right place to post...   I am using postgres 8.1.  In indxpath.c, it says " Note: if Postgres tried to optimize queries by forming equivalenceclasses over equi-joined attributes (i.e., if it recognized that a qualification such as "where a.b=c.d and a.b=5" could make use of

Re: [HACKERS] Getting table name/tuple from OID

Thanks for the quick reply. I made a mistake last time by asking the question: actually, i would like to know how to get the OID from a table name or operator name.   For example, ">" is 512 while "="  is 96.   and some table has the magic relid of 20078, say. How could I find out the OID by givin