Tom Lane wrote:
It is also pretty well established that if pltcl or plperl cause the
backend to become multithreaded, things break horribly. I strongly
Isn't that something that needs to be fixed? Its one thing not to allow
for multiple threads to
be in your code, but not having a threaded
Magnus Hagander wrote:
> Hi!
>
> When you redid the msvc build stuff you seem to have missed the
> documentatino.. Specifically, I notice that buildenv.pl isn't documented -
> docs still say buildenv.bat is the way to go.
>
> Also, do we now have both buildenv.bat and buildenv.pl? (I have them bo
Hi!
When you redid the msvc build stuff you seem to have missed the
documentatino.. Specifically, I notice that buildenv.pl isn't documented -
docs still say buildenv.bat is the way to go.
Also, do we now have both buildenv.bat and buildenv.pl? (I have them both
in my environment, but that could
Hi All,
I am trying to do a regression testing on the version
installed.
Now on the installed version of postgreSQL-8.2.4 with
the service started, and at the regress filder, I run
the command "gmake installcheck", when I run this
command I get the following message:
GNUmakefile:15: ../../../
On Fri, 2007-11-30 at 12:07 -0800, Jeff Davis wrote:
> On Tue, 2007-11-27 at 18:03 +, Simon Riggs wrote:
> > 5. DYNAMIC RUN HANDLING (in Final Merge)
> >
> > Another way of addressing a) is to simply make better use of memory
> > itself. Let's look at that in more detail:
> >
> > Number of r
Hello
What I have noticed is that when I don't use procedure
at all,there's only 2-5 locks in pg_locks,after I
start application which uses stored procedure the
number in pg_locks increase rapidly to steady 75 even
to 130 at certain moments.
Any clue why procedure usage might increase locks so
he
cinu wrote:
> GNUmakefile:15: ../../../src/Makefile.global: No such
> file or directory
> GNUmakefile:78: /src/Makefile.shlib: No such file or
> directory
> gmake: *** No rule to make target
> `/src/Makefile.shlib'. Stop.
You need to run "configure" first (found in the top-level directory), so
t
Hello
On 03/12/2007, Dragan Zubac <[EMAIL PROTECTED]> wrote:
> Hello
>
> What I have noticed is that when I don't use procedure
> at all,there's only 2-5 locks in pg_locks,after I
> start application which uses stored procedure the
> number in pg_locks increase rapidly to steady 75 even
> to 130 a
Magnus Hagander <[EMAIL PROTECTED]> writes:
> When you redid the msvc build stuff you seem to have missed the
> documentatino.. Specifically, I notice that buildenv.pl isn't documented -
> docs still say buildenv.bat is the way to go.
On a related note, I was wondering yesterday if there are any o
Did we ever come to a conclusion on what to do with integer datetimes on
msvc for 8.3?
For the uninformed - 8.2 and earlier had the binary build with floating
point timestamps, 8.3 has integer timestamps. (We're just talking the
binary build here)
//Magnus
---(end of broa
On Mon, Dec 03, 2007 at 10:52:15AM -0500, Tom Lane wrote:
> Magnus Hagander <[EMAIL PROTECTED]> writes:
> > When you redid the msvc build stuff you seem to have missed the
> > documentatino.. Specifically, I notice that buildenv.pl isn't documented -
> > docs still say buildenv.bat is the way to go
Magnus Hagander <[EMAIL PROTECTED]> writes:
> Did we ever come to a conclusion on what to do with integer datetimes on
> msvc for 8.3?
> For the uninformed - 8.2 and earlier had the binary build with floating
> point timestamps, 8.3 has integer timestamps. (We're just talking the
> binary build he
Hi,
I loaded pg8.3 beta 4 on a win2k3 64bit box (8GB ram). I was able to
restore a database into it (about 30GB,5schemas and about 2000 tables)
but whenever I try to open the tables in pgadmin3, the database crashes
(i've tried with both the default postgresql.conf file and with some
more tuned on
On Dec 3, 2007, at 11:27 , Tom Lane wrote:
I believe we have consensus that 8.4 is the time to do that --- see
thread here:
http://archives.postgresql.org/pgsql-patches/2007-05/msg00046.php
Is there anything in the release notes (or elsewhere) for 8.3 that
mention this as the intention, si
Andrew Dunstan wrote:
>
>
> Magnus Hagander wrote:
>> Did we ever come to a conclusion on what to do with integer datetimes on
>> msvc for 8.3?
>>
>> For the uninformed - 8.2 and earlier had the binary build with floating
>> point timestamps, 8.3 has integer timestamps. (We're just talking the
>>
Magnus Hagander wrote:
Did we ever come to a conclusion on what to do with integer datetimes on
msvc for 8.3?
For the uninformed - 8.2 and earlier had the binary build with floating
point timestamps, 8.3 has integer timestamps. (We're just talking the
binary build here)
If you are prepa
Filip Wuytack wrote:
Hi,
I loaded pg8.3 beta 4 on a win2k3 64bit box (8GB ram). I was able to
restore a database into it (about 30GB,5schemas and about 2000 tables)
but whenever I try to open the tables in pgadmin3, the database crashes
(i've tried with both the default postgresql.conf file an
From the postgresql ftp server. I initially wanted to download beta3,
but spotted beta4 so I gave that a go
ftp.postgresql.org
/pub/binary/v8.3beta4/win32/
~ Filip
-Original Message-
From: Andrew Dunstan [mailto:[EMAIL PROTECTED]
Sent: 03 December 2007 17:09
To: Filip Wuytack
Cc: pgsq
Magnus Hagander wrote:
> Andrew Dunstan wrote:
>>
>> Magnus Hagander wrote:
>>> Did we ever come to a conclusion on what to do with integer datetimes on
>>> msvc for 8.3?
>>>
>>> For the uninformed - 8.2 and earlier had the binary build with floating
>>> point timestamps, 8.3 has integer timestamps
Magnus Hagander wrote:
Hi!
When you redid the msvc build stuff you seem to have missed the
documentatino.. Specifically, I notice that buildenv.pl isn't documented -
docs still say buildenv.bat is the way to go.
Also, do we now have both buildenv.bat and buildenv.pl? (I have them both
in my e
Andrew,
As to how it was built: I was under the impression that the 8.3 release
is build using MSVSC?
I was keen to give it a try to see if this version would work more
optimally on windows as the pg instance (8.2.5) I run normally suffers
from serious high pages/sec (by looking at perfmon on wi
There's a suspicious ifdef in pg_standby for WIN32 which smells like a kludge
added to work around a Windows problem which makes it work but at great
expense:
#ifdef WIN32
/*
* Windows reports that the file has the right number of bytes
* even tho
On Mon, 2007-12-03 at 11:51 +, Simon Riggs wrote:
> So Algorithm F is somewhat orthogonal to what I've proposed, though
> maybe still interesting. What we do now is fairly close, but you should
> look at the code in tuplesort.c and logtape.c to see how well it
> matches. That might lead to an i
On Mon, 2007-12-03 at 12:15 -0500, Andrew Dunstan wrote:
>
> Magnus Hagander wrote:
> > Hi!
> >
> > When you redid the msvc build stuff you seem to have missed the
> > documentatino.. Specifically, I notice that buildenv.pl isn't documented -
> > docs still say buildenv.bat is the way to go.
> >
On Mon, 2007-12-03 at 10:32 -0800, Jeff Davis wrote:
> If I understand correctly, we just keep track of the maximum value of
> the last block read from each run, and then always read from the run in
> which the last block read has the lowest maximum.
Yep, sounds like Algorithm F
> It seems as if
Hi,
I tried to run make postgres.pdf (PostgreSQL 8.3beta4), and got this
error:
cp ./../graphics/postgres.gif .
cp: cannot stat `./../graphics/postgres.gif': No such file or directory
make: *** [postgres.gif] Error 1
CVS/tarball does not include this file, and I think we should add.
Regards,
--
"Simon Riggs" <[EMAIL PROTECTED]> writes:
> On Mon, 2007-12-03 at 10:32 -0800, Jeff Davis wrote:
>
>> If I understand correctly, we just keep track of the maximum value of
>> the last block read from each run, and then always read from the run in
>> which the last block read has the lowest maximu
On Mon, 3 Dec 2007, Devrim G?ND?Z wrote:
I tried to run make postgres.pdf (PostgreSQL 8.3beta4), and got this
error:
You need to say "make postgres-US.pdf" or -A4. The .gif file is coming
from make's default rules. Perhaps we should provide a real target
matching postgres.pdf and error
On Mon, 2007-12-03 at 20:40 +, Gregory Stark wrote:
> I think the way to do what you're proposing is...
Don't understand that. Algorithm F covers that already doesn't it?
> So the question is just how many seeks are we doing during sorting. If we're
> doing 0.1% seeks and 99.9% sequential i/
Devrim GÜNDÜZ wrote:
> Hi,
>
> I tried to run make postgres.pdf (PostgreSQL 8.3beta4), and got this
> error:
>
> cp ./../graphics/postgres.gif .
> cp: cannot stat `./../graphics/postgres.gif': No such file or directory
> make: *** [postgres.gif] Error 1
No, the reason for that error message is t
"Simon Riggs" <[EMAIL PROTECTED]> writes:
> The buffer size at max tapes is an optimum - a trade off between
> avoiding intermediate merging and merging efficiently. Freeing more
> memory is definitely going to help in the case of low work_mem and lots
> of runs.
I can't follow these abstract arg
On Mon, 2007-12-03 at 20:40 +, Gregory Stark wrote:
> So the question is just how many seeks are we doing during sorting. If we're
> doing 0.1% seeks and 99.9% sequential i/o then eliminating the 1% entirely
> (which we can't do) isn't going to speed up seeking all that much. If we're
> doing 2
Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= <[EMAIL PROTECTED]> writes:
> I got some SGML errors:
> https://devrim.privatepaste.com/501oMnwCYw
Hmph. What version of the SGML tools are you using? It seems more
prone to get confused by non-entity-ized '<' and '>' than what the
rest of us are using.
Hi,
On Mon, 2007-12-03 at 18:33 -0300, Alvaro Herrera wrote:
> No, the reason for that error message is that it is trying to generate
> postgres.pdf from postgres.gif. Try "make postgres-A4.pdf" or
> postgres-US.pdf instead.
Oh, thanks :)
I got some SGML errors:
https://devrim.privatepaste.com
On Mon, 2007-12-03 at 20:40 +, Gregory Stark wrote:
> I'm not sure where the idea of keeping the current bounds of the input tapes
> comes into it. We only preread when we run out of tuples anyways and then we
> don't really have a choice about which tape we want to preread from. And it's
> a g
Hi,
On Mon, 2007-12-03 at 17:49 -0500, Tom Lane wrote:
> > I got some SGML errors:
> > https://devrim.privatepaste.com/501oMnwCYw
>
> Hmph. What version of the SGML tools are you using?
The ones supplied with Fedora 8.
sgml-common: 0.6.3
openjada: 1.3.2
Regards,
--
Devrim GÜNDÜZ , RHCE
Pos
Andrew Dunstan <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> Hmph. What version of the SGML tools are you using? It seems more
>> prone to get confused by non-entity-ized '<' and '>' than what the
>> rest of us are using.
> I'm not totally au fait with the rules of SGML. Does it allow literal
Tom Lane wrote:
Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= <[EMAIL PROTECTED]> writes:
I got some SGML errors:
https://devrim.privatepaste.com/501oMnwCYw
Hmph. What version of the SGML tools are you using? It seems more
prone to get confused by non-entity-ized '<' and '>' than what the
res
Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= <[EMAIL PROTECTED]> writes:
> On Mon, 2007-12-03 at 17:49 -0500, Tom Lane wrote:
>> Hmph. What version of the SGML tools are you using?
> The ones supplied with Fedora 8.
> sgml-common: 0.6.3
> openjada: 1.3.2
Those are the same version numbers I see in Fedo
Hi,
On Mon, 2007-12-03 at 18:51 -0500, Tom Lane wrote:
> Those are the same version numbers I see in Fedora 6, which doesn't
> behave like that ... Anyway, I've committed some cleanup in HEAD.
Thanks. Now, we have some more warnings/errors:
http://www.gunduz.org/postgresql/postgres-A4.log.gz
Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= <[EMAIL PROTECTED]> writes:
> Thanks. Now, we have some more warnings/errors:
> http://www.gunduz.org/postgresql/postgres-A4.log.gz
You need bigger TeX settings. Please read "Building the Documentation".
regards, tom lane
--
41 matches
Mail list logo