On Thu, 14 Jul 2011 15:15:33 +0300, Peter Eisentraut wrote:
On sön, 2011-07-10 at 11:40 -0700, Josh Berkus wrote:
Hackers,
B. 6. Current behaviour _is intended_ (there is if to check
node type) and _natural_. In this particular case user ask for text
content of some node, and this content
should I will bump this patches up.
Regards,
Radosław Smogura
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
On Sun, 10 Jul 2011 17:06:22 -0500, Robert Haas wrote:
On Jul 10, 2011, at 1:40 PM, Josh Berkus j...@agliodbs.com wrote:
Hackers,
B. 6. Current behaviour _is intended_ (there is if to check
node type) and _natural_. In this particular case user ask for
text content of some node, and this
On Tue, 12 Jul 2011 11:45:59 +0200, Florian Pflug wrote:
On Jul12, 2011, at 11:00 , Radosław Smogura wrote:
On Sun, 10 Jul 2011 17:06:22 -0500, Robert Haas wrote:
Unless I am missing something, Florian is clearly correct here.
For me not, because this should be fixed internally by making xml
Craig Ringer cr...@postnewspapers.com.au Thursday 07 of July 2011 01:05:48
On 6/07/2011 11:00 PM, Radosław Smogura wrote:
I think IPC for fast shout down all backends and wait for report
processing is quite enaugh.
How do you propose to make that reliable, though?
--
Craig Ringer
On Wed, 06 Jul 2011 07:59:12 +0800, Craig Ringer wrote:
On 5/07/2011 9:05 PM, Magnus Hagander wrote:
On Tue, Jul 5, 2011 at 15:02, Robert Haasrobertmh...@gmail.com
wrote:
On Mon, Jul 4, 2011 at 12:47 PM, Radosław Smogura
rsmog...@softperience.eu wrote:
I asked about crash reports becaus
On Mon, 04 Jul 2011 12:58:46 +0800, Craig Ringer wrote:
On 15/06/2011 2:37 AM, Radosław Smogura wrote:
Hello,
Because, I work a little bit on streaming protocol and from time to
time
I have crashes. I want ask if you wont crash reporting (this is one
of
minors products from mmap playing
Tom Lane t...@sss.pgh.pa.us Monday 04 of July 2011 16:32:32
Craig Ringer cr...@postnewspapers.com.au writes:
Why not produce a tool that watches the datadir for core files and
processes them? ...
By and large, our attitude has been that Postgres shouldn't be crashing
often enough to make
On Wed, 29 Jun 2011 22:26:39 +0200, Florian Pflug wrote:
On Jun29, 2011, at 19:57 , Radosław Smogura wrote:
This is review of patch
https://commitfest.postgresql.org/action/patch_view?id=565
Bugfix for XPATH() if expression returns a scalar value
SELECT XMLELEMENT(name root, XMLATTRIBUTES
://commitfest.postgresql.org/action/patch_view?id=565.
Regards,
Radosław Smogura
P. S.
I would like to say sorry, for such late answaer, but I sent this from other
mail address, which was not attached to mailing list. Blame KDE KMail not me
:)
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org
This is review of patch
https://commitfest.postgresql.org/action/patch_view?id=565
Bugfix for XPATH() if expression returns a scalar value
Patch applies cleanly, and compiles cleanly too, I didn't checked tests.
Form discussion about patch, and referenced thread in this patch
Martijn van Oosterhout klep...@svana.org Thursday 23 of June 2011 09:10:20
On Wed, Jun 22, 2011 at 02:31:01PM +0200, Rados??aw Smogura wrote:
I strictly disagree with opinion if there is 1% it's worthless. 1%
here, 1% there, and finally You get 10%, but of course hugepages
will work quite
On Wed, 22 Jun 2011 14:24:17 +0300, Marti Raudsepp wrote:
On Sun, Jun 19, 2011 at 12:56, Radosław Smogura
rsmog...@softperience.eu wrote:
I want to implement hugepages for shared memory
Hi,
Have you read this post by Tom Lane about the performance estimation
and a proof-of-concept patch
Greg Stark st...@mit.edu Monday 20 of June 2011 03:39:12
On Thu, Jun 16, 2011 at 9:00 PM, Tom Lane t...@sss.pgh.pa.us wrote:
BTW, if you're hacking Postgres code and don't already have a
reinstall script, you need one. Mine is basically
pg_ctl stop
cd
Hello,
I had some idea with hugepagse, and I read why PostgreSQL doesn't
support POSIX (need of nattach). During read about POSIX/SysV I found
this (thread about dynamic chunking shared memory).
http://archives.postgresql.org/pgsql-hackers/2010-08/msg00586.php
When playing with mmap I done
Florian Pflug f...@phlo.org Monday 20 of June 2011 16:16:58
On Jun20, 2011, at 15:27 , Radosław Smogura wrote:
1. mmap some large amount of anonymous virtual memory (this will be
maximum size of shared memory). ...
Point 1. will no eat memory, as memory allocation is delayed and in 64bit
Florian Pflug f...@phlo.org Monday 20 of June 2011 17:01:40
On Jun20, 2011, at 16:39 , Radosław Smogura wrote:
Florian Pflug f...@phlo.org Monday 20 of June 2011 16:16:58
On Jun20, 2011, at 15:27 , Radosław Smogura wrote:
1. mmap some large amount of anonymous virtual memory
Florian Pflug f...@phlo.org Monday 20 of June 2011 17:07:55
On Jun20, 2011, at 17:05 , Radosław Smogura wrote:
I'm sure at 99%. When I ware playing with mmap I preallocated,
probably, about 100GB of memory.
You need to set vm.overcommit_memory to 2 to see the difference. Did
you do
I want to implement hugepages for shared memory, to make it transparent I want
to do in this fashion:
1. Reserve memory M of size s
2. Try to allocate hugepage memory of as big size as possible (hs), attach at
M.
3. Allocate normal shared memory of size hs - s, and attach it at M+hs.
This
Martijn van Oosterhout klep...@svana.org Sunday 19 of June 2011 12:35:18
On Sun, Jun 19, 2011 at 11:56:15AM +0200, Rados??aw Smogura wrote:
I want to implement hugepages for shared memory, to make it transparent I
want to do in this fashion:
1. Reserve memory M of size s
2. Try to
Nicolas Barbier nicolas.barb...@gmail.com Friday 17 of June 2011 17:29:57
2011/6/17, Andrew Dunstan and...@dunslane.net:
On 06/17/2011 10:55 AM, Radosław Smogura wrote:
XML canonization preservs whitespaces, if I remember
well, I think there is example.
In any case if I will store
mixed
fillings. I think 2nd should transfer namespaces in some way to client.
What do You think?
Regards,
Radosław Smogura
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Andrew Dunstan and...@dunslane.net Friday 17 of June 2011 15:47:04
On 06/17/2011 05:41 AM, Florian Pflug wrote:
On Jun17, 2011, at 11:09 , Radosław Smogura wrote:
1.
SELECT (XPATH('/root/*', 'root xmlns:o=http://olacle.com/db;
xmlns:p=http://postgresql.org/db;o:dbab/b/a/o:dbp:db/p
:db
Florian Pflug f...@phlo.org Friday 17 of June 2011 11:41:08
On Jun17, 2011, at 11:09 , Radosław Smogura wrote:
1.
SELECT (XPATH('/root/*', 'root xmlns:o=http://olacle.com/db;
xmlns:p=http://postgresql.org/db;o:dbab/b/a/o:dbp:db/p:
db/root')); Produces:
{o:db
a
b
Andrew Dunstan and...@dunslane.net Friday 17 of June 2011 17:09:25
On 06/17/2011 10:55 AM, Radosław Smogura wrote:
Andrew Dunstanand...@dunslane.net Friday 17 of June 2011 15:47:04
On 06/17/2011 05:41 AM, Florian Pflug wrote:
On Jun17, 2011, at 11:09 , Radosław Smogura wrote:
1
Hello,
I think about following functionality to add to streaming. In some way earlier
or later soemone will add possibility for gzip communication. As I try to make
streaming, I wonder if it is possible to change TOAST compression to
GZIP/zLib, currently is LZMA.
I want to make this: if user
Hello,
I'm sending following patch which disables optimization when
--enable-debug is passed. It was nasty (for me, at least) that debug
build required passing of CFLAGS with -O0 to get nice traceable code.
Regards,
Radekdiff --git a/configure.in b/configure.in
old mode 100644
new mode
On Thu, 16 Jun 2011 14:30:27 +0200, Radosław Smogura wrote:
Hello,
I'm sending following patch which disables optimization when
--enable-debug is passed. It was nasty (for me, at least) that debug
build required passing of CFLAGS with -O0 to get nice traceable code.
Regards,
Radek
Sorry
Hello,
Here I would like to expose changes to pg_type and type infrastructure
about streaming. Changes are as follows:
- added new column typstreamin typestremout
- general contract for those is for streamin same as receive (receive
use internal), for streamout it is (internal, type)
-
On Thu, 16 Jun 2011 16:00:21 -0400, Tom Lane wrote:
Alvaro Herrera alvhe...@commandprompt.com writes:
I disagree with this change. Debug builds are very useful to have
in
production, and you don't want to be running -O0 there. I have
found
that you can use a src/Makefile.custom like this for
patch for this (currently
without IPC killing of others).
Regards,
Radosław Smogura
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
On Thu, 9 Jun 2011 14:12:59 +0200, Magnus Hagander wrote:
On Wed, Jun 8, 2011 at 12:34, Radosław Smogura
rsmog...@softperience.eu wrote:
After compilation I got big list of differences about binaries and
other
files. You may see it in patch.
Hmm. Does this really affect just cygwin
On Thu, 9 Jun 2011 14:12:59 +0200, Magnus Hagander wrote:
On Wed, Jun 8, 2011 at 12:34, Radosław Smogura
rsmog...@softperience.eu wrote:
After compilation I got big list of differences about binaries and
other
files. You may see it in patch.
Hmm. Does this really affect just cygwin
Magnus Hagander mag...@hagander.net Thursday 09 of June 2011 16:25:07
On Thu, Jun 9, 2011 at 15:40, Radosław Smogura rsmog...@softperience.eu
wrote:
On Thu, 9 Jun 2011 14:12:59 +0200, Magnus Hagander wrote:
On Wed, Jun 8, 2011 at 12:34, Radosław Smogura
rsmog...@softperience.eu wrote
After compilation I got big list of differences about binaries and
other files. You may see it in patch.
Regards,
Radekdiff --git a/.gitignore b/.gitignore
old mode 100644
new mode 100755
index 81c4d5e..75e1d9a
--- a/.gitignore
+++ b/.gitignore
@@ -20,6 +20,14 @@ lcov.info
*.vcproj
On Sun, 05 Jun 2011 22:16:41 +0200, Dimitri Fontaine wrote:
Tom Lane t...@sss.pgh.pa.us writes:
Yes. I think the appropriate problem statement is provide
streaming
access to large field values, as an alternative to just
fetching/storing
the entire value at once. I see no good reason to
Tom Lane t...@sss.pgh.pa.us Monday 06 of June 2011 16:13:26
=?UTF-8?Q?Rados=C5=82aw_Smogura?= rsmog...@softperience.eu writes:
I think more about this with contrast to sent references, but I still
have in my mind construct
Blob myWeddingDvd = conn.createBlob(myWeddingStream, size); //A
Hi,
I've got idea to auto adjust send buffer size to size of TCP congention
window. Will this increase performance and in which way. I suppose throughput
may be increased, but latency decreased. What do You think?
Regards,
Radek
--
Sent via pgsql-hackers mailing list
Tom Lane t...@sss.pgh.pa.us Monday 06 of June 2011 04:07:41
=?utf-8?q?Rados=C5=82aw_Smogura?= rsmog...@softperience.eu writes:
I've got idea to auto adjust send buffer size to size of TCP congention
window. Will this increase performance and in which way. I suppose
throughput may be
Tom Lane t...@sss.pgh.pa.us Friday 03 of June 2011 16:44:13
Alvaro Herrera alvhe...@commandprompt.com writes:
Excerpts from RadosÅaw Smogura's message of jue jun 02 15:26:29 -0400
2011:
So do I understand good should We think about create bettered TOAST to
support larger values then
Tom Lane t...@sss.pgh.pa.us Friday 03 of June 2011 16:44:13
Alvaro Herrera alvhe...@commandprompt.com writes:
Excerpts from RadosÅaw Smogura's message of jue jun 02 15:26:29 -0400
2011:
So do I understand good should We think about create bettered TOAST to
support larger values then
Hello,
Sorry for short introduction about this, and plese as far as possible,
disconnet it from LOBs, as it on top of LOB.
Idea of streaming is to reduce memory copy mainly during receiving and sending
tuples. Currently receive works as follows
1. Read bytes of tuple (allocate x memory).
2.
Tom Lane t...@sss.pgh.pa.us Friday 03 of June 2011 18:08:56
Robert Haas robertmh...@gmail.com writes:
On Thu, Jun 2, 2011 at 12:53 PM, RadosÅaw Smogura
rsmog...@softperience.eu wrote:
1. No tracking of unused LO (you store just id of such object). You may
leak LO after row
On Thu, 02 Jun 2011 15:39:39 +0300, Peter Eisentraut wrote:
On ons, 2011-06-01 at 22:00 +0200, Radosław Smogura wrote:
I partialy implemented following missing LOBs types. Requirement for
this was
to give ability to create (B/C)LOB columns and add casting
functionality e.g.
SET my_clob = 'My
Tom Lane t...@sss.pgh.pa.us Thursday 02 of June 2011 16:42:42
Robert Haas robertmh...@gmail.com writes:
But these problems can be fixed without inventing a completely new
system, I think. Or at least we should try. I can see the point of a
data type that is really a pointer to a LOB, and
Tom Lane t...@sss.pgh.pa.us Thursday 02 of June 2011 19:43:16
=?utf-8?q?Rados=C5=82aw_Smogura?= rsmog...@softperience.eu writes:
Tom Lane t...@sss.pgh.pa.us Thursday 02 of June 2011 16:42:42
Yes. I think the appropriate problem statement is provide streaming
access to large field
Hello,
I partialy implemented following missing LOBs types. Requirement for this was
to give ability to create (B/C)LOB columns and add casting functionality e.g.
SET my_clob = 'My long text'.
Idea is as follow:
0. Blob is two state object: 1st in memory contains just bytea, serialized
I didn't followed this topic carefully, so sorry If I wrote something
that was written, but I thought about following approach at least for
message sending, etc.:
1. When initializing MemoryContext (pool) give one parameter that will
be stack size. Stack is addition to normal operations.
2.
On Tue, 26 Apr 2011 14:25:10 +0200, Andres Freund wrote:
On Tuesday, April 26, 2011 01:59:45 PM Radosław Smogura wrote:
I didn't followed this topic carefully, so sorry If I wrote
something
that was written, but I thought about following approach at least
for
message sending, etc.:
1
On Sun, 17 Apr 2011 21:06:17 -0400, Robert Haas wrote:
On Sun, Apr 17, 2011 at 5:32 PM, Radosław Smogura
rsmog...@softperience.eu wrote:
Each process has simple mirror of shared descriptors.
I believe that modifications to buffer content may be only done
when holding
exclusive lock (with some
Tom Lane t...@sss.pgh.pa.us Sunday 17 April 2011 01:35:45
=?utf-8?q?Rados=C5=82aw_Smogura?= rsmog...@softperience.eu writes:
No, no, no :) I wanted to do this, but from above reason I skipped it. I
swap VM pages, I do remap, in place where the shared buffer was I put
mmaped page, and in
Tom Lane t...@sss.pgh.pa.us Sunday 17 April 2011 17:48:56
=?utf-8?q?Rados=C5=82aw_Smogura?= rsmog...@softperience.eu writes:
Tom Lane t...@sss.pgh.pa.us Sunday 17 April 2011 01:35:45
... Huh? Are you saying that you ask the kernel to map each individual
shared buffer separately? I
Andres Freund and...@anarazel.de Sunday 17 April 2011 20:02:11
On Sunday 17 April 2011 19:26:31 Radosław Smogura wrote:
Kernel merges vm_structs. So mappings are compacted. I'm not kernel
specialist, but skipping memory consumption, for not compacted mappings,
kernel uses btrees for dealing
Robert Haas robertmh...@gmail.com Sunday 17 April 2011 22:01:55
On Sun, Apr 17, 2011 at 11:48 AM, Tom Lane t...@sss.pgh.pa.us wrote:
=?utf-8?q?Rados=C5=82aw_Smogura?= rsmog...@softperience.eu writes:
Tom Lane t...@sss.pgh.pa.us Sunday 17 April 2011 01:35:45
... Huh? Are you saying that
Robert Haas robertmh...@gmail.com Monday 18 April 2011 03:06:17
On Sun, Apr 17, 2011 at 5:32 PM, Radosław Smogura
rsmog...@softperience.eu wrote:
Each process has simple mirror of shared descriptors.
I believe that modifications to buffer content may be only done when
holding
Greg Stark gsst...@mit.edu Saturday 16 April 2011 13:00:19
On Sat, Apr 16, 2011 at 7:24 AM, Robert Haas robertmh...@gmail.com wrote:
The OP says that this patch maintains the WAL-before-data rule without
any explanation of how it accomplishes that seemingly quite amazing
feat. I assume I'm
Tom Lane t...@sss.pgh.pa.us Saturday 16 April 2011 17:02:32
Greg Stark gsst...@mit.edu writes:
What he did, I gather, is treat the mmapped buffers as a read-only
copy of the data. To actually make any modifications he copies it into
shared buffers and treats them like normal. When the
Hello,
If I may, I want to share some concept to use mmap in PG. It's far, far
away from perfect, but it's keeps WAL before data. As well I crated
table, with index, inserted few values, and I done vacuum full on this
table. Db inits welcome from orginal sources.
Performance of read (if
On Fri, 15 Apr 2011 14:33:37 +0300, Heikki Linnakangas wrote:
On 15.04.2011 13:32, Radosław Smogura wrote:
If I may, I want to share some concept to use mmap in PG. It's far,
far
away from perfect, but it's keeps WAL before data. As well I crated
table, with index, inserted few values, and I
Joshua Berkus j...@agliodbs.com Friday 15 April 2011 18:55:04
Radoslaw,
10% improvement isn't very impressive from a switch to mmap. What workload
did you test with? What I'd really like to see is testing with databases
which are 50%, 90% and 200% the size of RAM ... that's where I'd
Jim Nasby j...@nasby.net Thursday 24 March 2011 20:36:48
On Mar 23, 2011, at 5:12 PM, Tom Lane wrote:
Robert Haas robertmh...@gmail.com writes:
It looks like the only way anything can ever get put on the free list
right now is if a relation or database is dropped. That doesn't seem
too
Robert Haas robertmh...@gmail.com Thursday 24 March 2011 22:41:19
On Thu, Mar 24, 2011 at 5:34 PM, Greg Stark gsst...@mit.edu wrote:
On Thu, Mar 24, 2011 at 8:59 PM, Robert Haas robertmh...@gmail.com
wrote:
It seems at least plausible that buffer allocation could be
significantly faster if
Merlin Moncure mmonc...@gmail.com Monday 21 March 2011 20:58:16
On Mon, Mar 21, 2011 at 2:08 PM, Greg Stark gsst...@mit.edu wrote:
On Mon, Mar 21, 2011 at 3:54 PM, Merlin Moncure mmonc...@gmail.com
wrote:
Can't you make just one large mapping and lock it in 8k regions? I
thought the
Merlin Moncure mmonc...@gmail.com Tuesday 22 March 2011 23:06:02
On Tue, Mar 22, 2011 at 4:28 PM, Radosław Smogura
rsmog...@softperience.eu wrote:
Merlin Moncure mmonc...@gmail.com Monday 21 March 2011 20:58:16
On Mon, Mar 21, 2011 at 2:08 PM, Greg Stark gsst...@mit.edu wrote:
On Mon
Greg Stark gsst...@mit.edu Wednesday 23 March 2011 21:30:04
On Wed, Mar 23, 2011 at 8:00 PM, Robert Haas robertmh...@gmail.com wrote:
It looks like the only way anything can ever get put on the free list
right now is if a relation or database is dropped. That doesn't seem
too good. I
Merlin Moncure mmonc...@gmail.com Monday 21 March 2011 20:58:16
On Mon, Mar 21, 2011 at 2:08 PM, Greg Stark gsst...@mit.edu wrote:
On Mon, Mar 21, 2011 at 3:54 PM, Merlin Moncure mmonc...@gmail.com
wrote:
Can't you make just one large mapping and lock it in 8k regions? I
thought the
Merlin Moncure mmonc...@gmail.com Monday 21 March 2011 20:58:16
On Mon, Mar 21, 2011 at 2:08 PM, Greg Stark gsst...@mit.edu wrote:
On Mon, Mar 21, 2011 at 3:54 PM, Merlin Moncure mmonc...@gmail.com
wrote:
Can't you make just one large mapping and lock it in 8k regions? I
thought the
Kevin Grittner kevin.gritt...@wicourts.gov Thursday 17 March 2011 22:02:18
Rados*aw Smogurarsmog...@softperience.eu wrote:
I have implemented initial concept of 2nd level cache. Idea is to
keep some segments of shared memory for special buffers (e.g.
indices) to prevent overwrite those by
Hi,
I have implemented initial concept of 2nd level cache. Idea is to keep some
segments of shared memory for special buffers (e.g. indices) to prevent
overwrite those by other operations. I added those functionality to nbtree
index scan.
I tested this with doing index scan, seq read, drop
Tom Lane t...@sss.pgh.pa.us Wednesday 23 February 2011 22:30:04
=?utf-8?q?Rados=C5=82aw_Smogura?= rsmog...@softperience.eu writes:
Here is extended version, has version field (N_ACL_RIGHTS*2) and reserved
mask, as well definition is more general then def of PGSQL. In any way it
require that
Tom Lane t...@sss.pgh.pa.us Wednesday 23 February 2011 16:19:27
rsmogura rsmog...@softperience.eu writes:
On Tue, 22 Feb 2011 20:20:39 -0500, Tom Lane wrote:
... But my question isn't about that; it's about
why aclitem should be considered a first-class citizen. It makes me
Tom Lane t...@sss.pgh.pa.us Wednesday 23 February 2011 16:19:27
rsmogura rsmog...@softperience.eu writes:
On Tue, 22 Feb 2011 20:20:39 -0500, Tom Lane wrote:
... But my question isn't about that; it's about
why aclitem should be considered a first-class citizen. It makes me
Tom Lane t...@sss.pgh.pa.us Wednesday 23 February 2011 16:19:27
rsmogura rsmog...@softperience.eu writes:
On Tue, 22 Feb 2011 20:20:39 -0500, Tom Lane wrote:
... But my question isn't about that; it's about
why aclitem should be considered a first-class citizen. It makes me
Hi,
Actaully one more POD left it's aclitem :). In Java for e.g. it is used to
obtain column priviliges, I assume some folks may want to use it too.
I tested only recv :-(
Acually I don't know if idea of such format is OK, but my intention was to
send roles names, so driver don't need to ask
Just patch for missing procedures for void send/recv
Regards,
Radek
diff --git a/src/backend/utils/adt/pseudotypes.c b/src/backend/utils/adt/pseudotypes.c
index d9329f8..614eb98 100644
--- a/src/backend/utils/adt/pseudotypes.c
+++ b/src/backend/utils/adt/pseudotypes.c
@@ -212,7 +212,20 @@
Actually difference is
http://archives.postgresql.org/pgsql-hackers/2011-02/msg00415.php
Merlin Moncure mmonc...@gmail.com Thursday 10 February 2011 08:48:26
On Sat, Feb 5, 2011 at 4:59 PM, Radosław Smogura
rsmog...@softperience.eu wrote:
Hi,
I do performance tests against orignal JDBC
Just from curious may I ask in which direction this will go, and how this will
affect performance of text and binary format?
Actually I started to make smaller improvements, and I think about one big to
encode text (when client and server encoding are different) directly to
StringInfo, without
Hi,
I'm sending small patch for textsend. It reduces unnecessary copies, and
memory usage for duplication of varlena data. May you look?
Kind regards,
Radosław Smogura
diff --git a/src/backend/utils/adt/varlena.c b/src/backend/utils/adt/varlena.c
index e111d26..f24bbcd 100644
--- a/src/backend
Hi,
I do performance tests against orignal JDBC driver and my version in binary
and in text mode. I saw strange results when I was reading varchar values.
Here is some output from simple benchmark
Plain strings speed Execution: 8316582, local: 2116608, all:
10433190
Binary
On Thu, 16 Dec 2010 14:24:27 -0500, Tom Lane t...@sss.pgh.pa.us wrote:
=?utf-8?q?Rados=C5=82aw_Smogura?= rsmog...@softperience.eu writes:
Tom Lane t...@sss.pgh.pa.us Thursday 16 December 2010 18:59:56
=?utf-8?q?Rados=C5=82aw_Smogura?= rsmog...@softperience.eu
writes:
... This timestamp must
to send TIMESTAMPS WITH(OUT) TZ as UNSPECIFIED?
Simillar should go for (ugly) time with timezone.
//Ofc, excelent behaviour will be if I could send values always with TZ and
//leave _proper_ casting to backend.
Kind regards,
Radosław Smogura
http://www.softperience.eu
--
Sent via pgsql-hackers
local time with two bytes of client tz as OID unspecified.
One more instead of pq_copymsgbtes better will be tzOffset = pq_getint(buf,
sizeof(int16));
Kind regards,
Radosław Smogura
http://www.softperience.eu
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes
/pgjdbc_exp_20101130_C.tar.gz
Resolving www.rsmogura.net... 64.120.14.83
Connecting to www.rsmogura.net|64.120.14.83|:80... connected.
HTTP request sent, awaiting response... 404 Not Found
2010-12-01 12:05:29 ERROR 404: Not Found.
On Tue, Nov 30, 2010 at 7:49 PM, Radosław Smogura m...@smogura.eu
On Wed, 1 Dec 2010 12:47:13 +0100, Magnus Hagander mag...@hagander.net
wrote:
On Tue, Nov 30, 2010 at 19:49, Radosław Smogura m...@smogura.eu wrote:
Hello,
Maybe you are interested about this what I done with JDBC
snip
Driver is here
http://www.rsmogura.net/pgsql
--
Radosław Smogura
http://www.softperience.eu
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
--
--
Radosław Smogura
http://www.softperience.eu
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Blvd., Suite 215
Foster City, CA 94404
(650) 242-3500 Main
www.truviso.com
--
--
Radosław Smogura
http://www.softperience.eu
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
set to 0, but 1.
Kind regards,
Radosław Smogura
On Thu, 25 Nov 2010 12:23:03 -0500, Tom Lane t...@sss.pgh.pa.us wrote:
AFAICS this isn't a bug. What you're issuing Describe against is the
prepared statement, not the portal. The result column formats are not
specified by a prepared statement
.
In this situation I need to test portals as well.
---
Maciek Sakrejda | System Architect | Truviso
1065 E. Hillsdale Blvd., Suite 215
Foster City, CA 94404
(650) 242-3500 Main
www.truviso.com
--
--
Radosław Smogura
http://www.softperience.eu
--
Sent via pgsql-hackers mailing list
| System Architect | Truviso
1065 E. Hillsdale Blvd., Suite 215
Foster City, CA 94404
(650) 242-3500 Main
www.truviso.com
--
--
Radosław Smogura
http://www.softperience.eu
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription
results are handled.
Kind regards,
Radosław Smogura
On Fri, 26 Nov 2010 01:02:25 -0500, Tom Lane t...@sss.pgh.pa.us wrote:
Maciek Sakrejda msakre...@truviso.com writes:
21:43:02.264 (26) FE= Describe(statement=S_1)
You're still doing the statement-flavor Describe. As Tom pointed out
I didn't described log correctly, 1st attached response is normal execution;
flags QUERY_SUPPRESS_BEGIN | QUERY_ONESHOT, 2nd is compiled statement
QUERY_SUPPRESS_BEGIN only.
Text format is marked as 0, binary format is 1.
The 1st shown execution (flags=17) is good, it tells that result is
Hi,
I work on implementing binary protocol, during test select ?::int has
been
executed few times to compile it to server prepared statement, but after
this
backend returned field format = text, but sent field data in binary mode.
The parameter is long and is sent to in text mode, with oid 0,
Hello,
I last time added some features to JDBC driver meking in some way experimental
driver, it could be quite usefull, but if it's possible I would like to ask
for some reviews and tests. Maybe some ideas from this will be handly.
Beacause the chageset is huge, I don't give patch set, but
occurs with Hibernate, C3po, XA, and GFv3).
To summarize, you should never believe that RESET ALL will be called, nor
any other behavior when switching clients.
Am I right?
--
Radosław Smogura
http://www.softperience.eu
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org
.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
--
Radosław Smogura
http://www.softperience.eu
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
On Wed, 13 Oct 2010 21:01:06 -0400, Robert Haas robertmh...@gmail.com
wrote:
Is this a JDBC patch or a PG patch? Are we tracking JDBC patches
using the CF app?
It is JDBC patch. I will clean it and submit on this site. I didn't know
about such application and such process.
--
Radosław
Regarding JDBC in the CF process -- other interfaces are handled
there. I haven't seen one patch this size for JDBC since I've been
involved, let alone two competing patches to implement the same
feature. Small patches which can be quickly handled don't make sense
to put into the process,
facility of
PSQL server,
Would you like to update it?
I updated patch to latets CVS version, I didn't have time to remove some
trashes from it.
If something will be wrong with patch, give a feedback.
Kind regards,
Radosław Smogura
http://softperience.pl
statemnt_to_20101013.patch.gz
.
--
Radosław Smogura
http://www.softperience.eu
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
100 matches
Mail list logo