On 02.06.2011 21:58, Alexey Klyukin wrote:
Hello,
We've recently come across the task of estimating the size of shared memory
required for PostgreSQL to start. This comes from the problem of validating
postgresql.conf files
(http://archives.postgresql.org/pgsql-hackers/2011-03/msg01831.php),
Hello, Andrew.
You wrote:
AC On 6/2/2011 11:02 AM, Alvaro Herrera wrote:
Excerpts from Andrew Chernow's message of jue jun 02 10:12:40 -0400 2011:
Andrew, why we have PQmakeEmptyPGresult, PQcopyResult,
PQsetResultAttrs, PQsetvalue and PQresultAlloc in this case? Of course
there's no big
On tor, 2011-06-02 at 22:58 -0500, Jim Nasby wrote:
I'm torn between whether the type should store the original time or
the original time converted to GMT. I believe you would have the most
accuracy if you stored the original time... but then indexing becomes
problematic. I don't know if this
On 03.06.2011 00:14, Kevin Grittner wrote:
Attached is a comments-only patch for this, along with one
correction to the comments you added and a couple other typos.
Ok, committed.
I'll submit a patch for the README-SSI file once I find a reference
I like to a paper describing what Dan's
Hackers,
WIP patch of fast GiST index build is attached. Code is dirty and comments
are lacking, but it works. Now it is ready for first benchmarks, which
should prove efficiency of selected technique. It's time to compare fast
GiST index build with repeat insert build on large enough datasets
Hello,
I'm reading the posts of pgsql-hackers through the news server
news.postgresql.org using Windows Mail on Windows Vista, to avoid receiving
many emails. I don't seem to be able to receive posts in June. All I could
download are before June. But I could receive messages in June of other
Thanks all for your ideas. Though wired, I reinstalled the Postgres and
tried again. This error message disappears. The parser now works good.
On 3 June 2011 01:13, Alvaro Herrera alvhe...@commandprompt.com wrote:
Excerpts from HuangQi's message of jue jun 02 11:17:21 -0400 2011:
Hi, thanks a
On 05/25/2011 03:07 PM, Peter Eisentraut wrote:
On ons, 2011-04-27 at 18:14 -0400, Noah Misch wrote:
Enthusiastic +1 for this concept. There's at least one rough edge: it fails if
you have another postmaster running on port 5432.
This has now been addressed: pg_upgrade accepts PGPORT
On Thu, Jun 2, 2011 at 5:34 PM, Thom Brown t...@linux.com wrote:
On 8 February 2011 03:50, Robert Haas robertmh...@gmail.com wrote:
On Thu, Feb 3, 2011 at 11:00 PM, Robert Haas robertmh...@gmail.com wrote:
On Fri, Jan 14, 2011 at 6:15 AM, Simon Riggs si...@2ndquadrant.com wrote:
Patch to
Robert Haas robertmh...@gmail.com wrote:
That's an improvement of about ~3.5x.
Outstanding!
I don't want to even peek at this until I've posted the two WIP SSI
patches (now both listed on the Open Items page), but will
definitely take a look after that.
-Kevin
--
Sent via pgsql-hackers
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 30-bit length? I like this much more,
Good :-)
(BTW while it'd be good to have longer-than-30 bit length words for
Noah Misch n...@leadboat.com writes:
On Fri, Jun 03, 2011 at 12:27:35AM -0400, Robert Haas wrote:
and we
treat the call as a request to smash bar to the underlying array type.
No, there's no need to do that. The domain is an array, not merely
something that can be coerced to an array.
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 30-bit length? I like this much more,
Good :-)
(BTW while it'd
Hi,
On Jun 2, 2011, at 10:22 PM, Noah Misch wrote:
Hi Alexey,
...
Is your interest in cheap varchar(N)-varchar(N+M) conversions specifically,
or
in some broader application of this facility?
Exactly varchar conversions.
Thanks for volunteering to review; that will be a big help.
I looked into $SUBJECT, which complains about this:
CREATE VIEW test_view AS VALUES (1), (2), (3) ORDER BY 1;
This dumps like so:
regression=# \d+ test_view
View public.test_view
Column | Type | Modifiers | Storage | Description
On Jun 2, 2011, at 10:49 PM, Tom Lane wrote:
Alexey Klyukin al...@commandprompt.com writes:
We've recently come across the task of estimating the size of shared memory
required for PostgreSQL to start.
...
- Try to actually allocate the shared memory in a way postmaster does this
On Fri, Jun 3, 2011 at 1:14 AM, Noah Misch n...@leadboat.com wrote:
No, there's no need to do that. The domain is an array, not merely
something
that can be coerced to an array. Therefore, it can be chosen as the
polymorphic
type directly. Indeed, all released versions do this.
Well, as
On Jun 3, 2011, at 10:11 AM, Alexey Klyukin wrote:
Is your interest in cheap varchar(N)-varchar(N+M) conversions specifically,
or
in some broader application of this facility?
Exactly varchar conversions.
Why limit it to varchar? Shouldn't we be able to do this for any varlena? The
only
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 remove/update. User may write triggers for this, but it is not
argument - BLOB type is popular, and it's simplicity of use
On Tue, May 31, 2011 at 12:25 PM, Leonardo Francalanci m_li...@yahoo.it wrote:
Well, I sort of assumed the design was OK, too, but the more we talk
about this WAL-logging stuff, the less convinced I am that I really
understand the problem. :-(
I see. In fact, I think nobody thought about
On Fri, Jun 3, 2011 at 11:25 AM, Tom Lane t...@sss.pgh.pa.us wrote:
I looked into $SUBJECT, which complains about this:
CREATE VIEW test_view AS VALUES (1), (2), (3) ORDER BY 1;
This dumps like so:
regression=# \d+ test_view
View public.test_view
Column | Type |
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 remove/update. User may write triggers for this, but it is not
argument - BLOB
On Wed, May 25, 2011 at 5:28 AM, Emanuel Calvo postgres@gmail.com wrote:
Hi all,
I'm seeing the results of pg_basebackup and I saw postmaster.opts.
Is not necessary, although is inoffensive. But has the name of the
original cluster name inside. If it's only keep for information purposes,
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
Jim Nasby j...@nasby.net wrote:
The only challenge I see is numeric; we'd need to ensure that both
size and precision are not decreasing.
To be picky, wouldn't that need to be neither (precision - scale)
nor scale is decreasing?
-Kevin
--
Sent via pgsql-hackers mailing list
Robert Haas robertmh...@gmail.com writes:
On Fri, Jun 3, 2011 at 11:25 AM, Tom Lane t...@sss.pgh.pa.us wrote:
But anyway, there are basically two things we could do here: either
allow the table alias to be referenced, or try to teach ruleutils.c
not to qualify the column reference. The second
On Mon, May 23, 2011 at 8:50 PM, Aaron W. Swenson
aaron.w.swen...@gmail.com wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256
According to Linux Standard Base Core Specification 3.1 [1], the exit
status should be '3' when the server isn't running.
I've attached a very simple patch that
On Fri, Jun 3, 2011 at 12:13 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Robert Haas robertmh...@gmail.com writes:
On Fri, Jun 3, 2011 at 11:25 AM, Tom Lane t...@sss.pgh.pa.us wrote:
But anyway, there are basically two things we could do here: either
allow the table alias to be referenced, or try
On Fri, Jun 3, 2011 at 11:43 AM, Jim Nasby j...@nasby.net wrote:
On Jun 3, 2011, at 10:11 AM, Alexey Klyukin wrote:
Is your interest in cheap varchar(N)-varchar(N+M) conversions
specifically, or
in some broader application of this facility?
Exactly varchar conversions.
Why limit it to
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.
On Fri, Jun 03, 2011 at 10:43:17AM -0500, Jim Nasby wrote:
On Jun 3, 2011, at 10:11 AM, Alexey Klyukin wrote:
Is your interest in cheap varchar(N)-varchar(N+M) conversions
specifically, or
in some broader application of this facility?
Exactly varchar conversions.
Why limit it to
On Fri, Jun 03, 2011 at 11:22:34AM -0400, Robert Haas wrote:
On Fri, Jun 3, 2011 at 1:14 AM, Noah Misch n...@leadboat.com wrote:
No, there's no need to do that. The domain is an array, not merely
something
that can be coerced to an array. Therefore, it can be chosen as the
polymorphic
On Fri, Jun 3, 2011 at 10:13 AM, Kevin Grittner
kevin.gritt...@wicourts.gov wrote:
Robert Haas robertmh...@gmail.com wrote:
That's an improvement of about ~3.5x.
Outstanding!
I don't want to even peek at this until I've posted the two WIP SSI
patches (now both listed on the Open Items
On 2 June 2011 17:48, Alvaro Herrera alvhe...@commandprompt.com wrote:
Excerpts from Alvaro Herrera's message of mié jun 01 20:56:12 -0400 2011:
Excerpts from Thom Brown's message of mié jun 01 19:48:44 -0400 2011:
Is this expected?
[ pg_dump fails to preserve not-valid status of
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
Excerpts from Thom Brown's message of vie jun 03 12:47:58 -0400 2011:
On 2 June 2011 17:48, Alvaro Herrera alvhe...@commandprompt.com wrote:
Actually, it turns out that NOT VALID foreign keys were already buggy
here, and fixing them automatically fixes this case as well, because the
fix
On Jun 3, 2011, at 8:22 AM, Robert Haas wrote:
Well, as Bill Clinton once said, it depends on what the meaning of
the word 'is' is. I think of array types in PostgreSQL as meaning
the types whose monikers end in a pair of square brackets.
Man, range types are going to fuck with your brainz.
Excerpts from Robert Haas's message of vie jun 03 09:34:03 -0400 2011:
Just a note that since Alvaro created a patch to provide similar
functionality for constraints, I identified an issue with database
dumps, which apparently affects invalid foreign keys too:
Excerpts from Tom Lane's message of jue jun 02 15:49:53 -0400 2011:
Alexey Klyukin al...@commandprompt.com writes:
- Try to actually allocate the shared memory in a way postmaster does this
nowadays, if the process fails - analyze the error code to check whether
the
failure is due
On 03.06.2011 19:19, Radosław Smogura wrote:
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.
On 3 June 2011 17:58, Alvaro Herrera alvhe...@commandprompt.com wrote:
Excerpts from Thom Brown's message of vie jun 03 12:47:58 -0400 2011:
On 2 June 2011 17:48, Alvaro Herrera alvhe...@commandprompt.com wrote:
Actually, it turns out that NOT VALID foreign keys were already buggy
here, and
On Fri, Jun 03, 2011 at 10:42:01AM -0400, Tom Lane wrote:
Noah Misch n...@leadboat.com writes:
On Fri, Jun 03, 2011 at 12:27:35AM -0400, Robert Haas wrote:
and we
treat the call as a request to smash bar to the underlying array type.
No, there's no need to do that. The domain is an
According to our documentation, 'userlocks' were removed in PG 8.2:
http://developer.postgresql.org/pgdocs/postgres/runtime-config-developer.html
trace_userlocks (boolean)
If on, emit information about user lock usage. Output is the same as
for
On Fri, Jun 3, 2011 at 1:00 PM, David E. Wheeler da...@kineticode.com wrote:
On Jun 3, 2011, at 8:22 AM, Robert Haas wrote:
Well, as Bill Clinton once said, it depends on what the meaning of
the word 'is' is. I think of array types in PostgreSQL as meaning
the types whose monikers end in a
On 1 May 2011 I wrote:
Consider this a WIP patch
Just so people know where this stands...
By 8 May 2011 I had the attached. I didn't post it because I was
not confident I had placed the calls to the SSI functions for DROP
TABLE and TRUNCATE TABLE correctly. Then came PGCon and also the
On Fri, Jun 03, 2011 at 09:17:08AM -0400, Robert Haas wrote:
As you can see, this works out to a bit more than a 4% improvement on
this two-core box. I also got access (thanks to Nate Boley) to a
24-core box and ran the same test with scale factor 100 and
shared_buffers=8GB. Here are the
On Fri, Jun 3, 2011 at 12:04 PM, Heikki Linnakangas
heikki.linnakan...@enterprisedb.com wrote:
On 03.06.2011 19:19, Radosław Smogura wrote:
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
On Fri, Jun 3, 2011 at 1:01 PM, Bruce Momjian br...@momjian.us wrote:
According to our documentation, 'userlocks' were removed in PG 8.2:
http://developer.postgresql.org/pgdocs/postgres/runtime-config-developer.html
trace_userlocks (boolean)
If on, emit information
Robert Haas robertmh...@gmail.com writes:
The real crux of the issue here is: under what circumstances should we
look through the domain wrapper around an underlying type, and under
what circumstances should we refrain from doing so?
That's half of it. The other half is: when we *do* look
On 03.06.2011 21:04, Kevin Grittner wrote:
Also, if anyone has comments or hints about the placement of those
calls, I'd be happy to receive them.
heap_drop_with_catalog() schedules the relation for deletion at the end
of transaction, but it's still possible that the transaction aborts and
The external PID file, if configured, is currently generated with 600
permissions, which results from the umask setting in the postmaster. I
think it would be nicer if we could make that 644.
I have often dealt with scripts and such that look through PID files
in /var/run, and it's always
Robert Haas robertmh...@gmail.com wrote:
The real crux of the issue here is: under what circumstances
should we look through the domain wrapper around an underlying
type, and under what circumstances should we refrain from doing
so?
I don't know if this is the intent of domains in the SQL
BTW, a possibly relevant point here is that SQL:2008 says (in 4.12)
The purpose of a domain is to constrain the set of valid values
that can be stored in a column of a base table by various
operations.
and in 4.17.4
A domain constraint is a constraint that is
Kevin Grittner kevin.gritt...@wicourts.gov writes:
Another long-range nicety would be something which I have seen in
some other databases, and which is consistent with the inheritance
theme, is that you can't compare or assign dissimilar domains -- an
error is thrown. So if you try to join
Heikki Linnakangas heikki.linnakan...@enterprisedb.com wrote:
On 03.06.2011 21:04, Kevin Grittner wrote:
Also, if anyone has comments or hints about the placement of
those calls, I'd be happy to receive them.
heap_drop_with_catalog() schedules the relation for deletion at
the end of
Hello.
Reproduced under Windows XP SP3 using Visual C++ 2008 and Delphi. If
PQsetvalue is called with second parameter equals to PQntuples then
memory corruption appears. But it should grow internal tuples array
and populate the last item with provided data. Please see the code:
#include
Heikki Linnakangas wrote:
On 27.05.2011 16:52, Pavan Deolasee wrote:
On closer inspection, I realized that we have
deliberately put in this hook to ensure that we use visibility maps
only when we see at least SKIP_PAGES_THRESHOLD worth of all-visible
sequential pages to take advantage of
On tis, 2011-05-31 at 16:17 +1000, Brendan Jurd wrote:
Hi folks,
I was working on a little docs patch today, and when I tried to
`make`, openjade choked on an identifier in information_schema.sgml,
which is very much unrelated to my changes:
openjade:information_schema.sgml:828:60:Q:
Kevin Grittner kevin.gritt...@wicourts.gov writes:
Heikki Linnakangas heikki.linnakan...@enterprisedb.com wrote:
I think you'll need to just memorize the lock deletion command in
a backend-local list, and perform the deletion in a post-commit
function. Something similar to the PendingRelDelete
Tom Lane t...@sss.pgh.pa.us wrote:
A domain constraint is a constraint that is specified for a
domain.
It is applied to all columns that are based on that domain, and
to all values cast to that domain.
If you take that literally, it means that domain constraints are
applied
(1) in
On 6/3/2011 3:03 PM, Pavel Golub wrote:
Hello.
Reproduced under Windows XP SP3 using Visual C++ 2008 and Delphi. If
PQsetvalue is called with second parameter equals to PQntuples then
memory corruption appears. But it should grow internal tuples array
and populate the last item with provided
On Fri, Jun 3, 2011 at 2:03 PM, Pavel Golub pa...@microolap.com wrote:
Hello.
Reproduced under Windows XP SP3 using Visual C++ 2008 and Delphi. If
PQsetvalue is called with second parameter equals to PQntuples then
memory corruption appears. But it should grow internal tuples array
and
On mån, 2011-05-23 at 20:50 -0400, Aaron W. Swenson wrote:
According to Linux Standard Base Core Specification 3.1 [1], the exit
status should be '3' when the server isn't running.
I've attached a very simple patch that resolves this cosmetic issue,
which applies to all branches.
If we're
Tom Lane t...@sss.pgh.pa.us wrote:
Kevin Grittner kevin.gritt...@wicourts.gov writes:
Heikki Linnakangas heikki.linnakan...@enterprisedb.com wrote:
I think you'll need to just memorize the lock deletion command
in a backend-local list, and perform the deletion in a
post-commit function.
Josh Berkus wrote:
All,
Let me mention some of the reasons we as a project could use a bug
tracker which have nothing to do with actually fixing bugs.
(1) Testing: a bug tracker could be used for beta testing instead of the
ad-hoc system I'm writing. Assuming it has the right features,
Greg Stark wrote:
On Mon, May 30, 2011 at 6:52 PM, Robert Haas robertmh...@gmail.com wrote:
?The number of people reading and replying to
emails on pgsql-bugs is already insufficient, perhaps because of the
(incorrect) perception that Tom does or will fix everything and no one
else needs
Tom Lane wrote:
Peter Eisentraut pete...@gmx.net writes:
That doesn't mean that better integration cannot be worked on later, but
this illusion that a bug tracker must have magical total awareness of
the entire flow of information in the project from day one is an
illusion and has blocked
On Fri, Jun 3, 2011 at 3:06 PM, Andrew Chernow a...@esilo.com wrote:
On 6/3/2011 3:03 PM, Pavel Golub wrote:
Hello.
Reproduced under Windows XP SP3 using Visual C++ 2008 and Delphi. If
PQsetvalue is called with second parameter equals to PQntuples then
memory corruption appears. But it
On 6/3/2011 4:06 PM, Andrew Chernow wrote:
On 6/3/2011 3:03 PM, Pavel Golub wrote:
Hello.
Reproduced under Windows XP SP3 using Visual C++ 2008 and Delphi. If
PQsetvalue is called with second parameter equals to PQntuples then
memory corruption appears. But it should grow internal tuples array
Heikki Linnakangas heikki.linnakan...@enterprisedb.com wrote:
I think you'll need to just memorize the lock deletion command in
a backend-local list, and perform the deletion in a post-commit
function.
Hmm. As mentioned earlier in the thread, cleaning these up doesn't
actually have any
Just to throw out a crazy idea, there has been talk of bug ids. What if
a thread, made up of multiple message ids, was in fact the bug id, and
the first message in the thread (ignoring month boundaries) was the
definitive bug id, but any of the message ids could be used to represent
the
At first glance (have not tested this theory), looks like pqAddTuple()
doesn't zero the newly allocated tuples slots like PQsetvalue() does.
PQsetvalue is depending on the unassigned tuple table slots to be NULL to
detect when a tuple must be allocated. Around line 446 on fe-exec.c. I
never
On 03.06.2011 23:44, Kevin Grittner wrote:
Heikki Linnakangasheikki.linnakan...@enterprisedb.com wrote:
I think you'll need to just memorize the lock deletion command in
a backend-local list, and perform the deletion in a post-commit
function.
Hmm. As mentioned earlier in the thread,
Heikki Linnakangas heikki.linnakan...@enterprisedb.com wrote:
On 03.06.2011 23:44, Kevin Grittner wrote:
Hmm. As mentioned earlier in the thread, cleaning these up
doesn't actually have any benefit beyond freeing space in the
predicate locking collections. I'm not sure that benefit is
On fre, 2011-06-03 at 16:42 -0400, Bruce Momjian wrote:
Just to throw out a crazy idea, there has been talk of bug ids. What
if a thread, made up of multiple message ids, was in fact the bug id,
and the first message in the thread (ignoring month boundaries) was
the definitive bug id, but any
On Fri, Jun 3, 2011 at 8:42 PM, Bruce Momjian br...@momjian.us wrote:
Just to throw out a crazy idea, there has been talk of bug ids. What if
a thread, made up of multiple message ids, was in fact the bug id, and
the first message in the thread (ignoring month boundaries) was the
definitive
Hello Hackers,
There is some strange behavior we're experiencing with one of the customer's
DBs (8.4)
We've noticed that free disk space went down heavily on a system, and after a
short analysis determined that the reason was that postmaster was holding lots
of unlinked files open. A sample
On Fri, Jun 3, 2011 at 3:38 PM, Andrew Chernow a...@esilo.com wrote:
Eeekks. Found an additional bug. PQsetvalue only allocates the actual
tuple if the provided tup_num equals the number of tuples (append) and that
slot is NULL. This is wrong. The original idea behind PQsetvalue was you
Kevin Grittner kevin.gritt...@wicourts.gov wrote:
Tuple locks should be safe from that because we use the tuple xmin
as part of the target key, but page and heap locks
That should have read page and relation locks.
I guess that tips the scales in favor of it being worth the extra
code.
On 6/3/2011 5:54 PM, Merlin Moncure wrote:
On Fri, Jun 3, 2011 at 3:38 PM, Andrew Chernowa...@esilo.com wrote:
Eeekks. Found an additional bug. PQsetvalue only allocates the actual
tuple if the provided tup_num equals the number of tuples (append) and that
slot is NULL. This is wrong. The
Commit d2f60a3ab055fb61c8e1056a7c5652f1dec85e00 added an assert to indexam.c's
RELATION_CHECKS to block use of an index while it's being rebuilt. This
assert trips while rechecking an exclusion constraint after an ALTER TABLE
rebuild:
CREATE TABLE t (
c int,
and even wrap around completely. Since the row lock is ignored by nextval
and setval, the usefulness of the operation is highly debatable anyway.
As for pgpool, this is plain wrong. The reason why pgpool uses sequene
row lock is to obtain sequence table lock like effect, which is not
currently
On Fri, Jun 3, 2011 at 6:22 PM, Andrew Chernow a...@esilo.com wrote:
Actually, the original idea, as I stated UT, was to allow adding tuples in
any order as well as overwriting them. Obviously lost that while trying to
get libpqtypes working, which only appends.
Well, that may or not be the
On 6/3/11 11:01 AM, Bruce Momjian wrote:
According to our documentation, 'userlocks' were removed in PG 8.2:
http://developer.postgresql.org/pgdocs/postgres/runtime-config-developer.html
I take it this doesn't trace advisory locks, and trace_locks does?
If so, then by all means
Hackers,
Our next commitfest begins June 15. I will be CF manager for this one.
Currently we already have 40 patches in the queue.
If you already have code for a 9.2 feature, please get it in now. If
you submitted a patch for this CF, we'd really appreciate it if you
would volunteer to review
On 6/3/2011 7:14 PM, Merlin Moncure wrote:
On Fri, Jun 3, 2011 at 6:22 PM, Andrew Chernowa...@esilo.com wrote:
Actually, the original idea, as I stated UT, was to allow adding tuples in
any order as well as overwriting them. Obviously lost that while trying to
get libpqtypes working, which
Excerpts from Thom Brown's message of vie jun 03 13:45:57 -0400 2011:
On 3 June 2011 17:58, Alvaro Herrera alvhe...@commandprompt.com wrote:
Excerpts from Thom Brown's message of vie jun 03 12:47:58 -0400 2011:
Nice work Alvaro :) Shouldn't patches be sent to -hackers instead of
the
Excerpts from Alexander Shulgin's message of vie jun 03 17:45:28 -0400 2011:
There were about 450 such (or similar) files, all of them having /2613 in the
filename. Since 2613 is a regclass of pg_largeobject and we are indeed
working with quite a few large objects in that DB so this is
Josh Berkus wrote:
On 6/3/11 11:01 AM, Bruce Momjian wrote:
According to our documentation, 'userlocks' were removed in PG 8.2:
http://developer.postgresql.org/pgdocs/postgres/runtime-config-developer.html
I take it this doesn't trace advisory locks, and trace_locks does?
If
I disagree -- I think the fix is a one-liner. line 446:
if (tup_num == res-ntups !res-tuples[tup_num])
should just become
if (tup_num == res-ntups)
also the memset of the tuple slots when the slot array is expanded can
be removed. (in addition, the array tuple array expansion should
really be
On 6/3/2011 10:26 PM, Andrew Chernow wrote:
I disagree -- I think the fix is a one-liner. line 446:
if (tup_num == res-ntups !res-tuples[tup_num])
should just become
if (tup_num == res-ntups)
also the memset of the tuple slots when the slot array is expanded can
be removed. (in addition, the
91 matches
Mail list logo