Guy Thornley <[EMAIL PROTECTED]> writes:
> What sort of performance numbers are you looking for? Without the throttle,
> I/O is nuked and other database activity takes an age, and with it, its much
> happier?
Some people say that VACUUM nukes their performance, and some don't
find it to be a probl
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello All,
I'm using postgresql 7.3.2
And noticed strange bahaviour of
explain analyze command.
I use it to see how pl/pgsql function is executed:
Here is the function:
CREATE or replace FUNCTION flow1() RETURNS setof cidr
AS 'declare
clientnets
On Monday 01 September 2003 20:57, you wrote:
> sad wrote:
> > Good day
> >
> > is it possible to define user variables in session ?
> > If not then is it planned to implement ?
> > or it is principially impossible in PosqtgreSQL
>
> psql has variables, but in general we don't support session varib
sad wrote:
is it possible to define user variables in session ?
If not then is it planned to implement ?
or it is principially impossible in PosqtgreSQL
psql has variables, but in general we don't support session varibles.
You could create a temp table and put a value in there easily.
Attached is compilation error messages of current CVS:
gcc -traditional-cpp -O2 -Wall -Wmissing-prototypes -Wmissing-declarations
-I../../../src/include -c -o pqcomm.o pqcomm.c
pqcomm.c: In function `StreamServerPort':
pqcomm.c:280: parse error before '<<' token
pqcomm.c:291: case label not wit
Kenji Sugita wrote:
Attached is compilation error messages of current CVS:
gcc -traditional-cpp -O2 -Wall -Wmissing-prototypes -Wmissing-declarations
-I../../../src/include -c -o pqcomm.o pqcomm.c
pqcomm.c: In function `StreamServerPort':
pqcomm.c:280: parse error before '<<' token
pqcomm.c:29
Dinar <[EMAIL PROTECTED]> writes:
> I thought that explain analyze doesn't execute query
You thought wrong. Is the manual's explanation not clear enough?
regards, tom lane
---(end of broadcast)---
TIP 9: the planner will ig
Could you possible have some type of variable (preferably the Transaction
ID) that can identify an individual process?
If something like this already exist, then disregard this post.
"Bruce Momjian" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> sad wrote:
> > Good day
> >
> > is
Architecture: Intel Pentium
Operating System: Redhat 7.2 (Linux 2.4.17)
PostgreSQL version: PostgreSQL-7.3.4
Compiler used: gcc 3.01
to_timestamp appears to pick up the time-of-day from the previous call's
return value if a date string has no time component. For example:
# select to_timestamp('2
Your name : Mincu Alexandru
Your email address : [EMAIL PROTECTED]
Bupp Phillips wrote:
Could you possible have some type of variable (preferably the Transaction
ID) that can identify an individual process?
There's pg_backend_pid() for 7.4 and backend_pid() as contrib module for
earlier releases.
Regards,
Andreas
---(end of broadcast)
"Stacy White" <[EMAIL PROTECTED]> writes:
> to_timestamp appears to pick up the time-of-day from the previous call's
> return value if a date string has no time component. For example:
Weird. I do not see that here, on either 7.3.4 or current sources.
Can anyone else reproduce it?
For the recor
Mincu Alexandru <[EMAIL PROTECTED]> writes:
> server segfaults when trying to move backward in a cursor.
This is fixed for 7.4. Previous releases do not support moving backward
in any query more complex than a single table scan.
regards, tom lane
On Tue, 2 Sep 2003, Tom Lane wrote:
> "Stacy White" <[EMAIL PROTECTED]> writes:
> > to_timestamp appears to pick up the time-of-day from the previous call's
> > return value if a date string has no time component. For example:
>
> Weird. I do not see that here, on either 7.3.4 or current source
On Tue, 2 Sep 2003, Stephan Szabo wrote:
>
> On Tue, 2 Sep 2003, Tom Lane wrote:
>
> > "Stacy White" <[EMAIL PROTECTED]> writes:
> > > to_timestamp appears to pick up the time-of-day from the previous call's
> > > return value if a date string has no time component. For example:
> >
> > Weird. I
On Tue, 2 Sep 2003, Stephan Szabo wrote:
> On Tue, 2 Sep 2003, Stephan Szabo wrote:
>
> >
> > On Tue, 2 Sep 2003, Tom Lane wrote:
> >
> > > "Stacy White" <[EMAIL PROTECTED]> writes:
> > > > to_timestamp appears to pick up the time-of-day from the previous call's
> > > > return value if a date stri
See the attached file for details
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
On Tue, Sep 02, 2003 at 12:17:28AM -0400, Tom Lane wrote:
> Guy Thornley <[EMAIL PROTECTED]> writes:
> > What sort of performance numbers are you looking for? Without the throttle,
> > I/O is nuked and other database activity takes an age, and with it, its much
> > happier?
>
> Some people say tha
Stephan Szabo <[EMAIL PROTECTED]> writes:
> I don't entirely understand all of what that code is doing, but I think
> there's something in there that needs to get fixed.
Oh-ho, this is interesting:
Build CVS tip on RHL 8.0 with --enable-cassert: no bug.
Build CVS tip on RHL 8.0 without --enable-
Stephan Szabo <[EMAIL PROTECTED]> writes:
> Replying to myself again:
> In DCH_processor (formatting.c), it doesn't seem to stop if it's in the
> middle of processing nodes but runs off the inout string, should the for
> loop be something like:
> for (n=node,s=inout;n->type!=NODE_TYPE_END && *s!='
On Wed, 3 Sep 2003, Tom Lane wrote:
> Stephan Szabo <[EMAIL PROTECTED]> writes:
> > Replying to myself again:
> > In DCH_processor (formatting.c), it doesn't seem to stop if it's in the
> > middle of processing nodes but runs off the inout string, should the for
> > loop be something like:
> > fo
21 matches
Mail list logo
