y issues I need to fix or improve
by the next 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 eno
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
--
Sent
; [1] http://archives.postgresql.org/pgsql-hackers/2009-04/msg00234.php
I exported the reporting function to itup.h.
[include/access/itup.h]
extern void report_unique_violation(Relation rel, IndexTuple itup);
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
report_dupkey-20090721
The attached patch only adds "FORCE 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
based tuning 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 subscriptio
ch 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
Descri
ons.
The attached 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)
nge 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
bles 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
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 commit
e 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
ifferent disk drives. We 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.
Rega
ptable to use pthread in contrib 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
efine 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
--
Sent vi
n database 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 yo
for the module,
for example, "TRIGGER ON DROP TABLE" or some 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
ile.
- FUNCTION dbms_stats.import() : import statistics 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 Takahi
rewrite storage tcop \
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
te_query() 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
r 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
--
ECT 1') AS t(i integer);
ERROR: user mapping 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 fo
not a Japanese-specific problem and just because
they use 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-ha
com/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
element,
xmlattributes (1 as one, 'deuce' as two, '<>&"''' as three),
'content', '<>&"''');
xmlelement
ECT CASE WHEN EXISTS
(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-hacker
o) for
> thread-safety?
Use 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)
T
4.php
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
ectory 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 mai
ace_bitmapscan to
print 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
as a symbolic link, 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
x27;"
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 Software Center
server-side_encoding_issues_20090415.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
Tom Lane wrote:
> Itagaki Takahiro 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
> minor proble
Itagaki Takahiro wrote:
> "Hiroshi Saito" 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 it is help much.
&
h
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 subscrip
stem path 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 Softwa
rks 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@postgr
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:
http://www.postgresql.org/mailpref/pgsql-hackers
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
ubmit the patch to the next commit-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
action_min_duration'
will be possible.
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
ourColumn)
((Form_pg_statistic) (vardata->statsTuple))->stadistinct =
YourNDistinct;
}
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
not supported
by companies and 3rd 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.
regular load (like benchmarks).
I cannot see any differences whether profiling is on/off.
So 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
. Also, I'd better measure overheads
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
31 | Lock:Tuple |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 dat
too. In my 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
Regar
k. So 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:
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
for a core feature.
Could you split the patch into a core-patch and an extension module?
The extension module would be put in contrib or in a pgFoundry project.
XML might be good for communications between the core and the module;
XML-explain was ongoingly discussed, but had not been completed yet.
R
Peter Eisentraut 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.
ITAGAKI Takahiro 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 l
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" wrote:
> Bug reference: 4660
> PostgreSQL version: 8.3.3
> Operating system: Fedora 8
> Description:float functions ret
Tom Lane wrote:
> ITAGAKI Takahiro 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 and frie
ITAGAKI Takahiro 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://wi
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 Takahir
casts, it seems to be ignored.
CREATE FUNCTION array_find(text[], text, 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
$$
Alvaro Herrera 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 t
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
the-fly, though.
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
descriptions about options here. ***
=# SELECT oid, relname, reloptions FROM pg_class
WHERE oid = 'pg_toast.pg_toast_16388'::regclass;
oid |relname | reloptions
---+----+-----
16391 | pg_toast_16388 | {fillfactor=70}
Regards,
---
ITAGAKI Takahiro
NT
g 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 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':
> &
abled:
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
es to maximum values?
Are there any trade-off?
- Are there some conditions where whole-table-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 Tak
a bad idea to place 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 recover
have at least two requirements:
- Avoid overheads. If checking cpu usage is slow, we'd 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
NT
Magnus Hagander 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
I 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
d the flexibility because it should accept only valid
parameters 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 Cente
Tom Lane wrote:
> ITAGAKI Takahiro 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 w
ime not total call count.
I think the current implementation is not ideal, too.
I also 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 b
ged only once
on non-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 So
3,7 +123,7 @@
*/
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 l
ix character, not only 0-9A-Za-z.
> I do like 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
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
passed by reference (especially on 32bit platform).
It'd be better to copy values:
Counterstmp;
/* copy the actual values in spinlock */
SpinLockAcquire(&entry->mutex);
tmp = entry->counters;
SpinLockRelease(&entry->mutex);
/* create a tuple aft
o another struct
something 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, AFA
ad_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 chan
ot; .
However, pg_is_in_replication() is enough for 8.4, so I think
it has low 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
ession test in my 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
ling and connections pooling 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 Takah
egression tests can finish
successfully but there is still a difference. 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 v
on-0 result normally. Some O/R mapping tools
also checks 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-hackers
ave 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
ffer hits
%R : # of local buffer reads
%W : # of local buffer 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:
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
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
_builddir)/src/Makefile.global
+
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
_concurrency()]
+ prefetch_pages = 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
slow queries. We could use the logging for slow
queries executed rarely and use the module queries executed many 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
ery).
We can 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,
t XML-explain and TABLE-expalin are useful,
but they are independent features from pg_stat_statements. So I'd
like to discuss them in separated 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
ght slow down EXPLAIN ANALYZE
because some fields 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
ed by struct Instrumentation.
----
Comments 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
Is it acceptable? I think we need 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
ast (and the bug is fixed 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
7 6a 93 fa
EUCJP:wcs = 90 85 97 6a 93 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
--
Sen
erals in the format 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 chang
w flag argument in XLogFlush.
[6] Bit-OR or Logical-OR
WaitXLogSend(XactLastRecEnd, false, forceSyncCommit | haveNonTemp);
should be
WaitXLogSend(XactLastRecEnd, false, forceSyncCommit || haveNonTemp);
| is bit OR and || is logical OR.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software C
e so inclined).
I used 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-hac
501 - 600 of 891 matches
Mail list logo
