Gavin Sherry wrote:
On Wed, 18 Aug 2004, Gaetano Mendola wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all,
now that we have the tablespace support don't you think that
each tablespace needs his own costs instead of a system wide
one ?
I searched in the archives and on the TODO list
Tom Lane wrote:
Gaetano Mendola [EMAIL PROTECTED] writes:
BTW I have bitten recently on the attempt of change the default port.
I did it as usual changing it in postgresql.conf but that parameter
is overriden by:
PGPORT=5432
present on the start up script.
There is any reason to still
this due the fact that moving that tuple will not
save any storage space ?
If not, am I missing something ?
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe
preference would be that it couldn't be turned on at all
except when psql's input is interactive.
I strongly vote for the same solution.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 8: explain analyze is your friend
procedure
that handle the failures without uman intervention.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
Eric Kerin wrote:
On Sun, 2004-08-15 at 16:22, Gaetano Mendola wrote:
Eric Kerin wrote:
On Sat, 2004-08-14 at 01:11, Tom Lane wrote:
Eric Kerin [EMAIL PROTECTED] writes:
The issues I've seen are:
1. Knowing when the master has finished the file transfer transfer to
the backup.
The standard
release.
Do you mean that the next pginstaller release will carry a 8.0beta1
with different behaviour that actual 8.0beta1 ?
I hope I mistake you.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
: error: void foo(int, float, int)
usualy C++ is not a good example as SQL is not :-)
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command
Oliver Jowett wrote:
Gaetano Mendola wrote:
Oliver Jowett wrote:
David Fetter wrote:
Dennis has pointed out that mixing the call-with-named-parameter
interface with call-by-order-of-parameters one would cause confusion,
Python's equivalent syntax allows you to mix the two forms so long as
all
Eric Kerin wrote:
On Wed, 2004-08-11 at 16:43, Tom Lane wrote:
Gaetano Mendola [EMAIL PROTECTED] writes:
Tom Lane wrote:
It should work; dunno if anyone has tried it yet.
I was thinking about it but I soon realized that actually is
impossible to do, postgres replay the log only if during
parameters: archive_current_wal_command and
archive_current_wal_delay.
I problem I discover during the tests is that if you shut down the spare node
and the restore_command is still waiting for a file then the postmaster will never
exit :-(
Regards
Gaetano Mendola
-BEGIN PGP SIGNATURE
(int, int a = 3) { } };
B b;
b.foo(3);
will call the B::foo.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
Andrew Dunstan wrote:
Gaetano Mendola wrote:
Bruce Momjian wrote:
Yes, the fix will be in beta2 or the next pginstaller release.
Do you mean that the next pginstaller release will carry a 8.0beta1
with different behaviour that actual 8.0beta1 ?
I hope I mistake you.
What are you talking about
Oliver Jowett wrote:
Gaetano Mendola wrote:
Oliver Jowett wrote:
Gaetano Mendola wrote:
Oliver Jowett wrote:
David Fetter wrote:
Dennis has pointed out that mixing the call-with-named-parameter
interface with call-by-order-of-parameters one would cause confusion,
Python's
Oliver Jowett wrote:
Gaetano Mendola wrote:
Oliver Jowett wrote:
David Fetter wrote:
Dennis has pointed out that mixing the call-with-named-parameter
interface with call-by-order-of-parameters one would cause
confusion,
Python's equivalent syntax allows you to mix the two forms so
current_name.tmp and after the copy:
~ mv current_name.tmp current_name.partial
Do you see any pitfall on it ?
I think in an hour I'll test it and I let you know.
Regard
Gaetano Mendola
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4 (MingW32)
Comment: Using GnuPG with Thunderbird - http
Manfred Spraul wrote:
Gaetano Mendola wrote:
a1) If exist check that is a 16MB file ( the request can
~arrive during the copy ),
I think this will fail under windows: copy first sets the file size
and then transfers the data. I wouldn't rule out that some Unices use
Tom Lane wrote:
Gaetano Mendola [EMAIL PROTECTED] writes:
I'm facing however to the following problems:
1) Discovery the actual WAL file
I'm supposing is the last modified file inside the
pg_xlog directory. If this is not the good method
may I know how I can know
python don't have overloaded function...
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
to do, postgres replay the log only if during the
start the file recover.conf is present in $DATA directory :-(
Am I missing the point ?
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 8: explain analyze is your friend
Tom Lane wrote:
Somebody should hack this together and try it during beta. I don't
have time myself.
Will see, if I have spare time I will try.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 2: you can get off all lists at once
Jan Wieck wrote:
On 8/9/2004 7:41 PM, Gaetano Mendola wrote:
If I remember well this is the first command that need to change
GUC in order to change behaviour, I don't think we wrote:
set vacuum_mode = full;
set vacuum_verbosity = on;
vacuum;
You got a point here. However, we don't have
of the question for most
people.
Not for Linus Torvalds apparently.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Gaetano Mendola
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Jan Wieck wrote:
On 8/9/2004 7:19 AM, Gaetano Mendola wrote:
Hi all,
I have seen the big debat about to have the delay
off or on by default.
Why not enable it by default and introduce a new
parameter to vacuum command itself ? Something like:
VACUUM WITH DELAY 100;
It's not just one
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Alvaro Herrera wrote:
| On Mon, Aug 09, 2004 at 07:19:44PM +0200, Gaetano Mendola wrote:
|
|
|So the other parameter will inserted in the new sintax too, I think is
|fundamental
|the ability of override this values during the vacuum call:
|
|VACUUM
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jan Wieck wrote:
| On 8/9/2004 1:19 PM, Gaetano Mendola wrote:
|
| Jan Wieck wrote:
|
| On 8/9/2004 7:19 AM, Gaetano Mendola wrote:
|
| Hi all,
| I have seen the big debat about to have the delay
| off or on by default.
|
| Why not enable it by default
Alvaro Herrera wrote:
On Sat, Aug 07, 2004 at 01:34:20AM +0200, Gaetano Mendola wrote:
Alvaro Herrera wrote:
Yeah. I included your tab-complete patch in the patch I sent to
pgsql-patches, which later Tom reworked and applied. His CVS comment
didn't mention the tab completion change. This isn't
should have to enable the delay by default, or does your
setup recoginize when it is being run on a lightly loaded system?
TODO: make vacuum_cost_naptime aware of system load
:-)
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 1: subscribe
Hi all,
I have a fresh installation of 8.0devel but I'm not able to
perform any backup using pg_dump:
$ pg_dump -p 5433 test
pg_dump: could not parse ACL list ([0:1]={postgres=UC/postgres,=UC/postgres}) for object
public (SCHEMA)
Regards
Gaetano Mendola
---(end
Tom Lane wrote:
Gaetano Mendola [EMAIL PROTECTED] writes:
I did a recovery strictly following the doc instructions, the recovery
succeded but I'm wondering if the following line in the logs is normal
or not.
cp: cannot stat `/home/pitr/0001.history': No such file or directory
Yes, see
G u i d o B a r o s i o wrote:
8.0 || 7.5??
8.0
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
Alvaro Herrera wrote:
On Tue, Aug 03, 2004 at 06:42:03PM +0200, Gaetano Mendola wrote:
I'm reading some comment on CVS and I seen this comment
for tab-complete.c revision 1.109:
Fix subtransaction behavior for large objects, temp namespace, files,
password/group files. Also allow read-only
.
regression=# \d test
Table public.test
Column | Type | Modifiers
+-+---
b | test|
c | integer |
The two insert in (1) and (2) are the same ( change only the column order ),
but the (1) works and the (2) not.
Regards
Gaetano Mendola
immediately see anything about PITR.
Yep, PITR docs is an open item.
And is really needed because we can not play/experiment/test it without
instructions...
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send
After two series 7.3 and 7.4 that ignore the force argument,
why don't remove it in the 8.0 ?
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command
noncontroversial
parts of Alvaro's recent mop-up patch, plus further work on large objects
to minimize use of the TopTransactionResourceOwner.
but the modification on that file have noting to see with this.
Is it normal ?
Regards
Gaetano Mendola
---(end of broadcast
a;
~ update record 2;
update record 2;
~ update record 1;
~ dead lock detected
I hope that looking at the code is possible understand what the problem is
( if exists ).
Regards
Gaetano Mendola
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4
implementation is not a epoch change about you ?
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 8: explain analyze is your friend
Hi all,
I'm seeing that a link is missing inside the src directory,
the last version is 7.4.1 !! There is also something wrong
with the doc directory.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 7: don't forget to increase your free space
Christopher Browne wrote:
After takin a swig o' Arrakan spice grog, Gaetano Mendola [EMAIL PROTECTED] belched
out:
Peter Eisentraut wrote:
Alvaro Herrera wrote:
What was the rule for increasing the first number after just before
7.0?
That was just to avoid having to release a 6.6.6, which Jan
Marc G. Fournier wrote:
On Mon, 2 Aug 2004, Gaetano Mendola wrote:
Hi all,
I'm seeing that a link is missing inside the src directory,
the last version is 7.4.1 !! There is also something wrong
with the doc directory.
Please provide an exact path for what you are seeing ... everything I
see
dbame.public.current_connection
or
Performing: VACUUM ANALYZE public.current_connection@dbname
I know that I will know the database on the very next line, but sometimes
is too late :-(
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 5: Have you checked
Matthew T. O'Connor wrote:
Gaetano Mendola wrote:
I don't have idea about the database involved, I suggest:
Performing: VACUUM ANALYZE dbame.public.current_connection
or
Performing: VACUUM ANALYZE public.current_connection@dbname
I know that I will know the database on the very next line
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Marc G. Fournier wrote:
|
| all fixed ... had a kernel panic this morning, and fsck took a while to
| run ...
Also news.fr.postgresql.org it seems down since yesterday.
Regards
Gaeatano Mendola
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tom Lane wrote:
| Gaetano Mendola [EMAIL PROTECTED] writes:
|
|kalman=# create table test ( a integer, b integer );
|CREATE TABLE
|kalman=# create table test1 ( c integer , d test );
|CREATE TABLE
|
|
|kalman=# alter table test drop column b;
|ALTER
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tom Lane wrote:
| Gaetano Mendola [EMAIL PROTECTED] writes:
|
|Tom Lane wrote:
|| I was just looking around the net to see exactly what Oracle's PL/SQL
|| syntax is. It doesn't seem too unreasonable syntax-wise:
|| [ snip pl/sql syntax
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tom Lane wrote:
| Greg Stark [EMAIL PROTECTED] writes:
|
|Gaetano Mendola [EMAIL PROTECTED] writes:
|
|kalman=# insert into test values (1 ,(2,(3,(4,(5,(6, null));
|INSERT 33639 1
|kalman=# select * from test;
|~ a | b
, even minor
|ones. Either send in a patch or committers can modify the file
|directly.
Did you forget to insert the autovacuum integrated ?
Regards
Gaetano Mendola
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
style answer.
We have only one engine: the full transactional one. If the OP need to have
for example the MEMORY one the he can easily create a RAM disk and with the
tablespaces support he can create tables or index or whatever objects
in memory.
Regards
Gaetano Mendola
the exception:
~THROW 3::INTEGER;
in this way who throw the exception can also transfer informations
on what is going on.
Am I may be not understanding what are you trying to do ?
Regards
Gaetano Mendola
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4 (MingW32)
Comment: Using GnuPG
=# create table test1 ( d integer, e test );
CREATE TABLE
kalman=# select * from test1;
d | e
---+---
(0 rows)
kalman=# select e from test1;
e
---
(0 rows)
kalman=# select (e).a from test1;
a
---
(0 rows)
Regards
Gaetano Mendola
---(end of broadcast
kalman=# select * from test1;
server closed the connection unexpectedly
~This probably means the server terminated abnormally
~before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
!
Regards
Gaetano Mendola
-BEGIN PGP SIGNATURE
have consensus on what I'm to
do about this?
We are already in a features freeze period, or not ?
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
'2004-07-21';
count
---
22441
(1 row)
why then the planner choose to do an index scan using the filter that retrieve a
bigger ammount of rows ? A bug ?
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 5: Have you checked our
Bruce Momjian wrote:
Gaetano Mendola wrote:
Bruce Momjian wrote:
Scott Marlowe wrote:
I use a checkpoint_segments = 16 but in my pg_xlog I have
35 files. Why 35 files ?
You have 35 because the max files in pg_xlog is 2*checkpoint_segments +1
or something like that. This is documented
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Matthew T. O'Connor wrote:
| Gaetano Mendola wrote:
|
| Well, today I stop the pg_autovacuum and I did a vacuum full and I
| reindexed
| all big tables and other 500 MB were reclamed. Could be the pg_autovacuum
| running yesterday the responsible
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Matthew T. O'Connor wrote:
| Gaetano Mendola wrote:
|
| I'm pretty sure, see the attached graph. Each morning at 7 a script stop
| the autovacuum, vacuum full the database and reindex the eavy updated
| tables
| and restart of course the autovacuum
to on in the
configuration file but was shown as off with a SHOW stats_start_collector
inside a psql section.
That GUC variable is resetted to off is the collector doesn't start ?
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 5: Have you checked
attaching boot graphs ( HD space usage and load ).
Regards
Gaetano Mendola
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFA/Ydh7UpzwH2SGd4RAuhKAKCTftBGjBLSfR+OTy5vHlYpL46TXQCfc65/
VfepMM87dQKvg3rswhGUNL8=
=HWHy
--+--+-+---+-+-
16759 |1 | | 15910 | AccessShareLock | t
| | 7714652 | 15910 | ExclusiveLock | t
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 6: Have you searched our
Hi all,
why after compiling and install postgresql CVS tip
there is no information on how to run it ? Also
the file INSTALL is not there anymore.
Do I miss something in these days ?
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 9
of open an already invalid transaction.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
LOCK DETECTED
abort;
STILL BLOCKED
Why that commit unblock the SESSION 1?
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send
Hi all,
I'm compiling the last postgres CVS version and I get:
vacuum.c: In function `repair_frag':
vacuum.c:1528: warning: unused variable `myXID'
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go
?
Regards
Gaetano Mendola
--- pgsql_patched/src/bin/psql/tab-complete.c 2004-07-19 17:21:50.0 +0200
+++ pgsql/src/bin/psql/tab-complete.c 2004-05-26 15:56:55.0 +0200
@@ -463,8 +463,8 @@
ABORT, ALTER, ANALYZE, BEGIN, CHECKPOINT, CLOSE,
CLUSTER, COMMENT
Alvaro Herrera wrote:
On Sun, Jul 18, 2004 at 01:06:39AM +0200, Gaetano Mendola wrote:
I'm doing some experiments with NT, I din't expect this behaviuor:
First of all, let me point that the behavior on deadlock has been agreed
to change. Instead of only aborting the innermost transaction
Alvaro Herrera wrote:
Gaetano, please apply the latest savepoints patch (savepoint-5.patch)
and let me know how it goes ...
where is it ?
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 8: explain analyze is your friend
;
~ DEAD LOCK DETECTED
~ abort;
STILL BLOCKED
Why that commit unblock the SESSION 1?
Regards
Gaetano Mendola
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4 (MingW32)
Comment: Using GnuPG with Thunderbird - http
I think the second begin shall fail instead of open an already invalid transaction.
Regards
Gaetano Mendola
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFA+bEz7UpzwH2SGd4RAujVAJ4wBx64eSKwokcBUl
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all,
I'm compiling the last postgres CVS version and I get:
vacuum.c: In function `repair_frag':
vacuum.c:1528: warning: unused variable `myXID'
Regards
Gaetano Mendola
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4 (MingW32)
Comment: Using
Christopher Browne wrote:
A long time ago, in a galaxy far, far away, Gaetano Mendola [EMAIL PROTECTED]
wrote:
I was thinking of something much simpler where Jan would create an
ARC patch against 7.4.X and have it either in /contrib for 7.4.X or
on our ftp servers, or on a web site. I could
Transaction
3) WIN32 porting
4) ARC
5) Table Space
6) I'm sure I'm forgetting something
was really too much.
I hope that all will be fine.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan
is managed without kernel intervention.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 8: explain analyze is your friend
) code, palloc would fit very
well. But does palloc depend on some other part of the Postgres code?
If you don't mind you can write your application in C++ and use a
boost smartpointer:
http://www.boost.org/libs/smart_ptr/smart_ptr.htm
Regards
Gaetano Mendola
---(end
Gaetano Mendola wrote:
Tom Lane wrote:
Gaetano Mendola [EMAIL PROTECTED] writes:
I think a warning is missing if I create a table without OIDS that
inherits from a table with oids:
don't you think a warning shall to be raised here ?
Nope ... this is not different from the behavior for merging
not use the RAII Idiom, or at least without be a joggler
3) I miss the const modifier for methods, and I really can not be sure of what
happen to my objects when are used around.
Do you want now speak about the missing template feature? Don't say template
are the same of Generics.
Regards
Gaetano
)
don't you think a warning shall to be raised here ?
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 8: explain analyze is your friend
Tom Lane wrote:
Gaetano Mendola [EMAIL PROTECTED] writes:
I think a warning is missing if I create a table without OIDS that
inherits from a table with oids:
don't you think a warning shall to be raised here ?
Nope ... this is not different from the behavior for merging duplicate
column
Tom Lane wrote:
Although DROP TABLESPACE can detect tables existing in the target
tablespace, it doesn't have any way to detect schemas that reference
that tablespace as their default tablespace. Thus you can get
implementation-level failures like this one:
$ mkdir /tmp/junk
regression=# create
created by a transactions that were
in-progress when the server crashed
I don't think is a good idea put the words: when the server crashed in a TODO
list, may be is better write: when the server is killed abruptly.
My 2 cents.
Regards
Gaetano Mendola
---(end of broadcast
Scott Marlowe wrote:
On Fri, 2004-06-11 at 11:02, Bruce Momjian wrote:
Gaetano Mendola wrote:
[ PGP not available, raw data follows ]
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Bruce Momjian wrote:
| Gaetano Mendola wrote:
|
|Bruce Momjian wrote:
|
| I understand your points below. However
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Bruce Momjian wrote:
| Gaetano Mendola wrote:
|
|Bruce Momjian wrote:
|
| I understand your points below. However, the group has weighed in the
| direction of clearly showing non-default values and not duplicating
| documentation. We can change
me what happen if
I comment out a value changing the value. Kill UP the postmater.
Recommenting that value and now re killing the postmaster.
I believe that postmaster will not run with the default value.
Who will look the configuration file will not understand the right
reality.
Regards
Gaetano
the table from RAM to DISK
Regards
Gaetano Mendola
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFAxDC07UpzwH2SGd4RAm3KAJ9HFgvTSqXSGCh3Xx2n6+Mfqb7AcQCgzWht
CeFGnUTQrD9AWOTvwdkVr0A=
=evpH
-END PGP
keys, which pre-7.4 btrees
didn't handle well at all). This is just speculation though, without
proof as yet.
Another information to know is if there are connection in the
unfamous state: Idle in transaction.
Is usefull if the OP show us the vacuum verbose output.
Regards
Gaetano Mendola
have enough
RAM your OS will mantain that table on RAM, don't you think ?
BTW if you trust on your UPS I'm sure you are able to create a RAM
disk and place that table in RAM.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 8: explain analyze
Tom Lane wrote:
I was just looking at this macro:
/*
* PageGetMaxOffsetNumber
*Returns the maximum offset number used by the given page.
*Since offset numbers are 1-based, this is also the number
*of items on the page.
*
*NOTE: to ensure sane behavior if the
Gaetano Mendola wrote:
Tom Lane wrote:
We could fix this by changing the declarations of the maxoff variables
to int, but I think it's probably cleaner to recode
PageGetMaxOffsetNumber like so:
#define PageGetMaxOffsetNumber(page) \
(((PageHeader) (page))-pd_lower = SizeOfPageHeaderData ? 0
Tom Lane wrote:
Gaetano Mendola [EMAIL PROTECTED] writes:
kalman=# select * from v_v_test;
ERROR: infinite recursion detected in rules for relation v_test
I think also my other message:
passing a whole record
is a bug that shall to be fixed.
Regards
Gaetano Mendola
Hi all,
I compiled postgres7.5devel and I see that during
compilation are used togheter:
-Wall -Wmissing-proptotype -Wmissing-declaration
there is any reason to specify after -Wall others
warning ?
Regards
Gaetano Mendola
---(end of broadcast
is that the variable quota have the same column name
for the table test, for us it's a minimum issue due the fact that
is easily fixed changing the variable name, but I'm wondering if
behind there is something wrong.
Regards
Gaetano Mendola
---(end of broadcast
=# select * from v_v_test;
ERROR: infinite recursion detected in rules for relation v_test
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
in the table so I vacuum analysed the
database. It had no effect. I had a vacuum full going on the table
for 17 hours before I killed it.
Are you sure that the vacuum full was running or sitting there to
wait an idle transaction ?
Regards
Gaetano Mendola
---(end of broadcast
, what you have to
do is decrease the cost of the index scan till is less of the sequential
scan cost.
Good luck.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining
Josh Berkus wrote:
Gaetano,
Hackers, what about to decrease the default values for this
quantities ?
Oh, I don't think Ismail has a bug, I think he probably just needs to tune his
database.
I just only suggesting to decrease that values that are oversized for a modern
hardware.
Regards
Gaetano
cost settings, and had mixed results.
| That's why I have no particular recommmendation for them.
|
Usually yes, decreasing that values I'm able to decrease the index scan
cost, so when I enable again the sequential scan the index one is choosed.
Regards
Gaetano Mendola
-BEGIN PGP SIGNATURE
Tom Lane wrote:
Gaetano Mendola [EMAIL PROTECTED] writes:
I just only suggesting to decrease that values that are oversized for
a modern hardware.
I've seen no evidence saying that random_page_cost needs to be decreased
for modern hardware. Disk seek speed versus bandwidth hasn't changed
WHERE
mydate BETWEEN '2004-04-24' AND '2004-05-24';
SELECT COUNT(*) AS c FROM articletbl WHERE
mydate = '2004-04-24';
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send
as
undeleateable.
I think this is resonable.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
201 - 300 of 411 matches
Mail list logo