There has been regular griping in this list about our dependence on SysV
shared memory, but not so much about SysV semaphores, even though the
latter cause their fair share of issues; as seen for example in
buildfarm member spoonbill's recent string of failures:
creating template1 database in
/ho
On 5/30/12 4:42 PM, Ants Aasma wrote:
I was thinking about what is the earliest time where we could set hint
bits. This would be just after the commit has been made visible.
Except that's only true when there are no other transactions running. That's
been one of the big sticking points about t
On 5/28/12 2:55 PM, Robert Haas wrote:
As far as CSV goes, I think the biggest deficiency is that there's a
mismatch between the way that log files are typically named (e.g. one
per day, or one per hour) and the way that a CSV foreign table is
created (you've got to point it at one particular fil
On Mon, Jun 04, 2012 at 06:26:04PM -0700, Jeff Davis wrote:
> I propose a special user-initiated loading mode at the table
> granularity. During this time, readers must ignore PD_ALL_VISIBLE,
> HEAP_XMIN_COMMITTED, and the visibility map entirely. However, writers
> may set all of those bits before
On Tue, Jun 5, 2012 at 10:25 AM, Bruce Momjian wrote:
> On Tue, Jun 05, 2012 at 10:21:14AM -0400, Tom Lane wrote:
>> Bruce Momjian writes:
>> > Is everyone ready for me to run pgindent? We are nearing the first
>> > commit-fest (June 15) and will have to branch the git tree soon.
>>
>> Also, we
On Wed, 2012-06-06 at 15:08 -0400, Robert Haas wrote:
> On Mon, Jun 4, 2012 at 9:26 PM, Jeff Davis wrote:
> > Thoughts?
>
> Simon already proposed a way of doing this that doesn't require
> explicit user action, which seems preferable to a method that does
> require explicit user action, even tho
On Wed, Jun 06, 2012 at 03:08:05PM -0400, Robert Haas wrote:
> On Mon, Jun 4, 2012 at 9:26 PM, Jeff Davis wrote:
> > Thoughts?
>
> Simon already proposed a way of doing this that doesn't require
> explicit user action, which seems preferable to a method that does
> require explicit user action, e
I wrote:
> Actually, it looks like there is an extremely simple way to handle this,
> which is to move the call of LogStandbySnapshot (which generates the WAL
> record in question) to before the checkpoint's REDO pointer is set, but
> after we have decided that we need a checkpoint.
On further con
On Thu, Jun 7, 2012 at 5:05 AM, Magnus Hagander wrote:
> On Wed, Jun 6, 2012 at 8:26 PM, Fujii Masao wrote:
>> On Tue, Jun 5, 2012 at 11:44 PM, Magnus Hagander wrote:
>>> On Tue, Jun 5, 2012 at 4:42 PM, Fujii Masao wrote:
On Tue, Jun 5, 2012 at 9:53 PM, Magnus Hagander
wrote:
>
On Wed, Jun 6, 2012 at 1:13 PM, Robert Haas wrote:
> On Wed, Jun 6, 2012 at 4:08 PM, Magnus Hagander wrote:
>> However, not throwing errors on the URL syntax should be considered a
>> bug, I think.
>
> +1.
+1
Here's a patch that just makes the thing an error. Of course we could
revert it if it
Robert Haas writes:
> rhaas=# create table pg_catalog.tom (a int);
> ERROR: permission denied to create "pg_catalog.tom"
> The offending error check is in heap_create(), and based on what
> you're saying here it seems like we should just rip it out.
Hmm. Yeah, it seems like the regular permiss
On Wed, Jun 6, 2012 at 4:39 PM, Tom Lane wrote:
> Robert Haas writes:
>> Right now, you can't directly create a relation (table, index,
>> composite type) in the pg_catalog schema, but you can create a
>> non-relation (function, domain, etc.) in the pg_catalog schema.
>
> Surely this is true only
Robert Haas writes:
> On Wed, Jun 6, 2012 at 4:24 PM, Tom Lane wrote:
>>> I felt (and still feel) that this was misguided.
>> Looking at it again, I'm inclined to agree. The behavior was entirely
>> correct up until somebody decided to emit a continuing stream of
>> XLOG_RUNNING_XACTS WAL recor
On Wed, 6 Jun 2012, Merlin Moncure wrote:
I think this is the expected result. In the single user case the
spinklock never spins and only has to make the cpu-locking cache
instructions once. can we see results @24 threads?
Here
https://docs.google.com/open?id=0B7koR68V2nM1NDJHLUhNSS0zbUk
*
Robert Haas writes:
> Right now, you can't directly create a relation (table, index,
> composite type) in the pg_catalog schema, but you can create a
> non-relation (function, domain, etc.) in the pg_catalog schema.
Surely this is true only for superusers. Superusers can do whatever
they want an
On Wed, Jun 6, 2012 at 4:24 PM, Tom Lane wrote:
>> I felt (and still feel) that this was misguided.
>
> Looking at it again, I'm inclined to agree. The behavior was entirely
> correct up until somebody decided to emit a continuing stream of
> XLOG_RUNNING_XACTS WAL records even when the system is
Robert Haas writes:
> On Wed, Jun 6, 2012 at 3:08 PM, Tom Lane wrote:
>> In commit 18fb9d8d21a28caddb72c7ffbdd7b96d52ff9724, Simon modified the
>> rule for when to skip checkpoints on the grounds that not enough
>> activity has happened since the last one.
> IIRC, the inspiration for the change
On Wed, Jun 6, 2012 at 2:53 PM, Sergey Koposov wrote:
> On Wed, 6 Jun 2012, Ants Aasma wrote:
>
>> On Wed, Jun 6, 2012 at 2:27 PM, Sergey Koposov
>> wrote:
>>>
>>> I've quickly tested your lockfree-getbuffer.patch patch with the test
>>> case
>>> you provided and I barely see any improvement (2%
On Wed, Jun 6, 2012 at 4:08 PM, Magnus Hagander wrote:
> However, not throwing errors on the URL syntax should be considered a
> bug, I think.
+1.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-hackers mailing list (pgsql-hackers@p
On Mon, Jun 04, 2012 at 02:09:44PM -0400, Tom Lane wrote:
> Greg Sabino Mullane writes:
> > We have a 8.3.18 system (yes, the same one from the previous
> > thread, finally upgraded!) that gave us this error yesterday:
>
> > ERROR: index "pg_class_oid_index" is not a btree
>
> That means you g
On Wed, Jun 6, 2012 at 6:58 PM, Daniel Farina wrote:
> On Wed, Jun 6, 2012 at 1:09 AM, Magnus Hagander wrote:
>> On Wed, Jun 6, 2012 at 4:38 AM, Daniel Farina wrote:
>>> On Tue, Jun 5, 2012 at 6:43 PM, Tom Lane wrote:
Daniel Farina writes:
>>> If that is the case, is there a convention we
On Wed, Jun 6, 2012 at 8:26 PM, Fujii Masao wrote:
> On Tue, Jun 5, 2012 at 11:44 PM, Magnus Hagander wrote:
>> On Tue, Jun 5, 2012 at 4:42 PM, Fujii Masao wrote:
>>> On Tue, Jun 5, 2012 at 9:53 PM, Magnus Hagander wrote:
Right now, pg_receivexlog sets:
replymsg
Excerpts from Robert Haas's message of mié jun 06 14:45:46 -0400 2012:
> On Sun, Jun 3, 2012 at 5:30 AM, Alastair Turner wrote:
> > A one-line change adds the SSL info on its own line like
> >
> > --
> > You are connected to database "scratch" as user "scratch" on host
> > "127.0.0.1" at port
On Wed, 6 Jun 2012, Ants Aasma wrote:
On Wed, Jun 6, 2012 at 2:27 PM, Sergey Koposov wrote:
I've quickly tested your lockfree-getbuffer.patch patch with the test case
you provided and I barely see any improvement (2% at max)
https://docs.google.com/open?id=0B7koR68V2nM1QVBxWGpZdW4wd0U
tested w
On Wed, Jun 6, 2012 at 3:08 PM, Tom Lane wrote:
> In commit 18fb9d8d21a28caddb72c7ffbdd7b96d52ff9724, Simon modified the
> rule for when to skip checkpoints on the grounds that not enough
> activity has happened since the last one. However, that commit left the
> comment block about it in a nonse
On Tuesday, May 29, 2012 08:42:43 PM Andres Freund wrote:
> Hi,
>
> On Monday, May 28, 2012 07:11:53 PM Tom Lane wrote:
> > Andres Freund writes:
> > > Does anybody have a better idea than to either call WalSndWakeup() at
> > > essentially the wrong places or calling it inside a critical section?
In commit 18fb9d8d21a28caddb72c7ffbdd7b96d52ff9724, Simon modified the
rule for when to skip checkpoints on the grounds that not enough
activity has happened since the last one. However, that commit left the
comment block about it in a nonsensical state:
* If this isn't a shutdown or forced c
On Mon, Jun 4, 2012 at 9:26 PM, Jeff Davis wrote:
> Thoughts?
Simon already proposed a way of doing this that doesn't require
explicit user action, which seems preferable to a method that does
require explicit user action, even though it's a little harder to
implement. His idea was to store the
On Wednesday, June 06, 2012 08:19:15 PM Robert Haas wrote:
> On Wed, Jun 6, 2012 at 1:46 PM, Andres Freund
wrote:
> > On a cursory lock it might just be a race condition in
> > vacuumlazy.c:lazy_scan_heap. If scan_all is set, which it has to be for
> > the warning to be visible, all_visible_accor
On Wed, Jun 6, 2012 at 2:27 PM, Sergey Koposov wrote:
> I've quickly tested your lockfree-getbuffer.patch patch with the test case
> you provided and I barely see any improvement (2% at max)
> https://docs.google.com/open?id=0B7koR68V2nM1QVBxWGpZdW4wd0U
> tested with 24 core (48 ht cores, Xeon E7-
On Tue, Jun 5, 2012 at 10:44 AM, Magnus Hagander wrote:
> On Tue, Jun 5, 2012 at 4:42 PM, Fujii Masao wrote:
>> On Tue, Jun 5, 2012 at 9:53 PM, Magnus Hagander wrote:
>>> Right now, pg_receivexlog sets:
>>> replymsg->write = InvalidXLogRecPtr;
>>> re
On Sun, Jun 3, 2012 at 5:30 AM, Alastair Turner wrote:
> A one-line change adds the SSL info on its own line like
>
> --
> You are connected to database "scratch" as user "scratch" on host
> "127.0.0.1" at port "5432".
> SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256)
> --
>
> Does
Right now, you can't directly create a relation (table, index,
composite type) in the pg_catalog schema, but you can create a
non-relation (function, domain, etc.) in the pg_catalog schema.
Furthermore, you can create a table in some other schema and then move
it into the pg_catalog schema using AL
On Tue, Jun 5, 2012 at 11:44 PM, Magnus Hagander wrote:
> On Tue, Jun 5, 2012 at 4:42 PM, Fujii Masao wrote:
>> On Tue, Jun 5, 2012 at 9:53 PM, Magnus Hagander wrote:
>>> Right now, pg_receivexlog sets:
>>> replymsg->write = InvalidXLogRecPtr;
>>> re
On Wed, Jun 6, 2012 at 1:46 PM, Andres Freund wrote:
> On a cursory lock it might just be a race condition in
> vacuumlazy.c:lazy_scan_heap. If scan_all is set, which it has to be for the
> warning to be visible, all_visible_according_to_vm is determined before we
> loop over all blocks. At the po
On Tue, Jun 5, 2012 at 11:42 PM, Magnus Hagander wrote:
> Works for me. We still need a (reworked) patch, though, right? We just
> move where the move between seconds and milliseconds happens?
Attached is the updated version of the patch.
> I definitely don't think we need subsecond granularity
On Wed, Jun 6, 2012 at 10:38 AM, Tom Lane wrote:
> Well, that's what I wanted to discuss before Honza starts coding.
> It's not obvious that there are any use-cases for more than two.
> It's also not clear whether there is any value in supporting run-time
> rather than build-time configuration of
On Tuesday, June 05, 2012 04:18:44 PM Tom Lane wrote:
> Andres Freund writes:
> > On Tuesday, June 05, 2012 03:32:08 PM Tom Lane wrote:
> >> I got this last night in a perfectly standard build of HEAD:
> >> + WARNING: page is not marked all-visible but visibility map bit is set
> >> in relation "
On Wed, Jun 6, 2012 at 1:09 AM, Magnus Hagander wrote:
> On Wed, Jun 6, 2012 at 4:38 AM, Daniel Farina wrote:
>> On Tue, Jun 5, 2012 at 6:43 PM, Tom Lane wrote:
>>> Daniel Farina writes:
>> If that is the case, is there a convention we can use to separate the
>> parts of the connection string (
On Wed, Jun 06, 2012 at 11:32:45AM -0400, Tom Lane wrote:
> I had forgotten that conversation, but it does seem like there is
> interest in this type of configuration. Can anybody confirm that
> dropping a socket into a chroot or jail would actually work, ie
> make it possible to connect from insi
Honza Horak writes:
> On 06/06/2012 04:50 PM, Andres Freund wrote:
>> On Wednesday, June 06, 2012 04:38:42 PM Tom Lane wrote:
>>> Florian Pflug writes:
If we're going to have this at all, we should go all the way and
support an arbitrary number of sockets.
>>> Well, that's what I wante
Alvaro Herrera writes:
> Excerpts from Tom Lane's message of mié jun 06 10:38:42 -0400 2012:
>> (BTW, we would probably just adopt the Debian solution if we were
>> sure there were no non-libpq clients out there; but we aren't.)
> Maybe this is a good time to make the /var/run socket location (D
On 06/06/2012 04:50 PM, Andres Freund wrote:
On Wednesday, June 06, 2012 04:38:42 PM Tom Lane wrote:
Florian Pflug writes:
If we're going to have this at all, we should go all the way and
support an arbitrary number of sockets.
Well, that's what I wanted to discuss before Honza starts codi
Excerpts from Tom Lane's message of mié jun 06 10:38:42 -0400 2012:
> Florian Pflug writes:
> > Couldn't you simply tell postgres to put it's socket in, say, /var/run, and
> > create a symlink to that socket in the global /tmp directory?
>
> FYI, this proposal emerged out of a discussion betwee
On Wednesday, June 06, 2012 04:38:42 PM Tom Lane wrote:
> Florian Pflug writes:
> > If we're going to have this at all, we should go all the way and
> > support an arbitrary number of sockets.
>
> Well, that's what I wanted to discuss before Honza starts coding.
> It's not obvious that there are
Florian Pflug writes:
> Couldn't you simply tell postgres to put it's socket in, say, /var/run, and
> create a symlink to that socket in the global /tmp directory?
FYI, this proposal emerged out of a discussion between Honza and
myself. "Use a symlink" was my first idea too, but on reflection
i
On Jun6, 2012, at 15:50 , Honza Horak wrote:
> before I ask the main question, just a little background for one issue we're
> currently having in Fedora 17:
>
> PrivateTmp is a systemd's feature, which allows to have private /tmp
> directory for services, which in turn means that such services a
Atri Sharma writes:
> Hi all,
> I am trying to build and store multiple tuples.The code is:
> ExecClearTuple(slot);
> /The code for fetching the data from which tuple will be formed../
> for(;x tuple =
> BuildTupleFromCStrings(TupleDescGetAttInMetadata(node->ss.ss_currentRelation->rd_att),
> va
Hi,
before I ask the main question, just a little background for one issue
we're currently having in Fedora 17:
PrivateTmp is a systemd's feature, which allows to have private /tmp
directory for services, which in turn means that such services aren't
able to access systems's /tmp directory.
On Wed, Jun 6, 2012 at 5:36 AM, Atri Sharma wrote:
> Hi all,
>
> I am trying to build and store multiple tuples.The code is:
>
> ExecClearTuple(slot);
>
> /The code for fetching the data from which tuple will be formed../
> for(;x tuple =
> BuildTupleFromCStrings(TupleDescGetAttInMetadata(node->s
Hi,
On Mon, 4 Jun 2012, Ants Aasma wrote:
On Mon, Jun 4, 2012 at 7:44 PM, Merlin Moncure wrote:
I tried to keep it simple at first to find an answer to the question
if it's even worth trying before expending large effort on it. If
anyone with a multisocket machine would chip in, I'd love to kno
FYI, I finally committed the code installing a signal handler in PostGIS,
using the pqsignal function:
https://trac.osgeo.org/postgis/changeset/9850
It is currently only used to interrupt GEOS calls, but the idea is that
it could eventually also be used to interrupt other library calls having
a
Hi all,
I am trying to build and store multiple tuples.The code is:
ExecClearTuple(slot);
/The code for fetching the data from which tuple will be formed../
for(;xss.ss_currentRelation->rd_att),
values);
ExecStoreTuple(tuple, slot, InvalidBuffer, false);
}
return (slot);
When I am including t
On Wed, Jun 6, 2012 at 4:38 AM, Daniel Farina wrote:
> On Tue, Jun 5, 2012 at 6:43 PM, Tom Lane wrote:
>> Daniel Farina writes:
> If that is the case, is there a convention we can use to separate the
> parts of the connection string (in both representations) into the
> parts sent to the server a
> -Original Message-
> From: Tom Lane [mailto:t...@sss.pgh.pa.us]
> Sent: Tuesday, June 05, 2012 9:22 PM
> To: mark
> Cc: 'pgsql-hackers'
> Subject: Re: [HACKERS] issue with smlar exension and gist index
> creation (9.2Beta1)
>
> "mark" writes:
> > I am playing around with 9.2Beta1 and
55 matches
Mail list logo
