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
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 pass this parameter to postmaster ?
Regards
Gaetano Mendola
--
-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 without success.
Regards
Gaetano Mendola
-BEGIN PGP SIGN
I said, my 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
=> ctid = (0, 3);
could 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 appropri
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.
Th
n them.
For sure for a 24x7 service is a compulsory requirement have an automatic procedure
that handle the failures without uman intervention.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please se
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
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 t
Oliver Jowett wrote:
> Gaetano Mendola wrote:
>
>> Oliver Jowett wrote:
>>
>>> Gaetano Mendola wrote:
>>>
>>>> Oliver Jowett wrote:
>>>>
>>>>> David Fetter wrote:
>>>>>
>>>>>> Dennis has
int) { } };
struct B : A { void foo(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
rent_wal()
or even better having two new GUC 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
Ga
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 duri
s are: void foo(int, float)
a.cpp:2: 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 a
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
>
>>>
>>
>>This was fixed several days ago, after lengthy discussion on the -win32
>>list, and we have seen reported success, IIRC.
>
>
> Yes, the fix will be in beta2 or the next pginstaller release.
Do you mean that the next pginstaller release will carry a 8.0
4
>>> f(1,d=4,2,c=3)
SyntaxError: non-keyword arg after keyword arg
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
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 h
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
with the name .tmp and after the copy:
~ mv .tmp .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://enigmail.mozdev.org
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 wit
realized that actually is
impossible 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
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
-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
|>>
-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 va
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 jus
Gaetano Mendola
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
out 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
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
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
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
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
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 directo
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
---
umber of columns.
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
avepoint a;
~ update record 2;
update record 2;
~ update record 1;
~
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 (MingW32)
Comm
nably 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
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 comma
pshot and don't 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
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
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
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
implementation is not a epoch change about you ?
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 8: explain analyze is your friend
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"@&q
erforming: 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, but sometimes
is too late :-(
Regards
Gaetano Mend
-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 (Min
-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
|>>
-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:
|
-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 tab
the back end
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
-BEG
alman=# 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 broa
...
~END;
and of course who trhow 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-
V
ver miss this MySQL "feature".
Another "mysql people" 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
, 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
mpdb=# select count(*) from v_past_connections where login_time > '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
ing close to beta, can we 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
-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
-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 yesterda
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 ?
&g
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
t 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 "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
il instead of open an already invalid transaction.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
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: the
ughts ?
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
| mode | granted
--+--+-+---+-+-
16759 |1 | | 15910 | AccessShareLock | t
| | 7714652 | 15910 | ExclusiveLock | t
Regards
Gaetano Mendola
---(end of broadcast)--
Any ideas ?
I'm 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/
VfepMM87
al 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)-
oint are active ?
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", "B
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
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 trans
-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)
ransaction block
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+bEz7UpzwH2SGd4RAujVAJ4wBx64
abort;
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://enigmail.mozdev.org
iD8DBQFA+bD+7UpzwH2SGd4RAq0VAJ9rZQ3aJmsJM6WSlLqIERJzDDS9iQCeL5rT
rF7PkCaJ59PWNQw4C
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
>>&
2) Nested 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 cho
egment and the
shared memory is managed "without kernel intervention".
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 8: explain analyze is your friend
In that (as of yet unwritten) 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
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
I can 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 G
t an user of D could not use foo()
Having said that, I think a warning is motivated. The warning should state
that attributes (columns) present in the generalisation (the parent table)
cannot be hidden.
Right.
Regards
Gaetano Mendola
---(end of broadcast)-
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 dupli
)
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:
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 ta
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
able files 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
-
-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
|> >
reality.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 8: explain analyze is your friend
tly shifting range of live index 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
s:
1) copy 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
--
uently then other and you 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)--
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 <=
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 pa
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 fixe
=# 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
d variable into a SQL command is not
implemented
the problem 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 w
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
[EMAIL PROTECTED] wrote:
A single postgresql process may not see much benefit, because it does not
do background I/O,
Not yet, I believe that in 7.5 there is a component that do it.
Am I wrong ?
Regards
Gaetano Mendola
---(end of broadcast)---
TIP
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
--
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
elative CPU 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
---
201 - 300 of 418 matches
Mail list logo