On Mon, 2009-09-14 at 09:16 +0900, Itagaki Takahiro wrote:
Another matter is that we use LOG level both cases of important
activity logging and mere performance or query logging. Maybe
we should have used another log level (PERFORMANCE?) for the
latter case, and its priority is less than
On Wed, 9 Sep 2009, decibel wrote:
What might be more useful is a view that takes the guesswork out of using
pg_depend. Namely, convert (ref)classid into a catalog table name (or better
yet, what type of object it is), (ref)objid into an actual object name, and
(ref)objsubid into a real name.
On Mon, Sep 14, 2009 at 02:16, Itagaki Takahiro
itagaki.takah...@oss.ntt.co.jp wrote:
Tom Lane t...@sss.pgh.pa.us wrote:
Itagaki Takahiro itagaki.takah...@oss.ntt.co.jp writes:
Can I reorder them to ERROR WARNING LOG ?
No. That was an intentional decision. LOG is for stuff that we
On Mon, Sep 14, 2009 at 02:43, Itagaki Takahiro
itagaki.takah...@oss.ntt.co.jp wrote:
Here is a patch to add a GUC parameter syslog_line_prefix.
It adds prefixes to syslog and eventlog. We still have
log_line_prefix, that will be used only for stderr logs.
We have a tip that log_line_prefix
On Mon, 2009-08-17 at 10:22 -0400, Tom Lane wrote:
As always with patches that are meant to improve performance,
some experimental evidence would be a good thing.
I haven't had time to performance test this patch yet, and it looks like
it will take a significant amount of effort to do so. I'm
On Sun, 2009-09-13 at 19:08 +1000, Brendan Jurd wrote:
The September CF starts in a couple of days, so this patch is in
danger of missing the boat.
Thanks for keeping track. I accomplished a significant amount today, so
there's still hope for 9/15.
I will most likely just focus on the core
Hello Robert,
2009/9/14 Robert Haas robertmh...@gmail.com:
On Mon, Aug 24, 2009 at 3:19 PM, Pavel Stehule pavel.steh...@gmail.com
wrote:
I reworked patch to respect mentioned issues. - this patch still
implement mixed notation - I am thing so this notation is really
important. All others I
A little bit of a reply to Jeff's email about WALInsertLock.
This patch instruments LWLocks, it is controlled with the following
#define's in lwlock.c :
LWLOCK_STATS
LWLOCK_TIMING_STATS
It is an upgrade of current lwlocks stats.
When active, at backend exit, it will display stats as shown
Itagaki Takahiro wrote:
We can choose different encodings from platform-dependent one
for database, but postgres writes serverlogs in the database encoding.
As the result, serverlogs are filled with broken characters.
The problem could occur on all platforms, however, there is a solution
I've done a little experiment with bulk inserts.
= heap_bulk_insert()
Behaves like heap_insert except it takes an array of tuples (HeapTuple
*tups, int ntups).
- Grabs a page (same as heap_insert)
- While holding exclusive lock, inserts as many tuples as it can on the
page.
-
On Mon, Sep 14, 2009 at 11:02 AM, Steve Prentice prent...@cisco.com wrote:
On Sep 13, 2009, at 10:22 PM, Pavel Stehule wrote:
2009/9/14 Tom Lane t...@sss.pgh.pa.us:
Robert Haas robertmh...@gmail.com writes:
So, I guess I'm sadly left feeling that we should probably reject this
patch.
Greg Smith wrote:
Putting on my DBA hat for a minute, the first question I see people
asking is how do I measure how far behind the slaves are?. Presumably
you can get that out of pg_controldata; my first question is whether
that's complete enough information? If not, what else should be
On Mon, Sep 14, 2009 at 11:56 AM, Pavel Stehule pavel.steh...@gmail.com wrote:
2009/9/14 Steve Prentice prent...@cisco.com:
On Sep 13, 2009, at 10:22 PM, Pavel Stehule wrote:
2009/9/14 Tom Lane t...@sss.pgh.pa.us:
Robert Haas robertmh...@gmail.com writes:
So, I guess I'm sadly left feeling
2009/9/14 Steve Prentice prent...@cisco.com:
On Sep 13, 2009, at 10:22 PM, Pavel Stehule wrote:
2009/9/14 Tom Lane t...@sss.pgh.pa.us:
Robert Haas robertmh...@gmail.com writes:
So, I guess I'm sadly left feeling that we should probably reject this
patch. Anyone want to argue otherwise?
Greg Smith wrote:
This is looking really neat now, making async replication really solid
first before even trying to move on to sync is the right way to go
here IMHO.
I agree with both of those sentiments.
One question I have is what is the level of traffic involved between the
master and
On Sep 13, 2009, at 10:22 PM, Pavel Stehule wrote:
2009/9/14 Tom Lane t...@sss.pgh.pa.us:
Robert Haas robertmh...@gmail.com writes:
So, I guess I'm sadly left feeling that we should probably reject
this
patch. Anyone want to argue otherwise?
+1. I'm really hoping to get something done
Peter,
This is what the attached patch produces.
Comments?
This is how other project handle transation of these kinds of strings.
--
Josh Berkus
PostgreSQL Experts Inc.
www.pgexperts.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your
Greg Smith gsm...@gregsmith.com wrote:
Putting on my DBA hat for a minute, the first question I see people
asking is how do I measure how far behind the slaves are?.
Presumably you can get that out of pg_controldata; my first question
is whether that's complete enough information? If not,
2009/9/14 Pierre Frédéric Caillaud li...@peufeu.com
A little bit of a reply to Jeff's email about WALInsertLock.
This patch instruments LWLocks, it is controlled with the following
#define's in lwlock.c :
LWLOCK_STATS
LWLOCK_TIMING_STATS
It is an upgrade of current lwlocks stats.
Hi
So the question I would ask goes more like do you really need 32K
databases in one installation? Have you considered using schemas
instead? Databases are, by design, pretty heavyweight objects.
I agree, but at the same time, we might: a) update our documentation to
indicate it depends on
This is looking really neat now, making async replication really solid
first before even trying to move on to sync is the right way to go here
IMHO. I just cleaned up the docs on the Wiki page, when this patch is
closer to being committed I officially volunteer to do the same on the
internal
Martijn van Oosterhout klep...@svana.org wrote:
FWIW, I find the ability in Slony to configure triggers so they work
or not depending on the replication role to be extremely useful.
Absolutely a major positive feature.
Yeah, as a general rule it doesn't make sense to try to enforce
Scott Mohekey scott.mohe...@telogis.com wrote:
What is the relationship between Timestamp and TimestampTz?
TIMESTAMP WITHOUT TIME ZONE does not identify a moment in time without
first associating it with a time zone. When Daylight Saving Time
ends, the same TIMESTAMP WITHOUT TIME ZONE values
On Sep 14, 2009, at 12:13 AM, Pavel Stehule wrote:
2009/9/13 decibel deci...@decibel.org:
On Sep 12, 2009, at 5:54 PM, Andrew Dunstan wrote:
decibel wrote:
Speaking of concatenation...
Something I find sorely missing in plpgsql is the ability to put
variables inside of a string, ie:
Kevin Grittner wrote:
Greg Smith gsm...@gregsmith.com wrote:
I don't think running that program going to fly for a production
quality integrated replication setup though. The UI admins are
going to want would allow querying this easily via a standard
database query. Most monitoring systems
On 14 Sep 2009, at 06:04, Tom Lane wrote:
Looks like the clang guys still have some work to do.
Thanks Tom, reported to clang dev's .
meanwhile, since quite a lot stuff went in over weekend, and since
Yesterday, new report at:
Anyone knows what's the latest on that patch ?
To be honest, this was the thing that I was looking forward most in
8.5 ... (and probably not only me alone).
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
On Sep 14, 2009, at 1:36 AM, Greg Smith wrote:
CASE
WHEN c1.relkind='r' THEN 'table'
WHEN c1.relkind='i' THEN 'index'
WHEN c1.relkind='S' THEN 'sequence'
WHEN c1.relkind='v' THEN 'view'
WHEN c1.relkind='c' THEN 'composite'
WHEN c1.relkind='t' THEN 'TOAST'
ELSE '?'
2009/9/14 decibel deci...@decibel.org:
On Sep 14, 2009, at 12:13 AM, Pavel Stehule wrote:
2009/9/13 decibel deci...@decibel.org:
On Sep 12, 2009, at 5:54 PM, Andrew Dunstan wrote:
decibel wrote:
Speaking of concatenation...
Something I find sorely missing in plpgsql is the ability to
On Mon, Sep 14, 2009 at 1:42 PM, Pavel Stehule pavel.steh...@gmail.com wrote:
How is it any worse than what people can already do? Anyone who isn't aware
of the dangers of SQL injection has already screwed themselves. You're
basically arguing that they would put a variable inside of quotes, but
Heikki Linnakangas heikki.linnakan...@enterprisedb.com wrote:
Kevin Grittner wrote:
IMO, it would be best if the status could be sent via NOTIFY.
To where?
To registered listeners?
I guess I should have worded that as it would be best if a change is
replication status could be signaled
Fujii Masao wrote:
Here is the latest version of Streaming Replication (SR) patch.
The first thing that caught my eye is that I don't think replication
should be a real database. Rather, it should by a keyword in
pg_hba.conf, like the existing all, sameuser, samerole keywords
that you can put
2009/9/14 Merlin Moncure mmonc...@gmail.com:
On Mon, Sep 14, 2009 at 1:42 PM, Pavel Stehule pavel.steh...@gmail.com
wrote:
How is it any worse than what people can already do? Anyone who isn't aware
of the dangers of SQL injection has already screwed themselves. You're
basically arguing that
Grzegorz Jaskiewicz wrote:
Anyone knows what's the latest on that patch ?
To be honest, this was the thing that I was looking forward most in
8.5 ... (and probably not only me alone).
We are also interested in integrating our autopartitioning patch for
COPY with that implementation. I can help
On Thu, Sep 10, 2009 at 12:01 AM, Jaime Casanova
jcasa...@systemguards.com.ec wrote:
On Mon, Jul 6, 2009 at 10:00 AM, Heikki
Linnakangasheikki.linnakan...@enterprisedb.com wrote:
Could we
have a version of PQconnectdb() with an API more suited for setting the
params programmatically? The
Jaime Casanova wrote:
On Thu, Sep 10, 2009 at 12:01 AM, Jaime Casanova
jcasa...@systemguards.com.ec wrote:
On Mon, Jul 6, 2009 at 10:00 AM, Heikki
Linnakangasheikki.linnakan...@enterprisedb.com wrote:
Could we
have a version of PQconnectdb() with an API more suited for setting the
params
Greg Smith wrote:
On Fri, 11 Sep 2009, Emmanuel Cecchet wrote:
I guess the problem with extra or missing columns is to make sure
that you know exactly which data belongs to which column so that you
don't put data in the wrong columns which is likely to happen if this
is fully automated.
This looks good. Shoud I try to elaborate on that for the patch with
error logging and autopartitioning in COPY?
manu
Robert Haas wrote:
Here's a half-baked proof of concept for the above approach. This
probably needs more testing than I've given it, and I haven't
attempted to fix the psql
On Mon, Sep 14, 2009 at 1:34 PM, Andrew Chernow a...@esilo.com wrote:
Jaime Casanova wrote:
i extracted the functions to connect that Heikki put on psql in his
patch for determining client_encoding from client locale and put it in
libpq so i follow the PQconnectdbParams(* params[]) approach.
Jaime Casanova jcasa...@systemguards.com.ec writes:
i put the new function at the end of the exports.txt file, there's a
reason to renumber the exports to put it at the beginning with the
other PQconnectdb function?
Exports.txt numbers do not change. EVER.
regards,
Have you looked at the total execution time with and without the
LWLOCK_TIMING_STATS?
It didn't show any significant overhead on the little COPY test I made.
On selects, it probably does (just like EXPLAIN ANALYZE), but I didn't
test.
It is not meant to be always active, it's a #define,
On Mon, Sep 14, 2009 at 2:51 PM, Emmanuel Cecchet m...@asterdata.com wrote:
This looks good. Shoud I try to elaborate on that for the patch with error
logging and autopartitioning in COPY?
That make sense to me. You shouldn't need to do anything else in
gram.y; whatever you want to add should
Jaime Casanova wrote:
On Mon, Sep 14, 2009 at 1:34 PM, Andrew Chernow a...@esilo.com wrote:
Jaime Casanova wrote:
i extracted the functions to connect that Heikki put on psql in his
patch for determining client_encoding from client locale and put it in
libpq so i follow the PQconnectdbParams(*
Replying to myself...
Jeff suggested to build pages in local memory and insert them later in the
table. This is what's used in CLUSTER for instance, I believe.
It has some drawbacks though :
- To insert the tuples in indexes, the tuples need tids, but if you build
the page in local
Robert Haas wrote:
On Mon, Sep 14, 2009 at 2:51 PM, Emmanuel Cecchet m...@asterdata.com wrote:
This looks good. Shoud I try to elaborate on that for the patch with error
logging and autopartitioning in COPY?
That make sense to me. You shouldn't need to do anything else in
gram.y;
Josh Berkus wrote:
But if I understood Tom's suggestions correctly then his approach does
not solve this at all since every one of those users with CREATE TABLE
privileges would have to also set same DEFAULT PRIVILEGES and the dba
would have no say in the matter.
This latter approach
On Fri, Jul 10, 2009 at 4:06 PM, Josh Berkus j...@agliodbs.com wrote:
Gabrielle of PDXPUG volunteered that PUG to hold a code sprint in
coordination with a commitfest sometime soon. For that event, the PDXPUG
members would take on a dozen or so patches, compile and review them and
submit the
Emmanuel Cecchet wrote:
Greg Smith wrote:
On Fri, 11 Sep 2009, Emmanuel Cecchet wrote:
I guess the problem with extra or missing columns is to make sure
that you know exactly which data belongs to which column so that you
don't put data in the wrong columns which is likely to happen if
On Mon, 2009-09-14 at 20:24 +0900, Fujii Masao wrote:
The latest patch has overcome those problems:
Well done. I hope to look at it myself in a few days time.
--
Simon Riggs www.2ndQuadrant.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make
Hi Magnus,
On Mon, Sep 14, 2009 at 9:41 PM, Magnus Hagander mag...@hagander.net wrote:
First, the patch removes the logging_collector parameter and basically
assumes that logging_collector is always on.
Alvaro commited this a few days ago:
On Mon, Sep 14, 2009 at 21:56, Guillaume Smet guillaume.s...@gmail.com wrote:
Hi Magnus,
On Mon, Sep 14, 2009 at 9:41 PM, Magnus Hagander mag...@hagander.net wrote:
First, the patch removes the logging_collector parameter and basically
assumes that logging_collector is always on.
Alvaro
On Mon, Sep 14, 2009 at 3:25 PM, Emmanuel Cecchet m...@asterdata.com wrote:
Robert Haas wrote:
On Mon, Sep 14, 2009 at 2:51 PM, Emmanuel Cecchet m...@asterdata.com
wrote:
This looks good. Shoud I try to elaborate on that for the patch with
error
logging and autopartitioning in COPY?
Magnus Hagander mag...@hagander.net writes:
First, the patch removes the logging_collector parameter and basically
assumes that logging_collector is always on.
I don't find that to be a good idea, and you certainly have not made
a case why we should change it. I can't see any reason why
On Mon, Sep 14, 2009 at 1:55 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Jaime Casanova jcasa...@systemguards.com.ec writes:
i put the new function at the end of the exports.txt file, there's a
reason to renumber the exports to put it at the beginning with the
other PQconnectdb function?
On Mon, Sep 14, 2009 at 2:20 PM, Andrew Chernow a...@esilo.com wrote:
Jaime Casanova wrote:
On Mon, Sep 14, 2009 at 1:34 PM, Andrew Chernow a...@esilo.com wrote:
Jaime Casanova wrote:
i extracted the functions to connect that Heikki put on psql in his
patch for determining client_encoding
Robert Haas robertmh...@gmail.com writes:
On Mon, Sep 14, 2009 at 3:25 PM, Emmanuel Cecchet m...@asterdata.com wrote:
I have never looked at the psql code but that could be a good way to get
started on that. If you can point me at where to look at, I'll give it a
try.
I don't know either off
actually, Tom said: it's hard to be sure which way is
actually more convenient without having tried coding some likely
calling scenarios both ways.
Aahhh, correct you are Daniel son :)
??? don't understand you ???
From the movie karate kid; oopps, should be Daniel San. I was trying
to be
Jaime Casanova jcasa...@systemguards.com.ec writes:
On Mon, Sep 14, 2009 at 1:55 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Exports.txt numbers do not change. Â EVER.
i didn't find any info about it, not even in the sources... should we
document that we need to put some functions in that file and
On Mon, Sep 14, 2009 at 3:31 PM, Andrew Chernow a...@esilo.com wrote:
actually, Tom said: it's hard to be sure which way is
actually more convenient without having tried coding some likely
calling scenarios both ways.
Aahhh, correct you are Daniel son :)
??? don't understand you ???
From
On Sep 14, 2009, at 12:37 PM, gabrielle wrote:
All systems are go!
Date: Sept 15
Time: 6pm - 9pm PDT, which is GMT -7.
We have 6 attendees. Robert Haas is going to choose 4 patches for us.
Can somebody volunteer to hang out on IRC in case we have questions?
I might be able to make it. I
Petr,
It's not as easy to do the original idea of setting default privileges
for schema for all users with CREATE privilege on schema but it can
still be done, one just have to update default privileges every time
somebody is granted that privilege, and DBA can still have control over
it
Hackers,
I've just had a feature request from a client that we come up with a way
to enable JSON input into hstore. This would make hstore much more
useful for software developers.
First question: would this go in the language driver, libpq, or the
backend? Thoughts?
--
Josh Berkus
I think the issue is that we treat TIMESTAMP WITHOUT TIME ZONE as TIMESTAMP
at GMT. We then convert it to a users local timezone within application
code.
Scott Mohekey
Systems/Application Specialist – OnTrack – Telogis, Inc.
www.telogis.com www.telogis.co.nz
+1 949 625-4115 ext. 207 (USA) +64
On Sep 14, 2009, at 3:22 PM, Robert Haas wrote:
I might be able to make it. I expect to have the hstore patch to
review (I
reviewed it last fest).
It has not been resubmitted for this CommitFest.
He told me a few hours ago that he was working to get it done. Looks
like there's about 90
On Mon, Sep 14, 2009 at 4:41 PM, David E. Wheeler da...@kineticode.com wrote:
On Sep 14, 2009, at 12:37 PM, gabrielle wrote:
All systems are go!
Date: Sept 15
Time: 6pm - 9pm PDT, which is GMT -7.
We have 6 attendees. Robert Haas is going to choose 4 patches for us.
Can somebody
On Mon, Sep 14, 2009 at 03:14:57PM -0700, Josh Berkus wrote:
Hackers,
I've just had a feature request from a client that we come up with a
way to enable JSON input into hstore. This would make hstore much
more useful for software developers.
First question: would this go in the language
Latest hstore patch with provision for inplace upgrading.
--
Andrew (irc:RhodiumToad)
hstore-20090914.patch.gz
Description: hstore patch
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
David Fetter wrote:
On Mon, Sep 14, 2009 at 03:14:57PM -0700, Josh Berkus wrote:
Hackers,
I've just had a feature request from a client that we come up with a
way to enable JSON input into hstore. This would make hstore much
more useful for software developers.
First question: would
David Fetter da...@fetter.org writes:
On Mon, Sep 14, 2009 at 03:14:57PM -0700, Josh Berkus wrote:
I've just had a feature request from a client that we come up with a
way to enable JSON input into hstore. This would make hstore much
more useful for software developers.
First question:
On Sep 14, 2009, at 1:02 PM, Pavel Stehule wrote:
2009/9/14 Merlin Moncure mmonc...@gmail.com:
On Mon, Sep 14, 2009 at 1:42 PM, Pavel Stehule
pavel.steh...@gmail.com wrote:
How is it any worse than what people can already do? Anyone who
isn't aware
of the dangers of SQL injection has
On Mon, 2009-09-14 at 15:14 -0700, Josh Berkus wrote:
Hackers,
I've just had a feature request from a client that we come up with a way
to enable JSON input into hstore. This would make hstore much more
useful for software developers.
First question: would this go in the language driver,
On Sep 14, 2009, at 7:05 PM, Jeff Davis pg...@j-davis.com wrote:
On Mon, 2009-09-14 at 15:14 -0700, Josh Berkus wrote:
Hackers,
I've just had a feature request from a client that we come up with
a way
to enable JSON input into hstore. This would make hstore much more
useful for software
On Mon, Sep 14, 2009 at 6:25 PM, David E. Wheeler da...@kineticode.com wrote:
I don't necessarily try to assign people back to the same patches - I
think sometimes a fresh pair of eyes is useful. But I'm not dead set
on changing it up, either.
Yeah, but I *love* this patch! :-)
Fair enough.
On Sep 14, 2009, at 4:32 PM, Robert Haas wrote:
What's wrong with just using a variant of the type input function?
With
a parameterized insert, it doesn't seem like it's really placing
much of
a burden on the application.
Agreed, I was thinking the same thing.
And the type output
On Mon, Sep 14, 2009 at 7:42 PM, David E. Wheeler da...@kineticode.com wrote:
On Sep 14, 2009, at 4:32 PM, Robert Haas wrote:
What's wrong with just using a variant of the type input function? With
a parameterized insert, it doesn't seem like it's really placing much of
a burden on the
A trivial little fix for PostgreSQL-8.4.1.
Calling the libpq function PQencryptPassword(password, ) doesn't make
a lot of sense (empty string for username). But if you do, it results
in a 1-byte buffer overflow in pg_md5_encrypt(). (This is in
backend/libpq/md5.c, but it's client, not backend.)
David Fetter wrote:
On Mon, Sep 14, 2009 at 06:55:52PM -0400, Andrew Dunstan wrote:
David Fetter wrote:
On Mon, Sep 14, 2009 at 03:14:57PM -0700, Josh Berkus wrote:
Hackers,
I've just had a feature request from a client that we come up with
a way to enable JSON input into
ljb ljb1...@pobox.com writes:
Two possible suggested fixes to src/backend/libpq/md5.c, pg_md5_crypt():
1) Allocate crypt_buf to (passwd_len + 1 + salt_len)
2) Use memcpy(crypt_buf, passwd, passwd_len) not strcpy(crypt_buf, passwd).
I like fix #2 better, although fix #1 avoids a weirdness with
commitfest.postgresql.org is updated, please submit new patches at
https://commitfest.postgresql.org/action/commitfest_view/open
Initial reviewing assignments have been sent to -rrreviewers. If you
didn't get one due to an oversight on my part, please drop me a note!
Thanks,
...Robert
[P.S. I
Robert Haas robertmh...@gmail.com writes:
commitfest.postgresql.org is updated, please submit new patches at
https://commitfest.postgresql.org/action/commitfest_view/open
Anyone else finding that logging in at commitfest.postgresql.org fails?
I get
Internal Server Error
The server encountered
* Tom Lane (t...@sss.pgh.pa.us) wrote:
Robert Haas robertmh...@gmail.com writes:
commitfest.postgresql.org is updated, please submit new patches at
https://commitfest.postgresql.org/action/commitfest_view/open
Anyone else finding that logging in at commitfest.postgresql.org fails?
I get
On Mon, Sep 14, 2009 at 9:30 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Robert Haas robertmh...@gmail.com writes:
commitfest.postgresql.org is updated, please submit new patches at
https://commitfest.postgresql.org/action/commitfest_view/open
Anyone else finding that logging in at
2009/9/14 Pierre Frédéric Caillaud li...@peufeu.com
I've done a little experiment with bulk inserts.
= heap_bulk_insert()
Behaves like heap_insert except it takes an array of tuples (HeapTuple
*tups, int ntups).
- Grabs a page (same as heap_insert)
- While holding exclusive lock,
Robert Haas robertmh...@gmail.com writes:
Yep, we were just discussing on IRC. It seems wwwmaster.postgreql.org
is down (unpingable).
Looks like someone fixed it.
regards, tom lane
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes
2009/9/14 Pierre Frédéric Caillaud li...@peufeu.com
Replying to myself...
Jeff suggested to build pages in local memory and insert them later in the
table. This is what's used in CLUSTER for instance, I believe.
It has some drawbacks though :
- To insert the tuples in indexes, the tuples
On Mon, Sep 14, 2009 at 5:41 AM, Heikki Linnakangas
heikki.linnakan...@enterprisedb.com wrote:
Heikki Linnakangas wrote:
Tom Lane wrote:
It strikes me that in the cases where it wouldn't be necessary to
compute junk sort-key columns, it would be because we were scanning an
index that includes
[ probably time to move this thread to -hackers ]
There is some moderately interesting reading material in section
4.17.4 Domain constraints of SQL:2008. In particular, it appears to
me that the standard goes out of its way to NOT claim that every value
that is of a domain type satisfies the
Heikki Linnakangas heikki.linnakan...@enterprisedb.com wrote:
Can't we use MultiByteToWideChar() to convert directly to the required
encoding, avoiding the double conversion?
Here is an updated version of the patch.
I use direct conversion in pgwin32_toUTF16() if a corresponding codepage
is
Tom == Tom Lane t...@sss.pgh.pa.us writes:
Tom [ probably time to move this thread to -hackers ]
Tom There is some moderately interesting reading material in section
Tom 4.17.4 Domain constraints of SQL:2008. In particular, it
Tom appears to me that the standard goes out of its way to NOT
Hi,
On Tue, Sep 15, 2009 at 12:47 AM, Greg Smith gsm...@gregsmith.com wrote:
Putting on my DBA hat for a minute, the first question I see people asking
is how do I measure how far behind the slaves are?. Presumably you can
get that out of pg_controldata; my first question is whether that's
Hi,
On Tue, Sep 15, 2009 at 1:06 AM, Andrew Dunstan and...@dunslane.net wrote:
One question I have is what is the level of traffic involved between the
master and the slave. I know numbers of people have found the traffic
involved in shipping of log files to be a pain, and thus we get things
Magnus Hagander mag...@hagander.net wrote:
Second, data transfer from the backends is now in the form of
structured data, and the actual logging message is put together in the
syslogger
I'd like to have an opposite approach -- per-backend log files.
Syslogger and appending logs at only one
On mån, 2009-09-14 at 21:14 -0400, Robert Haas wrote:
[P.S. I learned my lesson - last CF the equivalent email said that the
CF was closed, which of course was not what I meant at all.]
Yeah, except is it just me or is this open terminology equally weird?
Isn't the 2009-09 fest the one that is
2009/9/15 decibel deci...@decibel.org:
On Sep 14, 2009, at 1:02 PM, Pavel Stehule wrote:
2009/9/14 Merlin Moncure mmonc...@gmail.com:
On Mon, Sep 14, 2009 at 1:42 PM, Pavel Stehule pavel.steh...@gmail.com
wrote:
How is it any worse than what people can already do? Anyone who isn't
aware
Stephen Frost wrote:
* Tom Lane (t...@sss.pgh.pa.us) wrote:
Robert Haas robertmh...@gmail.com writes:
commitfest.postgresql.org is updated, please submit new patches at
https://commitfest.postgresql.org/action/commitfest_view/open
Anyone else finding that logging in at
Tom Lane wrote:
Robert Haas robertmh...@gmail.com writes:
Yep, we were just discussing on IRC. It seems wwwmaster.postgreql.org
is down (unpingable).
Looks like someone fixed it.
Yeah we major network breakdown starting at ~02:29 CEST which got fixed
at ~04:00 CEST.
Stefan
--
Sent
On 15 sep 2009, at 07.21, Itagaki Takahiro itagaki.takah...@oss.ntt.co.jp
wrote:
Magnus Hagander mag...@hagander.net wrote:
Second, data transfer from the backends is now in the form of
structured data, and the actual logging message is put together in
the
syslogger
I'd like to have
97 matches
Mail list logo