[HACKERS] hello

2010-07-02 Thread uwcssa
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

[HACKERS] hello

2010-07-01 Thread uwcssa
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

[HACKERS] costing for arbitrary path

2007-01-03 Thread uwcssa
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 that

[HACKERS] SearchSysCache

2007-01-02 Thread uwcssa
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

[HACKERS] undescribe

2006-10-02 Thread uwcssa
unsubscribepgsql-hackers

[HACKERS] postgresql query string length limit

2006-02-19 Thread uwcssa
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.

Re: [HACKERS] postgresql query string length limit

2006-02-19 Thread uwcssa
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 pruned automatically. i am wondering

Re: [HACKERS] postgresql query string length limit

2006-02-19 Thread uwcssa
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 --without-readline option

[HACKERS] postgresql bug?

2006-02-04 Thread uwcssa
i am using version 8.0.3 if you run the following query: select count(*) from T1 where (T1.a10 and T1.a20) or (T1.a90 and T1.a100) 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.a10 and

Re: [HACKERS] un-vacuum?

2006-01-19 Thread uwcssa
this. 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 i have a table that is already vacuumed. for some

[HACKERS] suppress output for benchmarking

2006-01-18 Thread uwcssa
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

2006-01-17 Thread uwcssa
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

[HACKERS] equivalence class not working?

2006-01-16 Thread uwcssa
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 ofan

Re: [HACKERS] equivalence class not working?

2006-01-16 Thread uwcssa
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 [EMAIL PROTECTED] writes: I am using postgres 8.1

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

2005-11-11 Thread uwcssa
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 giving the