details
of this patch to documentation?
[pg_restore.sgml]
-c
--clean
Clean (drop) database objects before recreating them.
(8.5) Also drop large objects with same oids.
(older) Large objects with same oids are not dropped.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
commitfest?
I feel we don't have enough discussion about the feature, like:
* Is is useful enough? or are there any idea to be more useful?
* Is it ok we have two versions of profiling? (this and dtrace probes)
* Is the quality of the patch enough in terms of implmentation?
Regards,
---
ITAGAKI
QUOTE * feature.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
force_quote_all-20090717.patch
Description: Binary data
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
to change the behavior.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
is an updated version of patch; just add documenation
to copy.sgml.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
force_quote_all-20090714.patch
Description: Binary data
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http
is platform-independent.
A new feature compared with previous patch is function
pgstat_register_condition(condition, name).
We can add user-defined conditions in extended modules.
Comments welcome.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
profiler-20090714.gz
Description
in Oracle?
I didn't know that. What is the point of the works? Are there some
knowledge we should learn from?
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http
as a write-only variable.
When we supply some show_hook function to GUC variable,
SET still works but SHOW only shows '' and hides real passwords.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make
cleaner.
* Accept \sleep 1ms format (no spaces between 1 and ms) for sleep
meta command. The old version of pgbench interprets 1ms as just 1,
that means 1 s. It was confusable.
I'll add the patch to the commitfest page.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
pgbench
, they seem to be just abandoned and not maintained...
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
server and applications don't have to know the details.
I hope this will be an enhancement of contrib/pgcrypto.
Comments welcome.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription
easy way to define new types that
have only difference in typin/typout attributes, such as CREATE TYPE INHERITS
or CREATE DOMAIN WITH INPUT/OUTPUT. It is too difficult for standard users to
define operators and index support methods.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
module?
If ok, I will add the patch to the next commitfest.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
pgbench-mt.patch
Description: Binary data
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
cannot decrypt the data unless we have
all copies of the drives.
If postgres server is started manually, there might be another design
that DBA sets password as a postmaster's startup parameter. If do so,
the password is only in memory but not in disk drives.
Regards,
---
ITAGAKI Takahiro
NTT Open
from external text file.
If acceptable, I'd like to submit DBMS_STATS for Postgres module
to September commitfest. I'm not sure the feature should be in core,
in contrib, or in pgFoundry... Comments welcome.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
--
Sent via pgsql-hackers
drop-relation-hooks.
There might be another approach that we add pg_attribute.attoptions for
generic column-based options, like pg_class.reloptions.
Which approach is better, or something else?
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
--
Sent via pgsql-hackers mailing list
\
snowball snowball/libstemmer tsearch tsearch/dicts utils \
port port/win32 port/win32_msvc port/win32_msvc/sys \
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http
() and wait_for_result() in the patch.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
dblink.patch
Description: Binary data
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
for the remote query using a loop with CHECK_FOR_INTERRUPTS().
For (2), we might need to store PGresult not only in funcctx-user_fctx
but also in a global list, and free all results in XactCallback if remain.
Comments welcome.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
--
Sent via
not found for postgres
The attached patch adds 'missing_ok' parameter to GetUserMapping() and
made dblink to use it. There should be no additional security issues here
because dblink's original security check works even for server name mode.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software
multiple encodings. Encodings of OSes in Japan are often SJIS
or EUC_JP, but UTF8 is well-used in web-services and databases.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription
/en-us/library/aa363860.aspx
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
),
'content', );
xmlelement
element one=1 two=deuce
three=lt;gt;amp;quot;'contentlt;gt;amp;'/element
(1 row)
Regards,
---
ITAGAKI Takahiro
NTT Open
(SELECT 1 FROM pg_catalog.pg_largeobject WHERE loid = %u)
THEN lo_unlink(%u) END;
Comments welcome.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
pg_restore_clean_lo.patch
Description: Binary data
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org
PQescape[String|Bytea]Conn() instead of PQescape[String|Bytea]().
The static variables are used only in those deprecated functions.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your
The attached is a WIP patch add a support of '*' for FORCE QUOTE
and FORCE NOT NULL options. I'd like to submit it for the next
commit fest (8.5). Comments welcome.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
force_quote_all-20090512.patch
Description: Binary data
--
Sent via pgsql
of the tablespace directory. So, makeing
directory might fail with permission denied error.
However, it might be as well to create tablespace directories
for less-restricted installations.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
--
Sent via pgsql-hackers mailing list (pgsql
the information of bitmap scan, like trace_sort for sorting.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
, the destination
directory might be lost in such a situation. If you try to make servers
more robust, you might also need to consider broken symlinks.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make
' WITH ERROR
^
C:\home\psql eucdb -c COPY (SELECT 1) TO 'C:/home/日本語ファイル.txt'
C:\home\psql eucdb -c SELECT '日本語' WITH ERROR
ERROR: syntax error at or near WITH ERROR
LINE 1: SELECT '日本語' WITH ERROR
^
Regards,
---
ITAGAKI Takahiro
NTT Open Source
Itagaki Takahiro itagaki.takah...@oss.ntt.co.jp wrote:
Hiroshi Saito z-sa...@guitar.ocn.ne.jp wrote:
Um, I had a focus in help the problem which is not avoided.
I am not sensitive to a problem being avoided depending on usage.
However, I will wish to work spontaneously, when
Tom Lane t...@sss.pgh.pa.us wrote:
Itagaki Takahiro itagaki.takah...@oss.ntt.co.jp writes:
Here is a patch to implement GetPlatformEncoding() and convert absolute
file paths from database encoding to platform encoding.
This seems like a fairly significant overhead added to solve a really
and dtrace probes, but I'll submit it to the next commit-fest
for the record.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
profiler-20090409.tar.gz
Description: Binary data
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http
is affected by
locale settings or not in some platforms. Also, we need to research
where we should get the system encoding when the locale is set to C,
which is popular in Japanese users.
I'll report to you the progress :)
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
--
Sent
.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
perfectly as you expected.
Why don't you use bytea instead of large objects? In other words,
what you want actually is not LO improvement but efficient TOASTing, no?
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org
though there are no 'all' and 'sys' versions.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
-fest (8.5).
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
report_dupkey.patch
Description: Binary data
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
.
I'm not sure this feature should be in the core or not.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
;
}
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
party tools. Their database designs are bad, of course,
but they want to resolve their problem using knobs of databases.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http
I think sampling has little overheads for now.
Please notify me report if you see troubles.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
profiler_0311.tar.gz
Description: Binary data
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your
by the patch.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
|1.74
4 | CPU:Parse |0.87
11 | CPU:Commit |0.87
(14 rows)
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
profiler_0309.tar.gz
Description: Binary data
additional_script.sql
Description: Binary data
--
Sent via pgsql-hackers mailing list
experience,
they could be bottlenecks or consume much time in some situations.
- idle in transaction
- spinlock wait-and-retry
- CPU: Trigger execution
- CPU: Encoding conversion
- Network: send() and recv()
- smgr: lseek() calls
- Tempfile reads and writes
Regards,
---
ITAGAKI
operations in them.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
the IDs are changed anyway.
Are there any reason to keep UnusedLock1 there?
Or can we remove it simpley?
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http
.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Peter Eisentraut pete...@gmx.net wrote:
ITAGAKI Takahiro wrote:
Here is a patch to allow 'on' and 'off' as input texts for boolean.
Regarding your FIXME comment, I think parse_bool* should be in bool.c
and declared in builtins.h, which guc.c already includes.
(Conceptually, the valid
ITAGAKI Takahiro itagaki.takah...@oss.ntt.co.jp wrote:
The attached is a patch to change 3 things:
- Reject toast.fillfactor.
- Modify relopt_kind to bit flags.
- Report relation type on unrecognized parameter errors.
I registered the patch as an open item:
http://wiki.postgresql.org
Tom Lane t...@sss.pgh.pa.us wrote:
ITAGAKI Takahiro itagaki.takah...@oss.ntt.co.jp writes:
- Are there any limitations in casting to anyelement?
It's a no-op ... probably we shouldn't even let you do it, if the
lack of an error leaves room for such misinterpretation as this.
anyelement
I reported the following bug to -bugs, and I'd like to discuss
whether we need to fix the issue or how to fix it.
ITAGAKI Takahiro itagaki.takah...@oss.ntt.co.jp wrote:
Bug reference: 4660
PostgreSQL version: 8.3.3
Operating system: Fedora 8
Description:float functions return
ITAGAKI Takahiro itagaki.takah...@oss.ntt.co.jp wrote:
- Postgres interprets 'on' as true and 'off' as false in configuration
parameters, but they are not accepted in sql-boolean.
Is it a design? or should we add a parser for 'on' and 'off' ?
I'd like to allow 'on' and 'off
, anyelement)
RETURNS anyelement AS
$$
SELECT substring(i from E'\\W*=(.*)')::anyelement
FROM unnest($1) AS t(i) WHERE i LIKE $2 || '=%'
UNION ALL SELECT $3 LIMIT 1
$$
LANGUAGE sql IMMUTABLE STRICT;
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
attempts but also for
connection performance? The name would be CONNECTION_[START|DONE] like
other existing probes.
I received a report from my client that Postgres didn't return responce
of heatbeat connection requests for *1 minute*, but there are few methods
to dig it now...
Regards,
---
ITAGAKI
Alvaro Herrera alvhe...@commandprompt.com wrote:
ITAGAKI Takahiro wrote:
With reloption patch, we can set WITH options to toast tables.
However, fillfactor for toast tables is useless, no?
Maybe what we should do is just reject fillfactor for toast tables for
now. I think this is easy
.
The current version of postgres doesn't allow to set them.
ERROR: parameter ... cannot be changed now
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
are not changed by update.
Fillfactor for toast tables will be only useful after the optimization.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
oid = 'pg_toast.pg_toast_16388'::regclass;
oid |relname | reloptions
---++-
16391 | pg_toast_16388 | {fillfactor=70}
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
--
Sent via pgsql-hackers mailing list (pgsql-hackers
application in Slony-I.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Peter Eisentraut pete...@gmx.net wrote:
ITAGAKI Takahiro wrote:
Here is a patch to surpress compiler warnings in pg_locale.c and
pg_regress.c.
There are following warnings if nls is enabled:
pg_locale.c: In function `pg_perm_setlocale':
pg_locale.c:161: warning: assignment
:
pg_locale.c:615: warning: 'IsoLocaleName' defined but not used
There is also a warning in pg_regress.c:
pg_regress.c: In function `wait_for_tests':
pg_regress.c:1367: warning: passing arg 2 of `GetExitCodeProcess' from
incompatible pointer type
Regards,
---
ITAGAKI Takahiro
NTT Open Source
-scanning vacuum is more
effective than vacuums using visibility map? If so, we should switch
to full-scan *automatically*, without relying on user configurations.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
--
Sent via pgsql-hackers mailing list (pgsql-hackers
a large object as a static variable.
It should be a pointer and allocated with palloc() in runtime.
Also those variable are only used by startup process.
- Merge readahead.h to xlog.h or something.
It export just a few functions and the functionality belongs
xlog and recovery.
Regards,
---
ITAGAKI
better
to have only buffer counters.
- Output plans with statistics more readable way.
It would be better to use XML or tables to show the information.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org
Magnus Hagander mag...@hagander.net wrote:
ITAGAKI Takahiro wrote:
Ok, wcsftime() requries both LC_TIME and LC_CTYPE are the same setting
(at least encoding) on Windows.
Hmm. Is this actually cleaner than using the original method as
suggested? Because if I understand things right
for PostgreSQL. Then, 'dummy_fdw' might be kept only for
user-defined FDWs. Since users see the library name, we'd better to
choose more suitable name for it.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org
have no other idea...
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
pg_locale-2009-01-07.diff
Description: Binary data
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Tom Lane t...@sss.pgh.pa.us wrote:
ITAGAKI Takahiro itagaki.takah...@oss.ntt.co.jp writes:
If we set shared_preload_libraries or local_preload_libraries to
load some modules, loaded library messages are logged in server
log every new connections and autovacuum workers.
Yeah, I
@@
*/
extern pid_t PostmasterPid;
extern bool IsPostmasterEnvironment;
-extern bool IsUnderPostmaster;
+extern PGDLLIMPORT bool IsUnderPostmaster;
extern bool ExitOnAnyError;
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
--
Sent via pgsql-hackers mailing list (pgsql
-EXEC_BACKEND platforms, but many times on Windows.
On the other hand, local_preload_libraries outputs logs
meny times in all platforms.
Is it too noisy? How about reducing the log level to DEBUG
and/or logging them only in postmaster?
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
don't like using fixed-size shared memory. I'm thinking
that shared memory used by extended modules to be allocated
from the shared buffer pool in the future. If we could do it,
memory management will be flexible and we can load libraries
after server starts.
Regards,
---
ITAGAKI Takahiro
NTT Open
Hi,
I found include/storage/itempos.h is not included from any sources.
What is it for? Should we remove it from the source tree?
struct ItemSubpositionData
typedef ItemSubpositionData *ItemSubposition;
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
--
Sent via pgsql
the consistency of having the custom gucs be the same as the
module name, easy to grep or google for.
Should I also rename variables used in auto_explain module?
It uses 'explain.*' now.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
pg_stat_statements.1226.tar.gz
Description: Binary
like:
struct relopt_value
{
const relopt_gen *which;
boolisset;
union
{
boolval_bool;
int val_int;
double val_real;
} types;
};
the ariables 'isset' and 'parsed_val' are not used in definition, AFAICS.
Regards,
---
ITAGAKI Takahiro
NTT Open
*/
SpinLockAcquire(entry-mutex);
tmp = entry-counters;
SpinLockRelease(entry-mutex);
/* create a tuple after lock is released. */
values[i++] = Int64GetDatumFast(tmp.calls);
values[i++] = Float8GetDatumFast(tmp.total_time);
...
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
are
typically used in the context. -- it might be a ToDo item in 8.5.
I have no idea about performance because I don't have multi-core
machine for windows. Parallel restore seems to be slower than
serial restore on single-cpu machine.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software
environment.
Who renames *-minGW32.stderr to .stderr ?
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
priority. IP address of standby can be retrived with
ps command already.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
+ process_shared_preload_libraries();
+ #endif
+
/*
* We use the ProcStructLock to protect assignment and releasing of
* AuxiliaryProcs entries.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes
. The diff seems to be
trivial and come from error message changes.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
regression.diffs
Description: Binary data
ecpg-fix.patch
Description: Binary data
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make
it.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
the result exactly and raises errors (it could be turned
off, but default is on).
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
writes
%t : # of buffile reads
%T : # of buffile writes
%u : user cpu time
%s : sys cpu time
%p : total cpu times (= %u + %s)
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
pg_stat_statements-1212.tar.gz
Description: Binary data
--
Sent via pgsql-hackers mailing list (pgsql-hackers
)
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
regression.diffs
Description: Binary data
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
= new_prefetch_pages+0.99;
You want to do as follows, right?
+ prefetch_pages = (int) ceil(new_prefetch_pages);
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http
+
all-lib: $(NAME)
install-lib: $(NAME)
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Peter Eisentraut [EMAIL PROTECTED] wrote:
On Thursday 11 December 2008 07:19:00 ITAGAKI Takahiro wrote:
I enconterd build failure in mingw.
Do we need a rule for win32ver.rc in pgevent/Makefile ?
It should be in src/makefiles/Makefile.win32. It was recently moved. Do you
perhaps have
get accumulated statistics for each query.
It might be unsufficient for complex queries.
3. Should not add any counters.
No changes to core, but usability of pg_stat_statement module
would be very poor...
Which should we take? or are there another idea?
Regards,
---
ITAGAKI Takahiro
times.
Excluding backup scripts is easy; You can create a database role for
backup and disable statement-tracking for the user using ALTER ROLE.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes
are added in struct Instrumentation and
they are counted up per tuple in EXPLAIN ANALYZE.
Also find attached some very minor verbiage changes.
Thanks. I'll apply your fixes.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
--
Sent via pgsql-hackers mailing list (pgsql-hackers
threads (and it will come in 8.5).
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
welcome.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
pg_stat_statements.1202.tar.gz
Description: Binary data
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
there).
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
to
set LC_CTYPE and other LC_* independently...
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
strings, the macro adds
wide character prefix (L...) to them.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
pg_locale-1125.diff
Description: Binary data
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http
fa
NOTE: There is another problem that specified encoding is ignored
by the functions. The result encoding is always platform default one.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
localetest.c
Description: Binary data
--
Sent via pgsql-hackers mailing list (pgsql
);
should be
WaitXLogSend(XactLastRecEnd, false, forceSyncCommit || haveNonTemp);
| is bit OR and || is logical OR.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription
a nightly snapshot(snapshot/postgresql-snapshot.tar.bz2)
and it includes *.gz files. It would be the cause.
Thanks. I'll delete the file before building.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make
to build)
$ make install
../config/install-sh: man7/*.7 does not exist.
$ touch doc/man7/dummy.7- HERE
$ make install
(succeeded to install)
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make
501 - 600 of 888 matches
Mail list logo