[EMAIL PROTECTED] writes:
> There will be one block/page/buffer allocated for table t1 and the
> values are inserted to that block. When a commit is issued after
> insert, the data is guranteed to be written to the datafile on the
> disk. Now when the couple of updates are done from 2 sessions o
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> As Tom stated it earlier, the ANALYZE slow down is far from being the
> only consequence. The planner will also have more work to do and
> that's the hard point IMHO.
>
> Without studying the impacts of this change on a large set of queries
>
Hi,
I have a doubt referring to following scenario:
create table t1 (id integer primary key,desc varchar(10));
I insert 4 values as below:
id val
---
1 one
2 two
3 three
4
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
Simon Riggs wrote:
>> One fairly obvious difficulty is how to pass the trigger any meaningful
>> information about what happened (or is about to happen). In the case of
>> TRUNCATE, pretty much everything you need to know is implicit in the
>>
Hi All,
I have wanted to create a reverse key index for some time now, and it
seems that an evening of reading and half a day of efforts finally paid off.
This is just a proof of concept, and sure, the bit-reversing technique can
use a native language's power for better results.
I started
On Feb 3, 2008 7:26 PM, Omar Bettin <[EMAIL PROTECTED]> wrote:
> Probably I am on the wrong place but for me NULL on numbers means 0 or ZERO.
> I know about standards...
>
NULL means unknown value, ZERO is a known value
--
regards,
Jaime Casanova
"Programming today is a race between software en
Probably I am on the wrong place but for me NULL on numbers means 0 or ZERO.
I know about standards...
but I think that integralism is somewhat wrong.
Omar
a programmer...
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ign
On Sun, 3 Feb 2008, Jeff Davis wrote:
I think what he means by "bitemporal" is what CJ Date, et al., refer to
as "fully temporal" (as opposed to semi-temporal), that is, dealing with
time intervals rather than time points.
I think fully temporal is a step of complexity above how some people us
On Sun, 2008-02-03 at 10:48 +, Heikki Linnakangas wrote:
> I don't know what "bitemporal" is all about, but to me, the
> pgsql-temporal approach is clearly the most flexible and attractive.
I think what he means by "bitemporal" is what CJ Date, et al., refer to
as "fully temporal" (as oppos
Oleg Bartunov wrote:
On Sat, 2 Feb 2008, Gurjeet Singh wrote:
Hi All,
I just noticed a minor bug in our search results. Searching for
is_insteadbool in 8.3 docs returns the following page:
http://www.postgresql.org/docs/8.3/static/catalog-pg-rewrite.html
is_instead is a column, and boo
When PostgreSQL 8.4 development opens, I would like to upgrade to Autoconf
2.61. This has been out for over a year now, and many developers will
probably find it to be available through their operating system distributor
already. If not, consider installing it sometime if you plan to modify th
Martijn van Oosterhout <[EMAIL PROTECTED]> writes:
> Now, postgres almost certainly will never change much of it so it's not
> a big deal, but it could if it wanted to and that what overcommit was
> designed for: banking on the fact that 99% of the time, that space
> isn't written to. Overcommit is
On Sat, 2008-02-02 at 17:38 -0500, Tom Lane wrote:
> David Fetter <[EMAIL PROTECTED]> writes:
> > On Sat, Feb 02, 2008 at 05:23:39PM -0500, Christopher Browne wrote:
> >> I think it would be nice to be able to have more "trigger hooks"
> >> relating to DDL changes, but I also think that will repres
"Martijn van Oosterhout" <[EMAIL PROTECTED]> writes:
> On Sat, Feb 02, 2008 at 09:49:05PM +0100, Florian G. Pflug wrote:
>> AFAICS, memory overcommit helps if a program creates 50mb of mosty
>> read-only data, and than forks 10 times, or if it maps a large amount of
>> memory but writes to that bl
Martijn van Oosterhout wrote:
On Sat, Feb 02, 2008 at 09:49:05PM +0100, Florian G. Pflug wrote:
AFAICS, memory overcommit helps if a program creates 50mb of mosty
read-only data, and than forks 10 times, or if it maps a large amount of
memory but writes to that block only sparsely. Since po
On Sat, Feb 02, 2008 at 09:49:05PM +0100, Florian G. Pflug wrote:
> AFAICS, memory overcommit helps if a program creates 50mb of mosty
> read-only data, and than forks 10 times, or if it maps a large amount of
> memory but writes to that block only sparsely. Since postgres does
> neither, a dedicat
Jeff Davis wrote:
On Fri, 2008-02-01 at 15:42 +, Luke Porter wrote:
All
Is there an interest in developing bitemporal functionality in
PostgreSQL
I am very interested in this topic, and I maintain the pgsql-temporal
project at:
http://pgfoundry.org/projects/temporal/
It's missing go
17 matches
Mail list logo
