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 replacement for
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 deal
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
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
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
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
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
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
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
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.
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 appear
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 have support for
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 to WAL,
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
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
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
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);
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
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
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 update_test
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 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.
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 select
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
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
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 (only
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
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 sort of branches
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 handled by an
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 time. Maybe LDFLAGS?
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 table
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
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 commandSET/ ever been issued for it in the
current session.
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
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 set
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 strike me as a
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
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
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 resources
for one
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
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 also
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
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
return
InvalidBuffer;
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.XLogReadBuffer:
* remove init;
*
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 resources
for one
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 aren't up to
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 the
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
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 writer
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
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-row compression
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 starting point, I
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 needs
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 extraordinarily
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
,
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. Thanks
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
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
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
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
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
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
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
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?
64 matches
Mail list logo
