Bruce Momjian wrote:
Just to summarize:
o Every tuple gets a heap ctid
o Only the root tuple gets an index entry
o We can easily remove dead tuples that aren't the root because
by definition, nothing points to them, including backends and
indexes
Zeugswetter Andreas ADI SD wrote:
I am still wondering about the easily here. Basically this
needs some kind of wal entry to be crash safe.
Else some later tx might reuse the slot:
- some update on page produces page image in wal
- slot removed
- slot reused and
On 2/15/07, Heikki Linnakangas [EMAIL PROTECTED] wrote:
Do we actually ever want to remove dead tuples from the middle of the
chain? If a tuple in the middle of the chain is dead, surely every tuple
before it in the chain is dead as well, and we want to remove them as
well. I'm thinking,
Bruce,
Let me answer to your question.
Question 1: How much faster is it ?
To answer to your question, I measured execution times of INSERT
operations on concurrent accesses on dual-core x 2 CPU (each 2.80GHz),
In the experiment, each client issues 5000 INSERT operations concurrently.
The
Tom,
In my experience, in last April, a BBWC solution did not accelerate
PostgreSQL well.
The device which I tried was i-ram by gigabyte
(http://techreport.com/reviews/2006q1/gigabyte-iram/index.x?pg=1 ).
The i-ram showed only a little performance improvement compared to
PostgreSQL with fsync to
Interesting problem, seems to be planer related:
select 1
from beitraege bei,
b_zuordnungen bz,
(select bei_id
from b_zuordnungen bz,
ben_zuordnungen z,
strukturelemente se
where se.id =
Tom Lane [EMAIL PROTECTED] writes:
Gregory Stark [EMAIL PROTECTED] writes:
1) Replace the VARATT_SIZEP macro with SET_VARLENA_LEN.
If we're going to do this then it's time to play the name game;
Least...fun...game...evar...
A first-cut proposal:
VARHDRSZsame as
Mario Weilguni wrote:
Interesting: remove any of the above where conditions solves the problem go
away, e.g. removing and bei.id=10157309.
Testet with 8.2.1 and 8.1.4, same effect on both systems. Because of the
large number of tables involved it's difficult to find a self contained
Thanks for the info. Is there a fix for 8.1 branch, the production system is
still 8.1.
Regards
Mario Weilguni
Am Donnerstag, 15. Februar 2007 16:25 schrieb Alvaro Herrera:
Mario Weilguni wrote:
Interesting: remove any of the above where conditions solves the problem
go away,
Gregory Stark [EMAIL PROTECTED] writes:
There's also VARATT_CDATA which I suppose I should rename to VARCDATA. I
may not even need it once I hit tuptoaster.c since that file works directly
with the structure members anyways.
I supposed we also rename VARATT_IS_{COMPRESSED,EXTERNAL,EXTENDED} ?
Mario Weilguni [EMAIL PROTECTED] writes:
ERROR: failed to build any 8-way joins
Could you provide a self-contained test case for this? You probably
don't need any data, just the table schemas.
I fixed a problem with a similar symptom a couple days ago, but that was
in logic that was new in
On Fri, Dec 29, 2006 at 05:30:48PM +0100, Magnus Hagander wrote:
On Tue, Dec 19, 2006 at 04:58:22PM +0100, Zeugswetter Andreas ADI SD wrote:
MinGW has fseeko64 and ftello64 with off64_t.
Maybe we need separate macros for MSVC and MinGW. Given the other
You
Hi Magnus-san.
Great!!
Although not tested yet, I seem to equip it with the tolerance to 32GB.?
P.S)
In Japan, there is a user who is employing 300GB of database on Windows2003.
I have received some problems other than this. however, this user does not permit
public presentation of the
Tom Lane [EMAIL PROTECTED] writes:
#define VARDATA_4B(PTR) ((PTR)-va_4byte.va_data)
#define VARDATA_2B(PTR) ((PTR)-va_2byte.va_data)
#define VARDATA_1B(PTR) ((PTR)-va_1byte.va_data)
I thought we had abandoned the 2-byte-header variant?
Hm, I don't
On Thu, Feb 15, 2007 at 10:42:49AM -0500, Tom Lane wrote:
#define VARDATA_4B(PTR) ((PTR)-va_4byte.va_data)
#define VARDATA_2B(PTR) ((PTR)-va_2byte.va_data)
#define VARDATA_1B(PTR) ((PTR)-va_1byte.va_data)
I thought we had abandoned the 2-byte-header
i want to add database backup to my program i developed in visual basic 6, of
course i can save the syntax for pg_dump in a batch file and call it inside vb6
via shell, but my problem is that the batch file executes but stops to prompt
for a password. how can i supply a password to it
Hi,
I'm trying to implement the add_one sample in the PG docs using VC++
(for purposes of debugging). After some pain (had to add the
dllexport declspec below), I am able to get the CREATE FUNCTION
command to recognize the library and function. However, the function
blows up. I am able to
Tom Dunstan wrote:
Tom Lane wrote:
As for actually adding it, grep for all references to ANYELEMENT and add
code accordingly; shouldn't be that hard. Note you'd need to add an
anyarray2 at the same time for things to keep working sanely.
The enum patch [1] does exactly this with an ANYENUM
On Feb 14, 11:26 am, [EMAIL PROTECTED] (Florian G. Pflug) wrote:
Neil Conway wrote:
On Wed, 2007-02-14 at 13:19 -0300, Alvaro Herrera wrote:
Probably stack allocation doesn't matter much, as I think that would be
unwinded by the longjmp call. I don't know a lot about C++, but if
there
oliver rombaoa wrote:
i want to add database backup to my program i developed in visual basic 6, of course i
can save the syntax for pg_dump in a batch file and call it inside vb6 via
shell, but my problem is that the batch file executes but stops to prompt for
a password. how can i supply a
oliver rombaoa wrote:
i want to add database backup to my program i developed in visual
basic 6, of course i can save the syntax for pg_dump in a batch file
and call it inside vb6 via shell, but my problem is that the batch
file executes but stops to prompt for a password. how can i supply a
Firstly, this is the wrong list; this one is to discuss the development
OF postgres, NOT with. You need novice or general.
Secondly: look for pgpass in the documentation
---(end of broadcast)---
TIP 5: don't forget to increase your free space
[EMAIL PROTECTED] wrote:
Digging into this, I find that the fcinfo struct being passed
to me as an address of 0x02 - that looks a little non-sensical to
me.
Perhaps you forgot PG_FUNCTION_INFO_V1().
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
On 2/13/07, Tom Lane [EMAIL PROTECTED] wrote:
I would suggest that the search path be added as an explicit parameter
to CREATE FUNCTION, with a default of the current setting. The main
reason for this is that it's going to be a real PITA for pg_dump if we
don't allow an explicit specification.
Tom Lane wrote:
Actually ... now that I re-read that remark, I think you may have done
the wrong things with ANYENUM. I think that ANYENUM may in fact be
closer to ANYARRAY than it is to ANYELEMENT, because ANYELEMENT pretty
nearly means anything at all whereas ANYARRAY identifies a subset of
Tom Dunstan [EMAIL PROTECTED] writes:
I do have b-tree (and hash) support for enums, so it sounds like I'll
have to hit the same spot. I've got what I thought was a reasonably
comprehensive test of all the enum features which passes make check, so
if there's a likely failure in that code
Come to think of it, we really do need some refactoring in
parse_coerce.c. I just realized what CVS HEAD's RI code
does with array types:
regression=# create table aa (f1 int[] primary key);
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index aa_pkey for
table aa
CREATE TABLE
Tom Lane wrote:
Come to think of it, we really do need some refactoring in
parse_coerce.c.
[snip]
I'm not very sure what a good refactoring would look like,
but I am sure that I don't want all their call sites having to
individually account for ANYfoo types. Any thoughts?
I was
On Thu, Feb 08, 2007 at 01:54:13PM -0500, Tom Lane wrote:
Peter Eisentraut [EMAIL PROTECTED] writes:
I'm honestly looking for some practical use of this. We have debated
other NOTICE messages over the years, but they at least tell you
something you can use after the command.
The
Merlin Moncure [EMAIL PROTECTED] writes:
yikes!
If you guys go through with forcing functions to attach to objects
when they are created, it will break almost every project I've ever
worked on :(. The schema/function combo fits into all kinds of de
facto partitioning strategies and
Joshua,
I revised. Now Sigres can be activated by setting sigres = on in
postgresql.conf.
You can download the version (0.1.2) from
http://sourceforge.jp/projects/sigres .
And, I attach the diff between PostgreSQL-8.2.1 and Sigres-0.1.2 to this
mail.
Thanks for your comments.
-- Hideyuki
Hi,
From: Magnus Hagander [EMAIL PROTECTED]
Subject: Re: [HACKERS] pg_restore fails with a custom backup file
Date: Thu, 15 Feb 2007 17:38:59 +0100
On Fri, Dec 29, 2006 at 05:30:48PM +0100, Magnus Hagander wrote:
On Tue, Dec 19, 2006 at 04:58:22PM +0100, Zeugswetter Andreas ADI SD wrote:
32 matches
Mail list logo