expression_tree_walker
12092 1.2530 LWLockAcquire
12078 1.2515 XLogInsert
(skip)
6248 0.6474 AllocSetFree
I think this patch improves AllocSetAlloc/AllocSetFree performance.
Best regards,
---
Atsushi Ogawa
a_og...@hi-ho.ne.jp
#!/usr/bin/perl
system "gcc -O2 -o alloc_test alloc_t
C_MINBITS);
Assert(idx < ALLOCSET_NUM_FREELISTS);
}
Best regards,
---
Atsushi Ogawa
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
samples %symbol name
47610 4.9333 AllocSetAlloc
6248 0.6474 AllocSetFree
fls
samples %symbol name
48779 4.9954 AllocSetAlloc
7648 0.7832 AllocSetFree
Best regards,
---
Atsushi Ogawa
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make
l name
20629 1.0684 libc-2.3.4.somemcpy
---
Atsushi Ogawa
*** ./src/backend/utils/cache/catcache.c.orig 2009-07-06 22:06:52.0
+0900
--- ./src/backend/utils/cache/catcache.c2009-07-06 13:51:48.0
+0900
***
*** 112
Tom Lane writes:
> Atsushi Ogawa writes:
> > Attached patch is reduce the memcpy calls from SearchCatCache
> > and SearchCatCacheList. This patch directly uses cache->cc_skey
> > in looking for hash table.
>
> How much did you test this patch? I'm fairly sure
ql replaces all
string, and regexp_replace() of oracle10g is also similar.
And I think that it is better to be able to specify the option with text.
I think about this function specification:
regexp_replace(
string text, pattern text, replacement text
) RETURNS TEXT; /* Replace all */
regexp_replace(
s
David Fetter wrote:
> On Tue, Jun 07, 2005 at 10:27:28PM +0900, Atsushi Ogawa wrote:
> > David Fetter wrote:
> > > Ogawa-san,
> > >
> > > I think that this would be a case for function overloading:
> > >
> > > function regexp_replace(
mmas or using single characters.
I think that it is good to specify the flags by one character as well
as Perl.
I propose the following specification:
regexp_replace(source text, pattern text, replacement text, [flags text])
returns text
The flags can use the following values:
Bruce Momjian wrote:
> Atsushi Ogawa wrote:
> > I propose the following specification:
> >
> > regexp_replace(source text, pattern text, replacement text, [flags
text])
> > returns text
> >
> > The flags can use the following values:
> > g: global (
the same item is updated many times.
An attached patch is test implementation of this idea. This patch is
not complete, but it might be useful to show this idea.
regards,
--- Atsushi Ogawa
*** ./src/backend/access/nbtree/nbtinsert.c.orig 2005-10-08 09:57:33.316123472 +0900
--- ./src/backend
Tom Lane <[EMAIL PROTECTED]>:
> Atsushi Ogawa <[EMAIL PROTECTED]> writes:
> > When _bt_check_unique finds a dead item that has same data as new
> > item, LP_DEAD is set to the item. Can we reuse this dead item instead
> > of inserting new item?
>
> This strik
=2.01..8.49 rows=3 width=0)
Recheck Cond: (index_col = 'B'::text)
-> Bitmap Index Scan on test_tbl_idx (cost=0.00..2.01 rows=3 width=0)
Index Cond: (index_col = 'B'::text)
select count(*) from test_tbl where index_col = 'B';
count
-
the target table in UPDATE.
Is it still TODO? If it is TODO, I will try it.
--- Atsushi Ogawa
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
13 matches
Mail list logo
