Following this there was a phase were
it did a lot of seeks and reads on files under pg_clog, and it was while
doing this (or perhaps it had finished whatever it wanted with clogs) it
dropped into the send()/SIGUSR1 loop that goes for another several minutes.
Kim
Tom Lane wrote:
I wro
number of stats table entries times the number
of pg_class rows; in other words O(N^2) if the stats collector's
information is reasonably complete. Replace list searching with a
hash table to bring it back to O(N) behavior. Per report from kim
at myemma.com. Back-patch as far as 8.1; 8.
lInfoData', so my question boils down to:
What do I put into this struct to call 'on_pb' with two arguments from the call
to
my function?
Further, is there a way to access data in tables in the database other than
those
given as arguments to the function? And how?
Sincerely
Kim
Thanks too!
Korean User Group has been translating PGDoc since 2013.
I'll append Copyright in PGDoc.kr too.
http://postgresql.kr/docs/current/
Regards, Ioseph.
2016-03-04 (금), 17:55 -0800, Joshua D. Drake:
> On 03/04/2016 05:39 PM, Tatsuo Ishii wrote:
> > JPUG (Japan PostgreSQL Users Group) w
Thanks.
Korean Document is translating currently.
When that be done, I will announce to official site.
current, translation progress is 50%.
This work is dependent only voluntary support by 6 peoples.
so, translating is very slow. :)
I also hope that many Korean documents appear on the official s
debuged to client only.
So, I propose that error value of bind variable will be displayed at a
server log.
in parse_target.c:529,
input parameter value of that node not containded value of column at
client.
I want more detail error log.
Regards, Ioseph Kim
--
Sent via pgsql-hackers mailing list
ds, Ioseph.
2016-03-14 (월), 23:06 -0400, Tom Lane:
> Ioseph Kim writes:
> > I want see that value of bind variable at a server log.
>
> That's available if you turn on log_statements, IIRC.
>
> regards, tom lane
>
>
--
Sent via
"a" is of type boolean but expression is of type
integer(input value = 24) at character 25"
Best regards, Ioseph.
2016-03-15 (화), 13:54 +0800, Craig Ringer:
> On 15 March 2016 at 10:52, Ioseph Kim wrote:
> Hi, hackers.
>
> I had a error message
Hello,
I want to speak a proposal on PGCon 2016.
Currently I wrote only title of contents.
Main title is "PostgreSQL in Korea".
That proposal contains
* Short history of PostgreSQL in Korea (status of korean user group
and theses works)
* kt (korea telecom) report (for PostgreS
Sorry ^^
2016-01-18 (월), 16:10 +0900, Michael Paquier:
> On Mon, Jan 18, 2016 at 3:29 PM, Ioseph Kim wrote:
> > What can I do for next step?
>
> (pgsql-hackers is not the right place to ask that, it is a mailing
> list dedicated to the development and discussion of new feature
Hi.
In DocBook 4.2 sgml dtd, figure tag is supported already.
that was implemented for multi output format.
I remember that very old postgresql document has some picture (eg.
system architecture, ERD ...).
when release new version, these might be changed, nevertheless these can
not been.
this p
On 수, 2016-02-17 at 12:14 +0300, Alexander Lakhin wrote:
> 17.02.2016 09:17, Tatsuo Ishii wrote:
> >> Hi.
> >>
> >> In DocBook 4.2 sgml dtd, figure tag is supported already.
> >> that was implemented for multi output format.
> > Ok, there's no technical problems with figures then. MySQL docs has
Hi,
I tried ver. 10 beta3.
I had below messages.
-
$ pg_ctl start
서버를 시작하기 위해 기다리는 중완료
서버 시작됨
2017-08-22 14:06:21.248 KST [32765] 로그: IPv6, 주소: "::1", 포트 5433
번으로 접속을 허용합니다
2017-08-22 14:06:21.248 KST [32765] 로그: IPv4, 주소: "127.0.0.1", 포트
5433 번으로 접속을 허용합니다
2017-08-22 14:06:21.364 KST
n 'host=127.0.0.1 port=5432 client_encoding=C' publication pub1;
오류: 발행 서버에 연결 할 수 없음: 서버에 연결할 수 없음: 연결이 거부됨
"127.0.0.1" 호스트에 서버가 가동 중인지,
5432 포트로 TCP/IP 연결이 가능한지 살펴보십시오.
2017년 08월 23일 22:40에 Peter Eisentraut 이(가) 쓴 글:
On 8/22/17 01:19, Ioseph Kim wrote:
2017-08-22
Sorry, i can't receive mailing :(
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
rwrite only the updated column,
the performance difference between Oracle and PG in that case may be
significant.
I researched about this issues in mailing list and google.
But I've not found anything related to this issues.
Thank you.
Kisung Kim.
(C)Bitnine, Kisung Kim, Ph.D
https://s
2015-10-26 11:12 GMT+09:00 Michael Paquier :
>
>
> On Mon, Oct 26, 2015 at 10:52 AM, Kisung Kim wrote:
>
>> Because of the internal implementation of MVCC in PG
>> the update of a row is actually a insertion of a new version row.
>> So if the size of a row is huge
which I think of not a good solution.
2015-11-24 8:12 GMT+09:00 Chapman Flack :
> Has anyone got the stomach to try such a thing and see what happens?
> I don't have MSVC here.
>
> -Chap
We have the environment to test your ideas.
Can you explain your ideas with more detail?
Hello,
at PostgreSQL version 9.5rc1,
at line 934 in pg_recvlogical.c
set_pglocale_pgservice(argv[0],PG_TEXTDOMAIN("pg_recvlogical"));
this references invalid catalog file, because pg_basebackup,
pg_recvlogical, pg_receivexlog commands use same catalog file
pg_basebackup.mo
pg_receivexl
Hi, I'm Korean.
CP51949 is EUC-KR correct.
so, that defined code is correct too.
But in Korea, EUC-KR code is not good to use all Korean character.
In recent years, many people in Korea use the CP949 code.
MS Windows codepage also is CP949.
- Original Message -
From: "Takahiro Itagaki"
ion to the web interface, you can send Bugzilla an email that will create a new bug, or will modify an existing bug. You can also
very easily attach files to bugs this way.
http://www.bugzilla.org/features/#email-in
Regards,
Kim
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgres
Hi,
I propose to append an error message when index name and table name are
same.
example:
postgres@postgres=# create table t (a int not null, constraint t primary
key (a));
ERROR: relation "t" already exists
End users will confusing pretty, because if users meet this message,
users w
Hello.
In po.ko (korean message) at psql
#: command.c:2971
#, c-format
msgid "Watch every %lds\t%s"
msgstr "%ld초 간격으로 지켜보기\t%s"
this message string is a cut string, because buffer size is small.
At line 2946 in src/bin/psql/command.c
chartitle[50];
size of message string for korean
2016년 06월 15일 01:56에 Tom Lane 이(가) 쓴 글:
I take it from the vast silence that nobody particularly cares one way
or the other. On reflection I think that this would be a good change
to make, so I'll go do so unless I hear complaints soon. regards, tom
lane
I propose to change from asctime()
Thanks, I agree that strftime() is better then asctime().
regards, Ioseph
2016년 06월 16일 08:37에 Tom Lane 이(가) 쓴 글:
> Alvaro Herrera writes:
>> +1 to strftime("%c"). If we wanted to provide additional flexibility we
>> could have a \pset option to change the strftime format string to
>> something
x);
}
pg_stat_statements_with_timestamp_v2.patch
<http://postgresql.nabble.com/file/n5912461/pg_stat_statements_with_timestamp_v2.patch>
Regards,
Jason Kim.
--
View this message in context:
http://postgresql.nabble.com/PROPOSAL-timestamp-informations-to-pg-stat-statements-tp59123
workload (only insert),
then is there any chances to improve PG's index behavior.
Thank you very much.
--
Bitnine Global Inc., Kisung Kim, Ph.D
https://sites.google.com/site/kisungresearch/
E-mail : ks...@bitnine.net
Office phone : 070-4800-5890, 408-606-8602
US Mobile phone : 408-805-2192
l
and leaf_pages and make more dense leaf pages.
On Wed, Aug 10, 2016 at 6:47 PM, Lukas Fittl wrote:
> On Wed, Aug 10, 2016 at 4:24 PM, Kisung Kim wrote:
>>
>> When I used the index bloating estimation script in
>> https://github.com/ioguix/pgsql-bloat-estimation,
>>
5 to 3 GB - does that really help
> performance significantly?
>
> regards
>
> Mark
>
>
> On 11/08/16 16:08, Kisung Kim wrote:
>
>> Thank you for your information.
>> Here is the result:
>>
>> After insertions:
>>
>> ycsb=# select
At Korea, Johab code is very old encondig.
by the way, cp949 code page is really used in most environments.
Personally speaking, Johab server code set is not need.
I think that PostgreSQL supports UHC (cp949) server code set.
This feature will be greet many Korean. :)
Unfortunately, UHC code set
nothing.
Good work!
Regards,
Kim
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
I guess two transactions updated a tuple concurrently.
Because versioning scheme allows old versions can be
read by another transaction, the old version can be updated too.
For example,
We have a row whose value is 1
create table t1 (i1 integer);
insert into t1 values(1);
And,
Tx1 executes up
successfully ends.
Note that catalog table updators are DDL, not DML.
I think that's why Oracle commits on execution of every DDL.
"Kangmo, Kim" <[EMAIL PROTECTED]> wrote in message
ahple2$1rgh$[EMAIL PROTECTED]">news:ahple2$1rgh$[EMAIL PROTECTED]...
> I guess
hi,
i use _int contrib module and gist index
here sample
t1.sql.gz
Description: GNU Zip compressed data
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
thanks!
error is gone.
On Пнд, 2003-07-14 at 20:36, Teodor Sigaev wrote:
> Try
> create index data_idx on testkw using gist(data gist__intbig_ops);
>
>
> Default class gist__int_ops is usable for small arrays (with small number of
> unique elements of all arrays)
>
&
=> select @-@ lseg '((0,0),(1,0))';
?column?
--
1
(1 row)
=> select @-@ path '((0,0),(1,0))';
?column?
--
2
(1 row)
--
It's maybe bug in v8.2.1
---(end of broadcast)---
TIP 4: Have you searched our list arc
when @-@ operator used at path type,
below query maybe returns 1.
because this path is just line.
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Ioseph Kim" <[EMAIL PROTECTED]>
Cc:
Sent: Saturday, February 03, 2007 5:36 AM
Subject: Re
I misunderstood. :)
path '((0,0),(1,0))' is 'closed' path.
in this case, it's maybe operator calculated return length too.
- Original Message -
From: "Ioseph Kim" <[EMAIL PROTECTED]>
To:
Sent: Saturday, February 03, 2007 6:00 AM
Subject: Re
xx to btree on col1,col2")
Regards,
Kim
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
ta', so my question boils down to:
What do I put into this struct to call 'on_pb' with two arguments from the call to my function?
Further, is there a way to access data in tables in the database other than those given as arguments to the function? And how?
Sincerely
Kim Bille
De
-selects, and is thus able to
use indices.
Looking forward for any comments. I am aware that there are workarounds
(like query2, union of two left-joins, hand coding the join from a
series of simple selects, ...) but I do not feel they are practical for
my use.
Regards,
--
Kim Bisgaard
Tom Lane wrote:
Kim Bisgaard <[EMAIL PROTECTED]> writes:
I have noticed a deficiency in the current query optimizer related to
"full outer joins". Tom Lane has confirmed to me that it will not be 8.1
material.
... There
are related issues involving
Hello
This is my first time to
post.
I
have several questions.
Currently,
there is Postgresql for ia64.
I
was wondering, previous version was optimized for ia64 or just
converted.
Now
I am looking for some way to optimize postgresql especially for ia64
machine.
(thinking
about mod
Try following the link (the Doxygen icon) - it has both a tutorial and
extensive doc.
Regards,
Kim Bisgaard
Thomas Hallgren wrote:
I wish I've had this when I started working with PostgreSQL. This
looks really good. Very useful indeed, even without the comments. What
kind of change
Hannu Krosing wrote:
Ühel kenal päeval, K, 2006-02-01 kell 18:08, kirjutas Tom Lane:
Hannu Krosing <[EMAIL PROTECTED]> writes:
Does ALTER TABLE SET TABLESPACE lock the table
It had better ... see nearby discussion about relaxing locking for
TRUNCATE.
Is it some recent
ique keys
* create and read dumps of tables
* administer one single database
* administer multiple servers
* administer postgres users and groups
Greetinx, Jan
--
+- Jan T. Kim ---+
| *NEW* --> email: [EMAIL PROTECTED]
Hello,I made new system catalog.I think
it is successful.But i got an error whenI tried to select statement to get
content of this catalog.This error is"catalog is missing 2 attribute(s) for
relid 16652".So,I found the sourcecode that this error occurs.This file is
relcache.c.This fil
47 matches
Mail list logo
