Ah... It seems that a item is calculated its hash value, get the bucket
number from it and insert into that bucket "chain". The insertion has
nothing to do with partition number(but Alvaro says "which hash is
used depends on the partition number". I haven't really understood
this: how can we get a
"rancpine cui" <[EMAIL PROTECTED]> writes:
> So the method of calculating the bucket number can promise
> that all items in the bucket link list belong to ONE partition?
It's not that hard: the bucket number is some number of low-order bits
of the hash value, and the partition number is some small
2007/4/27, Alvaro Herrera <[EMAIL PROTECTED]>:
Which hash is used depends on the partition number.
So the method of calculating the bucket number can promise
that all items in the bucket link list belong to ONE partition?
[EMAIL PROTECTED] (Tom Lane) writes:
> Chris Browne <[EMAIL PROTECTED]> writes:
>> [EMAIL PROTECTED] (Bruce Momjian) writes:
>>> I have seen no one do peroformance testing of this, so it seems it
>>> will have to wait for 8.4.
>
>> I didn't have time...
>
>> (e.g. - we've got a case where dropping
On Apr 26, 2007, at 3:39 PM, Tom Lane wrote:
Jim Nasby <[EMAIL PROTECTED]> writes:
So what happens if a backend is running with full_page_writes = off,
someone edits postgresql.conf to turns it on and forgets to reload/
restart, and then we crash? You'll come up in recovery mode thinking
that f_
On Fri, 2007-04-27 at 10:37 -0400, Bruce Momjian wrote:
> I assume this is 8.4 material.
I think its a small enough, performance-only change to allow it at this
time. It will provide considerable additional benefit for Warm Standby
servers.
--
Simon Riggs
EnterpriseDB http://w
On Apr 25, 2007, at 6:18 AM, shieldy wrote:
Hi, I wanto joinin the developer group of postgresql。
But, I just donot know how to put the first step, as I installed
the postgresql, and also get the postgresql code. after that, I
also installed the cygwin on my computer( as my os is windows xp)
On Apr 27, 2007, at 12:35 PM, Gregory Stark wrote:
I have dropped a column (say column name is 'A') from the relation
R. By
setting the attisdropped as true in the pg_catalog.pg_attribute
table. But
the column is dropped locially not the physically. Can you please
tell me
when this column w
On Apr 27, 2007, at 4:58 AM, Greg Smith wrote:
On Thu, 26 Apr 2007, Zeugswetter Andreas ADI SD wrote:
I am not sure that shrinking per WAL record size (other than the full
page images), e.g. by only logging changed bytes and not whole
tuples,
would have a huge impact on OLTP tx/sec, since the
On Apr 27, 2007, at 12:44 AM, Tom Lane wrote:
Gregory Stark <[EMAIL PROTECTED]> writes:
I would like to suggest that we make psql default when in
interactive mode to
using AUTOCOMMIT=false and ON_ERROR_ROLLBACK=true.
That is *way* too big a behavioral change to make depend on
something as
So, please download and test if you are able and provide feedback
through the pgFoundry bug tracker - we want to iron out any problems as
soon as possible before release. Please note however:
- pl/java will not work yet - please do not try to activate it in template1.
- Slony and PostGIS are n
I wrote:
> The easiest answer I can think of at the moment is to run parse analysis
> for a DECLARE CURSOR and then throw away the result. To avoid this
> overhead in cases where it's useless, we could probably teach analyze.c
> to do it only if p_variableparams is true (which essentially would me
I've uploaded a preview release of the Windows installer for PostgreSQL
8.3 to http://pgfoundry.org/frs/?group_id=107.
This preview is intended to get some initial testing and feedback on the
new architecture that we intend to use for future installers. In a
nutshell, most of the bundled softw
Tom Lane wrote:
> I concur it's too regular to be a hardware issue. The VMware idea is
> a bit plausible though. If that's it, we ought to see failures of this
> ilk on all four animals sooner or later ...
I've run full disk scans in both Windows VMs, and forced an fsck of the
host just to be on
Chris Browne <[EMAIL PROTECTED]> writes:
> [EMAIL PROTECTED] (Bruce Momjian) writes:
>> I have seen no one do peroformance testing of this, so it seems it
>> will have to wait for 8.4.
> I didn't have time...
> (e.g. - we've got a case where dropping the threshold to ~900 bytes
> would give us a
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> rancpine cui escribió:
>> What does "hash chains" mean?
> Each "hash chain" is a different, separate, independent hash struct.
It's pretty much equivalent to "hash bucket" --- this comment says chain
because it's focusing on the physical representation
I assume this is 8.4 material.
---
Heikki Linnakangas wrote:
> Tom Lane wrote:
> > "Simon Riggs" <[EMAIL PROTECTED]> writes:
> >> As regards the zero_damaged_pages question, I raised that some time ago
> >> but we didn't arr
Simon Riggs wrote:
> On Thu, 2007-04-26 at 18:51 -0400, Bruce Momjian wrote:
> > Simon Riggs wrote:
> > > On Fri, 2007-03-09 at 11:47 -0500, Tom Lane wrote:
> > > > "Simon Riggs" <[EMAIL PROTECTED]> writes:
> > > > > On Fri, 2007-03-09 at 11:15 -0500, Tom Lane wrote:
> > > > >> It strikes me that a
Andrew Dunstan <[EMAIL PROTECTED]> writes:
> I think these two justify declaring the Windows port at EOL prior to
> 8.2. The others probably not so much. (Who cares if pg_regress is not a
> C program? Who besides developers uses it?)
The reason to care about it is that the lack of it guarantees
In summary, for a patch to be applied, someone has to understand the
patch and the subsystem it modifies. In the past, most complex patches
came from experienced developers, so even if no one but the author fully
understood the patch, we could rely on the author to some extent. With
new people d
Heikki Linnakangas wrote:
> Alvaro Herrera wrote:
> >Heikki Linnakangas wrote:
> >
> >>What we could have is the semantics of "Return a buffer, with either
> >>correct contents or completely zeroed out". It would act just like
> >>ReadBuffer if the buffer was already in memory, and zero out the p
Dave Page <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> Is this the same physical machine as narwhal?
> Yes, it is. It's an FC6 box running VMWare server, with a Win 2k3r2 VM
> and a Vista ultimate VM, both with mingw and msvc animals.
> I'm still not convinced it's a hardware problem - aside
[EMAIL PROTECTED] (Bruce Momjian) writes:
> I have seen no one do peroformance testing of this, so it seems it
> will have to wait for 8.4.
I didn't have time...
I'll see if I can find a decent place to document how to tweak the
threshold, as that seems like it could be worth doing in cases where
rancpine cui escribió:
> I've seen from the README that
> "The shared-memory hash tables for LOCKs and PROCLOCKs are organized
> so that different partitions use different hash chains, and thus there
> is no conflict in working with objects in different partitions."
> What does "hash chains" mea
-- Forwarded message --
From: rancpine cui <[EMAIL PROTECTED]>
Date: 2007-4-27 下午9:22
Subject: Re: [HACKERS] How does the partitioned lock manager works?
To: Heikki Linnakangas <[EMAIL PROTECTED]>
Thanks for your reply. :-)
I've seen from the README that
"The shared-memory hash ta
Alvaro Herrera wrote:
Heikki Linnakangas wrote:
What we could have is the semantics of "Return a buffer, with either
correct contents or completely zeroed out". It would act just like
ReadBuffer if the buffer was already in memory, and zero out the page
otherwise. That's a bit strange semanti
Heikki Linnakangas wrote:
> What we could have is the semantics of "Return a buffer, with either
> correct contents or completely zeroed out". It would act just like
> ReadBuffer if the buffer was already in memory, and zero out the page
> otherwise. That's a bit strange semantics to have, but
Now that we seem to have MSVC building working tolerably well, I think
we need a bit of cleanup. In particular, I think the config setup needs
to be more like the arguments we pass to the standard configure script.
This shouldn't be hard, but I think it should be done before we go to
beta, i
Magnus Hagander wrote:
On Fri, Apr 27, 2007 at 12:56:27PM +0200, Hans-Juergen Schoenig wrote:
shieldy wrote:
Hi, I wanto joinin the developer group of postgresql。
But, I just donot know how to put the first step, as I installed the
postgresql, and also get the postgresql code. after th
Andrew Dunstan wrote:
>
>
> Dave Page wrote:
>>
>> * The stats collector bug which prevented stats being collected
>> reliably, thus causing all the expected knock on effects (including
>> near-total failure of autovacuum). The 8.2 fix for this was dependent
>> on the redesign of the collector to
On Fri, Apr 27, 2007 at 12:56:27PM +0200, Hans-Juergen Schoenig wrote:
> shieldy wrote:
> > Hi, I wanto joinin the developer group of postgresql。
> > But, I just donot know how to put the first step, as I installed the
> > postgresql, and also get the postgresql code. after that, I also
> > instal
Dave Page wrote:
* The stats collector bug which prevented stats being collected
reliably, thus causing all the expected knock on effects (including
near-total failure of autovacuum). The 8.2 fix for this was dependent
on the redesign of the collector to remove the separate stats buffering
pro
"rupesh bajaj" <[EMAIL PROTECTED]> writes:
> Hi,
> I have dropped a column (say column name is 'A') from the relation R. By
> setting the attisdropped as true in the pg_catalog.pg_attribute table. But
> the column is dropped locially not the physically. Can you please tell me
> when this column wi
Tom Lane wrote:
"Simon Riggs" <[EMAIL PROTECTED]> writes:
As regards the zero_damaged_pages question, I raised that some time ago
but we didn't arrive at an explicit answer. All I would say is we can't
allow invalid pages in the buffer manager at any time, whatever options
we have requested, oth
Hi,
I have dropped a column (say column name is 'A') from the relation R. By
setting the attisdropped as true in the pg_catalog.pg_attribute table. But
the column is dropped locially not the physically. Can you please tell me
when this column will be physically also dropped. Is this column is
auto
On 4/25/07, Gustavo Tonini <[EMAIL PROTECTED]> wrote:
On 4/24/07, Marko Kreen <[EMAIL PROTECTED]> wrote:
> On 4/23/07, Heikki Linnakangas <[EMAIL PROTECTED]> wrote:
> > Oh, you're talking about distributing partitions across different nodes
> > and parallelizing queries. No, we don't do that toda
shieldy wrote:
> Hi, I wanto joinin the developer group of postgresql。
> But, I just donot know how to put the first step, as I installed the
> postgresql, and also get the postgresql code. after that, I also
> installed the cygwin on my computer( as my os is windows xp). but now
> I wonder what's
rancpine cui wrote:
When the lock manager's data structures were split into "partitions",
how many such data structures can one partition control?
The number of partitions is 16 (NUM_LOCK_PARTITIONS). The total size of
the lock hash table is max_locks_per_xact * (max_connections +
max_pre
This email applies ONLY to the native Windows port of PostgreSQL, not to
any other ports.
Version 8.0 was the first version of PostgreSQL that ran on Windows
natively. As most of you know, the porting work was a large and complex
task that spanned two development cycles and took a great deal of ef
Hi,
When the lock manager's data structures were split into "partitions",
how many such data structures can one partition control? Since we use
LOCKTAG's hash value to decide the partition which the lock should in, can
all locks be split into ONE partition?
Regards,
ranc.
On Thu, 2007-04-26 at 21:14 -0400, Bruce Momjian wrote:
> Simon Riggs wrote:
> > > That should go away entirely; to me the main point of the separate
> > > wal-writer process is to take over responsibility for not letting too
> > > many dirty wal buffers accumulate.
> >
> > Yes
> >
> >
> > I'll
On Thu, 2007-04-26 at 18:51 -0400, Bruce Momjian wrote:
> Simon Riggs wrote:
> > On Fri, 2007-03-09 at 11:47 -0500, Tom Lane wrote:
> > > "Simon Riggs" <[EMAIL PROTECTED]> writes:
> > > > On Fri, 2007-03-09 at 11:15 -0500, Tom Lane wrote:
> > > >> It strikes me that allowing archive_command to be c
Tom Lane wrote:
> Dave Page <[EMAIL PROTECTED]> writes:
>> I've been seeing this failure intermittently on Narwhal HEAD, and once
>> on 8.1. Other branches have been OK, as have other animals running on
>> the same physical box. Narwhal-HEAD is run more often than any other
>> builds however.
>
>
On Thu, Apr 26, 2007 at 10:29:47AM -0700, Mark Wong wrote:
> I applied it to REL8_2_STABLE/pgsql and ran 'run_build.pl --test
> --keepall REL8_2_STABLE'. Looks like it passed everything for me. :)
Thanks for this test. I just committed the changes to CVS.
Michael
--
Michael Meskes
Email: Michae
44 matches
Mail list logo
