"make check" produces the following regression.diffs:
*** ./expected/geometry.out Fri Oct 31 22:07:07 2003
--- ./results/geometry.out Thu Aug 26 00:51:46 2004
***
*** 117,123
| (5.1,34.5) | [(1,2),(3,4)] | (3,4)
| (-5,-12) | [(1,2),(3,
Added to TODO.
---
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > TODO entry?
>
> * Merge hardwired timezone names with the TZ database; allow either kind
> everywhere a TZ name is currently taken
> * all
Devrim GUNDUZ wrote:
>
> Hi,
>
> On Wed, 25 Aug 2004, Gaetano Mendola wrote:
>
>
>>>anyone succesfull create all the rpm for RH AS 2.1 ?
>>>
>>>I was able to do it using the srpms for RH9 but I did
>>>it with --define 'python 0'. Any idea on how to obtain also
>>>the postgresql-python.rpm ?
>>>
>>>
This new version contains, in addition to the previous version,
SwapShared(..) which allows you to swap a value in a variable.
sharedvar-040825.tgz
Description: application/unix-tar
---(end of broadcast)---
TIP 2: you can get off all lists at once w
Greg Stark <[EMAIL PROTECTED]> writes:
> I don't know the details, but with postgres's model wouldn't it be a simply
> matter of treating every tuple found as having been inserting or deleted
> without checking to see if the transaction id in the tuple is committed?
No. At least not if you want a
Neil,
> It's worth noting that I did a lot of work toward that goal (making the
> BufMgrLock more granular) earlier in 2004, but unfortunately wasn't able
> to get it finished before leaving for the summer. I can't guarantee that
> the approach I took was the right one, but if anyone's interested
Josh Berkus wrote:
I'll have to admit to having only a beginner's grasp of this stuff, but I do
believe that that was what the OSDL patch did. Jan also tried a simpler
patch, which didn't work either.Both Jan and Tom have expressed the
opinion that the only solution is to make the BufrMgrL
Dennis Bjorklund <[EMAIL PROTECTED]> writes:
> On 25 Aug 2004, Greg Stark wrote:
>
> > It's only allowed when the transaction is in READ UNCOMMITTED isolation level.
> > Something Postgres doesn't currently support. In fact I'm not aware of any SQL
> > database that supports it, though I'm sure t
On Wed, Aug 25, 2004 at 05:10:30PM -0400, Bruce Momjian wrote:
> Christopher Kings-Lynne wrote:
> > > OK, TODO updated:
> > >
> > > * Implement dirty reads or shared row locks and use them in RI triggers
> >
> > Can someone explain to me what a dirty read is and how it relates to RI
> > triggers
[EMAIL PROTECTED] wrote:
This is a first pass on a simple shared memory variable system for
PostgreSQL. I would appriciate anyone interested in this functionality to
rip it apart.
It basically adds this functionality:
SetShared('name', value);
GetSharedInt('name');
SetSharedText('name);
RemovedShar
"Hicham G. Elmongui" <[EMAIL PROTECTED]> writes:
> Is there an existing function that I can use to print the "HeapTuple" return
> value of "ExecScanHashBucket" in nodeHash.c?
printtup.c would be a good place to look ...
regards, tom lane
---(end of
> LockShared('name');
Hmmm, I thought about that, but it is *WAY* more complicated than it
looks. What if after a "Lock" the process crashes before it can call
"Unlock?" It is this problem that inspired the "add" and "sub" calls.
>
> [EMAIL PROTECTED] wrote:
>> This is a first pass on a simple
LockShared('name');
[EMAIL PROTECTED] wrote:
This is a first pass on a simple shared memory variable system for
PostgreSQL. I would appriciate anyone interested in this functionality to
rip it apart.
It basically adds this functionality:
SetShared('name', value);
GetSharedInt('name');
SetSharedText
Christopher Kings-Lynne wrote:
> > OK, TODO updated:
> >
> > * Implement dirty reads or shared row locks and use them in RI triggers
>
> Can someone explain to me what a dirty read is and how it relates to RI
> triggers?
Dirty read allows you to see uncommited rows. I think RI triggers need
it
This is a first pass on a simple shared memory variable system for
PostgreSQL. I would appriciate anyone interested in this functionality to
rip it apart.
It basically adds this functionality:
SetShared('name', value);
GetSharedInt('name');
SetSharedText('name);
RemovedShared('name');
I also add
Is there an existing function that I can use to print the "HeapTuple" return
value of "ExecScanHashBucket" in nodeHash.c?
Thanks,
--h
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Andrew Dunstan <[EMAIL PROTECTED]> writes:
> s/from/from and/
Done.
regards, tom lane
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do no
On 25 Aug 2004, Greg Stark wrote:
> It's only allowed when the transaction is in READ UNCOMMITTED isolation level.
> Something Postgres doesn't currently support. In fact I'm not aware of any SQL
> database that supports it, though I'm sure there's one somewhere.
Looks like mysql also supports it
Zane <[EMAIL PROTECTED]> writes:
> Different memory usage 7.4.3 vs 8.0.0beta1
> client does:
> begin
> bulk inserts into single table via PQexecParams (1.2 million records)
> commit
> under 7.4.3 memory usage is static
> under 8.0.0beta1 server used increasing memory untill depletion of vm/swap
s/from/from and/
cheers
andrew
Serguei A. Mokhov wrote:
Hello,
This comment in initdb.c::main():
char *pgdenv; /* PGDATA value got from sent to
* environment */
doesn't look very correct, not at least
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Wed, 25 Aug 2004, Gaetano Mendola wrote:
> anyone succesfull create all the rpm for RH AS 2.1 ?
>
> I was able to do it using the srpms for RH9 but I did
> it with --define 'python 0'. Any idea on how to obtain also
> the postgresql-python.r
Hi all,
anyone succesfull create all the rpm for RH AS 2.1 ?
I was able to do it using the srpms for RH9 but I did
it with --define 'python 0'. Any idea on how to obtain also
the postgresql-python.rpm ?
Without 'pyhton 0' this is the error:
checking for python... /usr/bin/python
checking Python ins
Manfred,
> What did you test exactly and could you explain a bit about the context
> switch storm?
PostgreSQL currently causes a CS storm (context switches > 100,000) on
multi-processor machines where you have a number of concurrent processes ( >
than the number of processors) accessing the sam
Hello,
This comment in initdb.c::main():
char *pgdenv; /* PGDATA value got from sent to
* environment */
doesn't look very correct, not at least from the English language
perspective.
--
Serguei
Josh Berkus wrote:
Gaetano,
I knew there was an evaluation on the futex vs spinlock,
and Josh Berkus on IRC told me that there was only a 20%
performance increase, is this increase to throw away ?
Before we get totally off track here
I evaluated futexes strictly as an attempt to solve
On Wed, Aug 25, 2004 at 07:07:23PM +0300, Daniel Kalchev wrote:
> Does such toll exist, that could dump data (records?) from the heap files
> given the table structure?
You may want to check pg_filedump (from http://sources.redhat.com/rhdb
IIRC).
(What happened to pg_fsck BTW?)
--
Alvaro Herr
>>>Tom Lane said:
> Daniel Kalchev <[EMAIL PROTECTED]> writes:
> > (found out 7.2.3 does not have pg_database)
>
> You think not?
Not as a file similar to pg_control. pg_database is indeed table in the system
catalog.
> > By the way, I had to copy over the 'new' files from pg_clog and pg_x
On 8/25/2004 1:32 AM, Greg Stark wrote:
A dirty read is a read that includes data that hasn't been committed yet. Or
as the SQL 92 standard puts it:
[...]
It could also be useful for referential integrity checks since, for example,
it would let you see if someone has deleted the referenced record b
28 matches
Mail list logo
