Ari Jolma [EMAIL PROTECTED] writes:
Is this kind of behavior intended. When I try to rename a table to
a reserved word - I have tried to use 'lseg' which is a type - postgres
gives me an error but the change has been partly done and the
only way back seems to be to go to the database
Ari Jolma [EMAIL PROTECTED] writes:
template1= create table a (a int);
CREATE
template1= select a from a union select a from a where a in (select a from
a);
NOTICE: _outNode: don't know how to print type 1044119613
NOTICE: _outNode: don't know how to print type 1044119613
Interesting.
Well, when you have 2.7 million records in a database, the code might be
as good
as it can be.
I have recoverd the performance lost when I moved to Postgres 7.0 by
executing
SET enable_indexscan = OFF before creating my cursors and turning it back on
for the inner loop query. It may even be
I have set index_scan off for tomorrow morning's run. I will let you know
what happens.
I think my problem is fixed. By disabling index scan while creating the
cursors and then turning it back on again for the small query that occurs in
my inner loop the performance has returned to normal
Does anyone have a startup script for Postgres 7.0 that I can throw into my
/etc/rc.d/init.d directory? (RedHat 6.1)
Thanks,
Sam
--
_
/ Samuel A. Mullen \
| Programmer Analyst |___
| Opportunities Unl. | More to be
"Terry Van Belle" [EMAIL PROTECTED] writes:
!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
HTMLHEAD
META content=3D"text/html; charset=3Diso-8859-1" http-equiv=3DContent-Type
META content=3D"MSHTML 5.00.2919.3800" name=3DGENERATOR
STYLE/STYLE
/HEAD
BODY bgColor=3D#ff
Ari Jolma wrote:
template1= select a from a union select a from a where a in (select a from
a);
NOTICE: _outNode: don't know how to print type 1044119613
NOTICE: _outNode: don't know how to print type 1044119613
a
-
(0 rows)
Hmm, I may be missing something, but "select a from a" is not
"Samuel A. Mullen" wrote:
Does anyone have a startup script for Postgres 7.0 that I can throw into my
/etc/rc.d/init.d directory? (RedHat 6.1)
A complete startup script is distributed with the RedHat RPMS for
PostgreSQL 7.0, available at
ftp://ftp.postgresql.org/pub/binary/v7.0/redhat-RPM
[EMAIL PROTECTED] (Jan Wieck) writes:
Do you mean the TOAST snapshot I provided?
No, he's just griping about the fact that manipulating many thousand
Large Objects in one transaction stresses the system unpleasantly.
(Too many table locks grabbed is the usual killer, I think.) TOAST
"Bryan White" [EMAIL PROTECTED] writes:
I have recoverd the performance lost when I moved to Postgres 7.0 by
executing SET enable_indexscan = OFF before creating my cursors and
turning it back on for the inner loop query. It may even be faster
then before so I am happy.
OK, so it was the
"Bryan White" [EMAIL PROTECTED] writes:
I have recoverd the performance lost when I moved to Postgres 7.0 by
executing SET enable_indexscan = OFF before creating my cursors and
turning it back on for the inner loop query. It may even be faster
then before so I am happy.
OK, so it was
On Fri, 26 May 2000, Martijn van Oosterhout wrote:
Ari Jolma wrote:
template1= select a from a union select a from a where a in (select a from
a);
NOTICE: _outNode: don't know how to print type 1044119613
NOTICE: _outNode: don't know how to print type 1044119613
a
-
(0 rows)
What distribution U utlize folks?
I have tried Mandrake 7 and it run perfectly just until I try to recompile
it (from RC1 to definitive) (remember Postgresql instability messages from
me?); After have totally reconfigured and recompiled 3 times I am trying a
shiteous suse6.4 demo(1CD) that
planx plnetx wrote:
What distribution U utlize folks?
I have tried Mandrake 7 and it run perfectly just until I try to recompile
it (from RC1 to definitive) (remember Postgresql instability messages from
RedHat 6.2.
Thomas Lockhart has Mandrake 7, and is one of the core developers -- he
On Thu, 25 May 2000, planx plnetx wrote:
What distribution U utlize folks?
I have tried Mandrake 7 and it run perfectly just until I try to recompile
it (from RC1 to definitive) (remember Postgresql instability messages from
me?); After have totally reconfigured and recompiled 3 times I
* planx plnetx [EMAIL PROTECTED] [000525 12:51] wrote:
What distribution U utlize folks?
I have tried Mandrake 7 and it run perfectly just until I try to recompile
it (from RC1 to definitive) (remember Postgresql instability messages from
me?); After have totally reconfigured and
Hi,
I am developing an application that will use the
C API for postgreSQL and I need to know this:
1 - How many tuples can be returned as a result of a
query using a CURSOR? (Is it possible to do a SELECT
* on a table that has 2 million records and OPEN a
CURSOR for that SELECT and show all
Martijn van Oosterhout wrote:
Ari Jolma wrote:
template1= select a from a union select a from a where a in (select a from
a);
NOTICE: _outNode: don't know how to print type 1044119613
NOTICE: _outNode: don't know how to print type 1044119613
a
-
(0 rows)
Hmm, I may be
Hi-
I'm a newbie at postgresql and was working on
sorting by category. What my question is, how do you
sort by category when using a variable. For instance,
you can sort by name in perl by doing:
$sqh = $dbh-prepare(q{select name from company order
by name;});
$sqh-execute();
but what if
Peter Landis wrote:
How do you sort by the variable?
$sqh = $dbh-prepare(q{select name from company order
by $sort_selection;});
$sqh-execute();
Your problem is not Perl specific. The order by column
must be in the result set (projection). Why not doing
it this way:
my @fields =
Ari Jolma [EMAIL PROTECTED] writes:
It seems that there needs to be a union and a subselect.
Yes.
And the really curious thing is that this problem seems
to depend on which redhat version there is!
It was trying to interpret a pointer-to-character-string as
a pointer to a Node, so the
Marcos Barreto de Castro [EMAIL PROTECTED] writes:
1 - How many tuples can be returned as a result of a
query using a CURSOR? (Is it possible to do a SELECT
* on a table that has 2 million records and OPEN a
CURSOR for that SELECT and show all records'contents
using FETCH FORWARD, for
HI!
i rescently upgraded my system from PG6.53 to PG7.0. after a few days of
work i am unable to do a vacuum on one of tables:
nat=# VACUUM verbose analyze osoby;
NOTICE: --Relation osoby--
NOTICE: Pages 189: Changed 0, reaped 24, Empty 0, New 0; Tup 3436: Vac
29, Keep/VTL 0/0, Crash 0,
Tom Lane writes:
The idea I suggested a couple of days ago was that initdb should refuse
to run if PGDATA exists and is nonempty. Sound reasonable?
Okay, let's do that. How do you find out if a directory is empty? The best
way I could think of is this:
test x"`ls -A "$PGDATA"`" = x
Are we
Marcin Inkielman [EMAIL PROTECTED] writes:
i rescently upgraded my system from PG6.53 to PG7.0. after a few days of
work i am unable to do a vacuum on one of tables:
nat=# VACUUM verbose analyze osoby;
NOTICE: FlushRelationBuffers(osoby, 182): block 186 is referenced
(private 0, global 3)
Peter Eisentraut [EMAIL PROTECTED] writes:
How do you find out if a directory is empty?
Good question.
The best way I could think of is this:
test x"`ls -A "$PGDATA"`" = x
The embedded quotes might confuse some shells, no? Perhaps better
CONTENTS=`ls -A "$PGDATA"`
if test
On Thu, 25 May 2000, Tom Lane wrote:
Date: Thu, 25 May 2000 19:49:00 -0400
From: Tom Lane [EMAIL PROTECTED]
To: Marcin Inkielman [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [GENERAL] PG 7.0 vacuum problem
Marcin Inkielman [EMAIL PROTECTED] writes:
i rescently upgraded my
Hello:
Novice, just installed PGSQL 7.0 on Redhat 6.1.
Everything went smoothly with initial installation and db setup.
However, I've run into some problems subsequently.
To keep it simple, here is a specific problem. Attempting to create a
database in an alternate location, I went
Try createdb -D $PGDATA2 testdb
At 11:26 PM 5/25/00, J.R. wrote:
Hello:
Novice, just installed PGSQL 7.0 on Redhat 6.1.
Everything went smoothly with initial installation and db setup.
However, I've run into some problems subsequently.
To keep it simple, here is a specific problem.
Try createdb -D $PGDATA2 testdb
I will be surprised if that works. The initlocation manual says -D can
be a path or an environment variable which will be referenced. Not sure
what that means.
At 11:26 PM 5/25/00, J.R. wrote:
Hello:
Novice, just installed PGSQL 7.0 on Redhat 6.1.
Try createdb -D $PGDATA2 testdb
At 11:26 PM 5/25/00, J.R. wrote:
Hello:
OK, I see this in the code, so it seems $PGDATA2 and 'PGDATA2' are the
same:
if [ "$?" -ne 0 -a ! -d "$Location" ]; then
PGALTDATA=`printenv $Location 2 /dev/null`
if [ -z "$PGALTDATA" ]; then
echo
For those people using pg_dump and pg_dumpall, are you making sure your
dump files are not world-readable?
--
Bruce Momjian| http://www.op.net/~candle
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+
I have completed my book. New chapters include:
Chapter 18, Functions and Triggers
Chapter 20, Administration
I still need to work on the appendix and index.
I want to thank the many people who e-mailed me with suggestions and
encouragement. This helped make the book better,
33 matches
Mail list logo