On Thursday 12 April 2007 00:56, you wrote:
> IIRC, cmake is a replacement for make, not for configure. Or did I miss
> something?
CMake also has configure functionality.
> And it would require rewriting all the unix makefiles in cmake format,
> and it was one of the major requirements for this u
All,
I would recommend the new semi-free version of SpecJAppserver, called
EAStress.http://www.spec.org/jAppServer2004/
--Josh
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
On Apr 2, 2007, at 12:40 PM, Joshua D. Drake wrote:
Should we announce? There is some web work etc.. to be done.
Is that work documented anywhere? Seems it would be a GoodThing if it
was...
--
Jim Nasby[EMAIL PROTECTED]
EnterpriseDB http://ent
On Thu, 12 Apr 2007, Jonah H. Harris wrote:
- JDBCBench (http://developer.mimer.com/features/feature_16.htm)
I wouldn't recommend this one unless you've got plenty of time to debug it
and validate the results. There are multiple errors in the random number
generation code, some other bugs I
On Mar 30, 2007, at 5:51 PM, Florian G. Pflug wrote:
In realitly, however, I feare that most people will just create a
script
that does 'echo "select pg_stop_backup | psql"' or something similar.
If they're a bit more carefull, they will enable ON_ERROR_STOP, and
check
the return value of pgs
On Apr 10, 2007, at 9:48 AM, Stephen Frost wrote:
Referenced by:
"loc_base_clin_loc_base_id_fkey" FOREIGN KEY (loc_base_id) BY
wdm_networx.loc_base_clin(loc_base_id)
/|
\/|\
Referenced column(s) in *this* table
Florian G. Pflug wrote:
Joshua D. Drake wrote:
Alexey Klyukin wrote:
Alvaro Herrera wrote:
But if you have a checked out tree, does it work to do an update after
the tree has been regenerated? As far as I know, the repo is generated
completely every few hours, so it wouldn't surprise me that
Joshua D. Drake wrote:
Alexey Klyukin wrote:
Alvaro Herrera wrote:
But if you have a checked out tree, does it work to do an update after
the tree has been regenerated? As far as I know, the repo is generated
completely every few hours, so it wouldn't surprise me that the checked
out copy is n
Hi,
Sorry, inline reply.
Zeugswetter Andreas ADI SD wrote:
Yup, this is a good summary.
You say you need to remove the optimization that avoids
the logging of a new tuple because the full page image exists.
I think we must already have the info in WAL which tuple inside the full
page image
On Thu, 2007-04-12 at 11:45 -0400, Alvaro Herrera wrote:
> This phrase is missing a verb:
> [...]
> I find this markup strange:
> [...]
> In ResetTempTableNamespace(void), shouldn't it be using myTempNamespace
> instead of the SysCache lookup?
All fair points: I've applied the attached patch. Than
I've written the following function definitions to extend
generate_series to support some temporal types (timestamptz, date and
time). Please include them if there's sufficient perceived need or
value.
-- timestamptz version
CREATE OR REPLACE FUNCTION generate_series
( start_ts timestamptz
, end_t
Gregory Stark <[EMAIL PROTECTED]> writes:
> "Tom Lane" <[EMAIL PROTECTED]> writes:
>> I would suggest that *all* of those TODOs are premature in the absence
>> of experimental evidence about the effect of varying the parameters.
> Isn't it obvious that the "right" value is going to depend extraord
"Tom Lane" <[EMAIL PROTECTED]> writes:
> I would suggest that *all* of those TODOs are premature in the absence
> of experimental evidence about the effect of varying the parameters.
> If we end up finding out that the existing settings are about right
> anyway across a range of test cases, who n
Hi Tom,
On 4/12/07 1:40 PM, "Tom Lane" <[EMAIL PROTECTED]> wrote:
> I would suggest that *all* of those TODOs are premature in the absence
> of experimental evidence about the effect of varying the parameters.
> If we end up finding out that the existing settings are about right
> anyway across a
"Luke Lonergan" <[EMAIL PROTECTED]> writes:
> On 4/12/07 9:24 AM, "Bruce Momjian" <[EMAIL PROTECTED]> wrote:
>> At this point I would be happy just to set the TOAST threshold to a
>> value defined as optimal, rather than as the most minimal use of TOAST
>> possible.
> I agree that's a good startin
Hi Bruce,
On 4/12/07 9:24 AM, "Bruce Momjian" <[EMAIL PROTECTED]> wrote:
> Luke Lonergan wrote:
>> Hi Bruce,
>>
>> How about these:
>>
>> - Allow specification of TOAST size threshold in bytes on a per column basis
>> - Enable storage of columns in separate TOAST tables
>> - Enable use of multi
"Jacky Leng" <[EMAIL PROTECTED]> writes:
> Then if we come to the path "log_invalid_page", can I say there must be sth
> wrong, and we should PANIC?
No; you forgot about full_page_writes = off.
regards, tom lane
---(end of broadcast)--
"Simon Riggs" <[EMAIL PROTECTED]> writes:
> transaction_guarantee.v11.patch
I can't help feeling that this is enormously overcomplicated.
The "DFC" in particular seems to not be worth its overhead. Why wouldn't
we simply track the newest commit record at all times, and then whenever
the wal wri
As the README for xlog says: There're two kinds of WAL records:
* WAL record that contains enough information to re-generate the entire
contents of a page;
during recovery of these records, blocks are read with:
buffer = XLogReadBuffer(reln, blkno, true);
so it can be sure that the block will be
Jim Nasby wrote:
> On Apr 11, 2007, at 6:23 PM, Jim Nasby wrote:
>> FWIW, you might want to put some safeguards in there so that you don't
>> try to inadvertently kill the backend that's running that function...
>> unfortunately I don't think there's a built-in function to tell you
>> the PID of th
On Thu, Apr 12, 2007 at 12:57:32PM -0400, Bruce Momjian wrote:
> Tom Lane wrote:
> > Kris Kennaway <[EMAIL PROTECTED]> writes:
> > > On Wed, Apr 11, 2007 at 01:03:50AM -0400, Tom Lane wrote:
> > >> Well, the thing is, we've pretty much had it handed to us that
> > >> current-command indicators that
Mark Kirkwood wrote:
> Kris Kennaway wrote:
> >If so, then your task is the following:
> >
> >Make SYSV semaphores less dumb about process wakeups. Currently
> >whenever the semaphore state changes, all processes sleeping on the
> >semaphore are woken, even if we only have released enough resource
Oh, I am wrong!
"Jacky Leng" <[EMAIL PROTECTED]> дÈëÓʼþ
news:[EMAIL PROTECTED]
>
> "Tom Lane" <[EMAIL PROTECTED]> дÈëÓʼþ
> news:[EMAIL PROTECTED]
> > "Jacky Leng" <[EMAIL PROTECTED]> writes:
> > > Cann't we remove this param?
> >
> > No.
> >
> > > We can rewrite like this:
> > > 1.XLogReadBuf
"Tom Lane" <[EMAIL PROTECTED]> дÈëÓʼþ
news:[EMAIL PROTECTED]
> "Jacky Leng" <[EMAIL PROTECTED]> writes:
> > Cann't we remove this param?
>
> No.
>
> > We can rewrite like this:
> > 1.XLogReadBuffer:
> > * remove init;
> > * everytime we cann't read a block, just "log_invalid_page" it, and
re
Hi,
As a part of my university project, I am trying to modify the postgres code
to support parallel system.
As the first step I have partitioned the data on different processors. And
have kept a master node to process all the query requests. Whenever my
master node is queried I need to push my
Tom Lane wrote:
> Kris Kennaway <[EMAIL PROTECTED]> forwards:
> > Yes but there are still a lot of wakeups to be avoided in the current
> > System V semaphore code. More specifically, not only do we wakeup all
> > the processes waiting on a single semaphore everytime something changes,
> > but we
I have this exact problem a lot. There are actually cases where you can
eliminate regular joins, not just left joins. For example:
CREATE TABLE partner (
id serial,
namevarchar(40) not null,
primary key (id)
);
CREATE TABLE projec
Mark Kirkwood wrote:
> Kris Kennaway wrote:
> >If so, then your task is the following:
> >
> >Make SYSV semaphores less dumb about process wakeups. Currently
> >whenever the semaphore state changes, all processes sleeping on the
> >semaphore are woken, even if we only have released enough resource
Alexey Klyukin wrote:
Alvaro Herrera wrote:
But if you have a checked out tree, does it work to do an update after
the tree has been regenerated? As far as I know, the repo is generated
completely every few hours, so it wouldn't surprise me that the checked
out copy is not compatible with the n
Alvaro Herrera wrote:
But if you have a checked out tree, does it work to do an update after
the tree has been regenerated? As far as I know, the repo is generated
completely every few hours, so it wouldn't surprise me that the checked
out copy is not compatible with the new repo.
I admit I hav
Tom Lane wrote:
> Kris Kennaway <[EMAIL PROTECTED]> writes:
> > On Wed, Apr 11, 2007 at 01:03:50AM -0400, Tom Lane wrote:
> >> Well, the thing is, we've pretty much had it handed to us that
> >> current-command indicators that aren't up to date are not very useful.
> >> So rate-limited updates stri
Luke Lonergan wrote:
> Hi Bruce,
>
> How about these:
>
> - Allow specification of TOAST size threshold in bytes on a per column basis
> - Enable storage of columns in separate TOAST tables
> - Enable use of multi-row compression method(s) for TOAST tables
At this point I would be happy just to
Jonah H. Harris wrote:
On 4/12/07, Ranjan Sahoo <[EMAIL PROTECTED]> wrote:
I am working on a project for testing the performance of Oracle,
EDB, and
postgres and looking for a OLTP benchmarking tool which can do the
benchmarking on all these databases. Can anyone please help me on this?
To
Neil Conway wrote:
> Log Message:
> ---
> RESET SESSION, plus related new DDL commands.
This phrase is missing a verb:
The default value is defined as the value that the parameter would
have had, if no SET ever been issued for it in the
current session.
/pgsql/do
Am Donnerstag, 12. April 2007 17:08 schrieb Gregory Stark:
> Unless there's a makefile variable that is included in both CFLAGS and
> LDFLAGS that the user could use instead? But then that wouldn't work on
> architectures where ld is used instead of gcc for linking.
Perhaps you should start by def
On Wed, 11 Apr 2007, Jim Nasby wrote:
> I agree with others that the way that query is constructed is a bit
> odd, but it does bring another optimization to mind: when doing an
> inner-join between a parent and child table when RI is defined
> between them, if the query only refers to the child ta
Tom Lane <[EMAIL PROTECTED]> writes:
> Gregory Stark <[EMAIL PROTECTED]> writes:
> > %.so: %.o
> > ! $(CC) -shared -o $@ $<
>
> > sqlmansect = 7
> > --- 11,16
> > endif
>
> > %.so: %.o
> > ! $(CC) $(CFLAGS) -shared -o $@ $<
>
> Surely CFLAGS should be irrelevant at link t
"Heikki Linnakangas" <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>
>> AFAICS, there are basically two ways we might try to approach this:
>>
>> Plan A: establish the rule that you mustn't try to clean up shared
>> memory state in a PG_CATCH block. Anything you need to do like that
>> has to be
Alexey Klyukin wrote:
> Hi,
>
> Florian G. Pflug wrote:
> > Hi
> >
> > I'm very excited that my project for implementing read-only queries
> > on PITR slaves was accepted for GSoC, and I'm now trying to work
> > out what tools I'll use for that job.
> >
> > I'd like to be able to create some sor
On 4/12/07, Ranjan Sahoo <[EMAIL PROTECTED]> wrote:
I am working on a project for testing the performance of Oracle, EDB, and
postgres and looking for a OLTP benchmarking tool which can do the
benchmarking on all these databases. Can anyone please help me on this?
To test all three, you'd ha
Hi,
Florian G. Pflug wrote:
> Hi
>
> I'm very excited that my project for implementing read-only queries
> on PITR slaves was accepted for GSoC, and I'm now trying to work
> out what tools I'll use for that job.
>
> I'd like to be able to create some sort of branches and tags for
> my own work (
NikhilS <[EMAIL PROTECTED]> writes:
> Yes this is fine, but in "select columnname from tablename" using column
> references of the other involved table is what I am objecting to.
You can object till you're blue in the face, but this behavior is not
changing because it's *required by spec*. Outer
Florian G. Pflug wrote:
Hi
I'm very excited that my project for implementing read-only queries
on PITR slaves was accepted for GSoC,
Congratulations.
and I'm now trying to work
out what tools I'll use for that job.
I'd like to be able to create some sort of branches and tags for
my own work
>
> I don't think so...the columns of update_test are visible to the
> scalar subquery...that way you can use fields from 'a'
> to filter the
> subquery...
> select a, (select y from supdate_test where x = a) from
> update_test;
>
>
> Yes this is fine, but in "se
Hi AllJ
I am working on a project for testing the performance of Oracle, EDB, and
postgres and looking for a OLTP benchmarking tool which can do the benchmarking
on all these databases. Can anyone please help me on this?
Thanks in advance to all for you kind co-operation.
Hi
I'm very excited that my project for implementing read-only queries
on PITR slaves was accepted for GSoC, and I'm now trying to work
out what tools I'll use for that job.
I'd like to be able to create some sort of branches and tags for
my own work (only inside my local repository of course).
Hi,
On 4/12/07, Merlin Moncure <[EMAIL PROTECTED]> wrote:
On 4/12/07, NikhilS <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Shouldn't the final command below cause a 'column "b" does not exist
error'?
>
> create table update_test (a int, b int);
> create table supdate_test(x int, y int);
> insert into u
On 4/12/07, Bruce Momjian <[EMAIL PROTECTED]> wrote:
Gurjeet Singh wrote:
> The interface etc. may not be beautiful, but it isn't ugly either!
It is
> a lot better than manually creating pg_index records and inserting them
into
> cache; we use index_create() API to create the index (build is
On Apr 11, 2007, at 6:23 PM, Jim Nasby wrote:
FWIW, you might want to put some safeguards in there so that you
don't try to inadvertently kill the backend that's running that
function... unfortunately I don't think there's a built-in function
to tell you the PID of the backend you're connect
On 4/12/07, NikhilS <[EMAIL PROTECTED]> wrote:
Hi,
Shouldn't the final command below cause a 'column "b" does not exist error'?
create table update_test (a int, b int);
create table supdate_test(x int, y int);
insert into update_test values (20, 30);
insert into supdate_test values (40, 50);
se
Hi,
Shouldn't the final command below cause a 'column "b" does not exist error'?
create table update_test (a int, b int);
create table supdate_test(x int, y int);
insert into update_test values (20, 30);
insert into supdate_test values (40, 50);
select a, (select b from supdate_test) from update
Tom Lane wrote:
2) if a SIGTERM happens to arrive while btbulkdelete is running,
the next CHECK_FOR_INTERRUPTS will do elog(FATAL), causing elog.c
to do proc_exit(0), leaving the vacuum still recorded as active in
the shared memory array maintained by _bt_start_vacuum/_bt_end_vacuum.
The PG_TRY b
src/include/pg_config.h.win32
/* Define to 1 if you have support for IPv6. */
// #define HAVE_IPV6 1
What do you think?
It's defined ni the msvc build script, see
http://archives.postgresql.org/pgsql-committers/2007-04/msg00148.php
It is a meaning with win32.mak. Then, It is the outside of th
> I don't fully understand what "transaction log" means. If it means
> "archived WAL", the current (8.2) code handle WAL as follows:
Probably we can define "transaction log" to be the part of WAL that is
not
full pages.
> 1) If full_page_writes=off, then no full page writes will be
> written
On Thu, Apr 12, 2007 at 05:14:06PM +0900, Hiroshi Saito wrote:
> Hi.
>
> From: "Dave Page" <[EMAIL PROTECTED]>
>
> >>So. Changes applied.
>
> Umm, I think that you should correspond here.
> It seems to have been left. I remember it.
>
> src/include/pg_config.h.win32
> /* Define to 1 if you hav
On Thu, Apr 12, 2007 at 10:58:26AM +0200, Peter Eisentraut wrote:
> Am Donnerstag, 12. April 2007 09:04 schrieb Magnus Hagander:
> > The point is still what happens when you distribute a binary built on a
> > system with ipv6 to a system that doesn't have it.
>
> I think the problem is that you ap
> Maybe odd, but simpler to optimize this way.
>
> Your idea would be also a very good optimization, there was
> already a discussion about that here:
> http://archives.postgresql.org/pgsql-performance/2006-01/msg00
> 151.php, but that time Tom refused it because it was too
> expensive and rare
Jim,
Maybe odd, but simpler to optimize this way.
Your idea would be also a very good optimization, there was already a
discussion about that here:
http://archives.postgresql.org/pgsql-performance/2006-01/msg00151.php, but
that time Tom refused it because it was too expensive and rare. Maybe now
Am Donnerstag, 12. April 2007 08:56 schrieb Magnus Hagander:
> IIRC, cmake is a replacement for make, not for configure. Or did I miss
> something?
CMake might be considered a replacement for Automake.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end
Am Donnerstag, 12. April 2007 09:04 schrieb Magnus Hagander:
> The point is still what happens when you distribute a binary built on a
> system with ipv6 to a system that doesn't have it.
I think the problem is that you appear to have an ambiguous and overly coarse
definition of a "system with ip
Hi.
From: "Dave Page" <[EMAIL PROTECTED]>
So. Changes applied.
Umm, I think that you should correspond here.
It seems to have been left. I remember it.
src/include/pg_config.h.win32
/* Define to 1 if you have support for IPv6. */
// #define HAVE_IPV6 1
What do you think?
Regards,
Hiroshi
On Sat, 2007-04-07 at 18:09, Tom Lane wrote:
> Awhile back Csaba Nagy <[EMAIL PROTECTED]> wrote:
> > Making cluster MVCC-safe will kill my back-door of clustering a hot
> > table while I run a full DB backup.
>
> Are we agreed that the TRUNCATE-based workaround shown here
> http://archives.postgre
Magnus Hagander wrote:
On Thu, Apr 12, 2007 at 12:24:58AM +0200, Peter Eisentraut wrote:
Magnus Hagander wrote:
(FWIW, I had ipv6 on my list of things to make happen, but I didn't
realise it would cause this issue on a machine with ipv6 on it, since
I don't have one)
The IPv6 support is finely
Dear PostgreSQL Contributors,
I seek help from designers, developers, testers,defect fixers,project
managers or playing any other key role in Free/Open Source software
development or maintenence
in carrying out a study on practices and problems of defect management in
various Free/Open Source
On Thu, Apr 12, 2007 at 12:24:58AM +0200, Peter Eisentraut wrote:
> Magnus Hagander wrote:
> > (FWIW, I had ipv6 on my list of things to make happen, but I didn't
> > realise it would cause this issue on a machine with ipv6 on it, since
> > I don't have one)
>
> The IPv6 support is finely tuned to
On Wed, Apr 11, 2007 at 11:06:12PM -0600, Warren Turkal wrote:
> On Wednesday 11 April 2007 12:24, Andrew Dunstan wrote:
> > If we could use configure for MSVC this would have Just Happened (tm). I
> > wonder how many other little bits we miss out on?
>
> CMake anyone?
IIRC, cmake is a replacemen
66 matches
Mail list logo
