Hi all,
I would like to work on "Allow substring/replace() to get/set bit values",
since it looks like a simple task.
The item is not marked as "easy" on the TODO though. Before proceding to a
discussion on how this functions should be implemented (I got from the messages
on the mailing list
Tom Lane wrote:
Scara Maccai <[EMAIL PROTECTED]> writes:
-> Index Scan using id_idx on tab1 (cost=0.00..8.27 rows=1
width=4) (actual time=0.010..0.011 rows=1 loops=1)
Index Cond: (id = 10)
-> Index Scan using out_id_idx on tab_outer (cos
Hi,
nobody answered on the regular mailing list, hope someone can answer here
Thank you
Original Message
Subject:[GENERAL] Matching dimensions in arrays
Date: Mon, 9 Mar 2009 01:14:57 -0700 (PDT)
From: Scara Maccai
To: pgsql-general
I've altready
Hi all,
following the link in
http://wiki.postgresql.org/wiki/Query_progress_indication
but mostly:
http://www.postech.ac.kr/~swhwang/progress2.pdf [1]
I'm trying to write an implementation of the "dne" method in postgresql.
I added another column to the pg_stat_get_activity function to repo
> You might want to take a look at this:
> http://wiki.postgresql.org/wiki/Submitting_a_Patch
I will; I'm sorry it wasn't in the proper format. It was just a proof of
concept, I guess I should have talked about it before even sending the patch.
> As to the content of the patch, I think that wh
> IMO
> any
> diagnostics you can provide for a low cost are
> useful. The more
> detail, the better. "Step 1 of 10" is good, "80%
> complete on step 1
> of 10" is better. "80% complete on step 1, 10%
> complete on 10 steps"
> is even better.
Well, I guess "Step 1 of 10" would be pretty trivi
> +1. Especially if I run it a few times and I can see
> which counters
> are still moving.
Per-node percentage is easy to do (given the perfect estimates, of course).
The problem comes when you want to give an "overall" percentage.
I wouldn't know where to put that "explain-like" output though
following:
http://www.mail-archive.com/pgsql-gene...@postgresql.org/msg135076.html
I recreated the problem using a join between 2 tables:
explain select nome1, dltbfpgpdch
FROM cell_bsc_60_0610 as cell_bsc
left outer join teststscell73_test_0610_1 as data on
data.ne_id=cell_bsc.nome1 where
data
