Re: [HACKERS] 7.4RC1 tag'd, branched and bundled ...

2003-11-03 Thread Gaetano Mendola
Marc G. Fournier wrote: As Tom announced on Friday, Release Candidate 1 has now been tag'd and bundled ... please test to confirm that nothing seems off with this build Is in the last Tom's patch about Vacuum sleep between pages ? Regards Gaetano Mendola ---(end

Re: [HACKERS] 7.4RC1 tag'd, branched and bundled ...

2003-11-04 Thread Gaetano Mendola
Tom Lane wrote: Marc G. Fournier [EMAIL PROTECTED] writes: On Tue, 4 Nov 2003, Gaetano Mendola wrote: Is in the last Tom's patch about Vacuum sleep between pages ? that won't be in v7.4, to the best of my knowledge ... Definitely not. It's a very experimental patch. I not agree

Re: [HACKERS] 7.4RC1 tag'd, branched and bundled ...

2003-11-04 Thread Gaetano Mendola
Alvaro Herrera wrote: On Tue, Nov 04, 2003 at 05:35:42PM +0100, Gaetano Mendola wrote: I agree in general with you for these general arguments, but here we are talking about to introduce a sleep ( removable by guc ) or not! What about the hash refactoring introduced with 7.4? Are you going

Re: [HACKERS] Changes to Contributor List

2003-11-05 Thread Gaetano Mendola
? Who wrote a single line of code that now is inside Postgres? Who discovered a major bug ? Who partecipate actively to all discussions ? Regards Gaetano Mendola ---(end of broadcast)--- TIP 6: Have you searched our list archives? http

Re: [HACKERS] postgresql-7.4RC1 - Memory fault(coredump) on HP-UX

2003-11-06 Thread Gaetano Mendola
Verbus Counts wrote: {/opt/postgres/postgresql-7.4RC1}$ ll core -rw--- 1 postgres postgres726684 Nov 6 10:55 core Can you show us the stack trace ? Regards Gaetano Mendola ---(end of broadcast)--- TIP 4: Don't 'kill -9

Re: [HACKERS] pg_stat

2003-11-06 Thread Gaetano Mendola
. Regards Gaetano Mendola ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [HACKERS] Performance features the 4th

2003-11-09 Thread Gaetano Mendola
production DB). Regards Gaetano Mendola ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] [7.3.x] function does not exist ... ?

2003-11-10 Thread Gaetano Mendola
now return a timestamp with time zone and your function take a timestamp without time zone. ^^^ Regards Gaetano Mendola ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [HACKERS] *sigh*

2003-11-29 Thread Gaetano Mendola
, why not implement the same in a way builded in ? Regards Gaetano Mendola ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[HACKERS] rebuilding rpm for RH9 error

2003-12-01 Thread Gaetano Mendola
package unixODBC-devel-2.2.3-6 Regards Gaetano Mendola ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [HACKERS] rebuilding rpm for RH9 error

2003-12-02 Thread Gaetano Mendola
krb5-devel-1.2.7-10 krb5-libs-1.2.7-14 krb5-workstation-1.2.7-14 Regards Gaetano Mendola ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] rebuilding rpm for RH9 error

2003-12-02 Thread Gaetano Mendola
Lamar Owen wrote: On Monday 01 December 2003 08:53 pm, Gaetano Mendola wrote: Hi all, I'm still experiencing problem trying to rebuild the rpm from the file: postgresql-7.4-0.5PGDG.src.rpm I seen that the configure is done with: --with-krb5=/usr. You need to specify that you are building

Re: [HACKERS] rebuilding rpm for RH9 error

2003-12-04 Thread Gaetano Mendola
Lamar Owen wrote: On Tuesday 02 December 2003 06:29 pm, Gaetano Mendola wrote: Lamar Owen wrote: You need to specify that you are building for Red Hat 9 on the command I'll try. Ok. I did it on a RHAS 2.1 and I get: make[3]: Leaving directory `/usr/src/redhat/BUILD/postgresql-7.4/src/pl

[HACKERS] Double linked list with one pointer

2003-12-06 Thread Gaetano Mendola
= In this way we are going to save a pointer for each node, what do you think ? Regards Gaetano Mendola ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [HACKERS] [GENERAL] Backwards index scan

2003-12-21 Thread Gaetano Mendola
Tom Lane wrote: I have committed a fix into 7.5devel to do this properly. I think this is the last case wherein btree is unnecessarily inefficient for large numbers of equal keys. Any chance to have it on 7.4.1 ? Regards Gaetano Mendola ---(end of broadcast

[HACKERS] Little mess in RPM RH ?

2003-12-27 Thread Gaetano Mendola
version! I'm able to put my hand on RH 8.0, RH 9.0, RHAS 2.1 and RHAS 3.0 and RH 7.3 systems, if you need some help let me know. Regards Gaetano Mendola ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate

Re: [HACKERS] Little mess in RPM RH ?

2003-12-28 Thread Gaetano Mendola
. I still have a RH 6.2 machine in case anybody still wants that. I'll do it tomorrow, or is may be better do it for the 7.4.1 ? Regards Gaetano Mendola ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate

Re: [HACKERS] Preventing stack-overflow crashes (improving on max_expr_depth)

2003-12-31 Thread Gaetano Mendola
Tom Lane wrote: Comments? Really ugly but effective. Is ABS enough on a 64-bit architecture ? Or is better use labs ? Regards Gaetano Mendola ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate

Re: [HACKERS] Disaster!

2004-01-27 Thread Gaetano Mendola
it if slru.c had had less-paranoid error checking. [SNIP] Clap. Clap. Regards Gaetano Mendola ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] Idea about better configuration options for sort memory

2004-02-01 Thread Gaetano Mendola
be raise a warning if the old GUC is used, can speed the adoption of new GUCs variables. Regards Gaetano Mendola ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] CVS HEAD compile warning

2004-02-26 Thread Gaetano Mendola
Tom Lane wrote: Red Hat's still shipping 2.5.4a according to a quick look... Well Red Hat's still ship Postgres 7.3.4 ... I'm not considering anymore RH to be up to date with various versions :-( Gaetano ---(end of broadcast)--- TIP 9: the

[PERFORM] linux and anotime mount option

2004-03-31 Thread Gaetano Mendola
Do you know if postgres made assumption on the access time time stamp for the files on his own file sistem ? If not I'm wondering if mount a partition with the option anotime can improve the disk i/o performance. Regards Gaetano Mendola ---(end of broadcast

[HACKERS] idle in transaction with JDBC interface

2004-04-08 Thread Gaetano Mendola
in transaction 7) rollback;|rollback; ~| - Connection Idle AS you can see the JDBC driver must do a begin only before the first statement. Am I missing something ? Regards Gaetano Mendola -BEGIN PGP SIGNATURE

Re: [HACKERS] 7.5 beta version]

2004-04-16 Thread Gaetano Mendola
Jürgen Cappel wrote: Point 1 I completely agree on: byte order, alignment, padding, etc. is different for each platform and data cannot directly be exchanged. Point 2: who really needs C++ ?? We use it, a multi path TCP router written in C++ and behind there is a Postgresql... Regards Gaetano

[HACKERS] Invalid pg_hba.conf = Postgres crash

2004-04-24 Thread Gaetano Mendola
; shutdown TRUE LOG: next transaction ID: 195700; next OID: 5718523 LOG: database system was not properly shut down; automatic recovery in progress LOG: record with zero length at 0/4877FD78 LOG: redo is not required LOG: database system is ready Regards Gaetano Mendola

Re: [HACKERS] Invalid pg_hba.conf = Postgres crash

2004-04-24 Thread Gaetano Mendola
Tom Lane wrote: I was able to reproduce the crash but not the hang. Would you see if the attached patch fixes both symptoms on your machine? Yes, problem gone. I discover however that what I was believing an hang was in reality just a delayed crash. Regards Gaetano Mendola

[HACKERS] invalid memory alloc request size 0

2004-05-11 Thread Gaetano Mendola
Hi all, strange errors with a empty table: kalman=# create table test(); CREATE TABLE kalman=# select * from test t union select * from test t1; ERROR: invalid memory alloc request size 0 I think this have to return: -- (0 rows) Regards Gaetano Mendola ---(end

[HACKERS] pg_begintypend

2004-05-13 Thread Gaetano Mendola
: undefined symbol: pg_begintypsend I'm compiling my files in this way: gcc -c -g -fPIC -o email.o -I /usr/include/pgsql/server email.c gcc -g -shared -fPIC -o emaildt.so email.o which library I have to link in order to have the symbol pg_begintypsend ? Regards Gaetano Mendola

[HACKERS] tinyint

2004-05-10 Thread Gaetano Mendola
. -I /usr/include/pgsql/server I seen also that a library called libpgext.so is created. Shall I do the same ? Are guide line to use out there? Regards Gaetano Mendola ---(end of broadcast)--- TIP 6: Have you searched our list archives

Re: [HACKERS] pg_begintypend

2004-05-14 Thread Gaetano Mendola
Tom Lane wrote: Gaetano Mendola [EMAIL PROTECTED] writes: which library I have to link in order to have the symbol pg_begintypsend ? I think you want pq_begintypsend. Consider paying more attention to unknown-function warnings from your compiler. I had no warning at all, I think I have

Re: [HACKERS] email built in type

2004-05-10 Thread Gaetano Mendola
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Neil Conway wrote: | On Sat, 2004-05-08 at 13:10, Gaetano Mendola wrote: | |However an *add on* is an *add on* with not the same eligibility |of the main project | | | I'd suggest implementing the custom datatype first and packaging it | separately

[HACKERS] invalid type internal size -1

2004-05-14 Thread Gaetano Mendola
. (Internally, this is represented by setting typlen to -1.) I'm doing this on Postgres 7.4.1 Am I missing something ? Regards Gaetano Mendola ---(end of broadcast)--- TIP 6: Have you searched our list archives? http

Re: [HACKERS] psql 7.3.4 disagrees with NATURAL CROSS JOIN

2004-05-07 Thread Gaetano Mendola
Christopher Kings-Lynne wrote: Just a note for the hackers, Jonathan (I think :) ) talked to me about this on the irc channel - we couldn't figure this one out. Seems that Exist a postgres irc server? If yes may I know the server and port ? Regards Gaetano Mendola

[HACKERS] Constraint not shown on \d ?

2004-05-07 Thread Gaetano Mendola
but is different because the first command create an index deleteable with a drop index. Regards Gaetano Mendola ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [HACKERS] COPY command - CSV files

2004-05-07 Thread Gaetano Mendola
:-o You should really get the CVS code if you want to hack on Postgres ... there are a lot of changes since 7.4.3. 7.4.3 is not out yet, even I don't find the TAG on CVS. Regards Gaetano Mendola ---(end of broadcast)--- TIP 5: Have you

Re: [HACKERS] Usability, MySQL, Postgresql.org, gborg, contrib,

2004-05-07 Thread Gaetano Mendola
is more close to postgres then plPython or plPerl, and after all is nearest SQL then plPtyhton or plPerl so a DBA find it more confortable then others languages. my two cents. Regards Gaetano Mendola ---(end of broadcast)--- TIP 5: Have you

Re: [HACKERS] Usability, MySQL, Postgresql.org, gborg, contrib,

2004-05-07 Thread Gaetano Mendola
that programmers are not aware of ( see select max(id) from foo; optimized with a order by + limit 1 ). Regards Gaetano Mendola ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[HACKERS] write a new built in type

2004-05-07 Thread Gaetano Mendola
inserted in the file at point 1 and what else ? For example how may I define the name for my new type ? Regards Gaetano Mendola ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[HACKERS] email built in type

2004-05-08 Thread Gaetano Mendola
Hi all, about you is it ok for you if I write the email built in type ? I know of course that I can do it with a DOMAIN. Regards Gaetano Mendola ---(end of broadcast)--- TIP 6: Have you searched our list archives? http

Re: [HACKERS] Constraint not shown on \d ?

2004-05-08 Thread Gaetano Mendola
the constraint too? 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 message can get through to the mailing list

Re: [HACKERS] email built in type

2004-05-08 Thread Gaetano Mendola
Tom Lane wrote: Gaetano Mendola [EMAIL PROTECTED] writes: about you is it ok for you if I write the email built in type ? You're going to have to explain why it has to be a built-in type. Can't you do what you want as a local add-on? Is it likely that the functionality you have in mind would

Re: [HACKERS] email built in type

2004-05-08 Thread Gaetano Mendola
Tom Lane wrote: Gaetano Mendola [EMAIL PROTECTED] writes: Tom Lane wrote: Can't you do what you want as a local add-on? I guess that for manage efficiently million of email addresses I need to have a built in type instead of a domain with a regex as validator, You probably ought to do some

Re: [HACKERS] Postgres Optimization: IO and Data Organization

2004-05-06 Thread Gaetano Mendola
, don't consider optimization that other DBMS are performing will be good also for postgres, I think Oracle made pre forking of a pool of process and this because a Oracle process when is forked do more work then a postmaster. Regards Gaetano Mendola ---(end of broadcast

[HACKERS] create type: recv and send function

2004-05-14 Thread Gaetano Mendola
Hi all, what is the purpose of two function send and receive when a new type is defined ? When these two functions are called ? Regards Gaetano Mendola ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate

[HACKERS] email data type first release

2004-05-16 Thread Gaetano Mendola
. = 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])

[HACKERS] Email data type

2004-05-16 Thread Gaetano Mendola
it on pgfoundry but apparently my DNS are unable to resolve www.pgfoundry.org. I'll put this version as soon the address become available. This is the first time that I wrote code for postgresql so please, if you can, do a sort of code revision on it. Comments are welcomed. Regards Gaetano Mendola

Re: [HACKERS] Email data type

2004-05-16 Thread Gaetano Mendola
Gaetano Mendola wrote: Hi all, this is the alpha version for the new email data type, is not written as built in type but as plug in, Tome Lane and others drove me in this direction. The type is indexable and provide also conversion methods: text -- email and the operator , is possible use

Re: [HACKERS] The features I'm waiting for.

2004-05-05 Thread Gaetano Mendola
, ... ) ? I'm looking forward to these tools indeed. Regards Gaetano Mendola ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] ALTER TABLE TODO items

2004-05-05 Thread Gaetano Mendola
definition could save us some pains. Regards Gaetano Mendola ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [HACKERS] Email data type

2004-05-17 Thread Gaetano Mendola
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Bruno Wolff III wrote: | On Sun, May 16, 2004 at 04:36:55 +0200, | Gaetano Mendola [EMAIL PROTECTED] wrote: | |The type is indexable and provide also conversion methods: | |text -- email |and the operator , is possible use it in select like

Re: [HACKERS] email data type first release

2004-05-17 Thread Gaetano Mendola
Greg Stark wrote: Gaetano Mendola [EMAIL PROTECTED] writes: Comments are welcomed. Well as long as you're asking... Email domains are case insensitive, but the left hand side is case sensitive. That's the only part that's hard to handle using a text data type, it would be kind of neat

Re: [HACKERS] Email data type

2004-05-17 Thread Gaetano Mendola
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Dave Page wrote: |-Original Message- |From: Gaetano Mendola [mailto:[EMAIL PROTECTED] |Sent: 17 May 2004 16:02 |To: Bruno Wolff III |Cc: [EMAIL PROTECTED] |Subject: Re: [HACKERS] Email data type | |About the domain literals, I think to validate

Re: [HACKERS] Call for 7.5 feature completion

2004-05-17 Thread Gaetano Mendola
Hans-Jürgen Schönig wrote: Somebody has posted sync multimaster replication (PgCluster) - nobody has commented on that. Maybe I am the only one who has ever tried it ... I didn't find it on pgFoundry, others place to look at it ? Regards Gaetano Mendola ---(end

[HACKERS] Why new features only in magior releases ?

2004-05-18 Thread Gaetano Mendola
will permit to delay a month the 7.5 without the pain to wait too long for some enhancements. Regards Gaetano Mendola ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [HACKERS] Why new features only in magior releases ?

2004-05-18 Thread Gaetano Mendola
Neil Conway wrote: Gaetano Mendola wrote: I well understand the reason to wait a 7.5 in order to delivery BIG changes that are requiring a initdb, but I don't understand why little enhancement can not be delivered in a 7.4.3 ( may be with a short period with a 7.4.3beta ) like the vacuum delayed

[HACKERS] emaildt_0.0.2

2004-05-19 Thread Gaetano Mendola
] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] - The validator still check only for '@' presence I have a question, how I have to order domain literal emails ? and also an email in a traditional form vs a domain literal, [EMAIL PROTECTED] [EMAIL PROTECTED] true o false? Regards Gaetano

Re: [HACKERS] Call for 7.5 feature completion

2004-05-20 Thread Gaetano Mendola
? Regards Gaetano Mendola ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [HACKERS] Call for 7.5 feature completion

2004-05-23 Thread Gaetano Mendola
: there is no a *second* possibility to do a *first* good impression. Regards Gaetano Mendola ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] Optimizer bug??

2004-05-24 Thread Gaetano Mendola
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

Re: [HACKERS] Big problem

2004-05-24 Thread Gaetano Mendola
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

Re: [HACKERS] Optimizer bug??

2004-05-24 Thread Gaetano Mendola
, what about to decrease the default values for this quantities ? Regards Gaetano Mendola ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [HACKERS] Optimizer bug??

2004-05-25 Thread Gaetano Mendola
, 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

Re: [HACKERS] Optimizer bug??

2004-05-25 Thread Gaetano Mendola
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

Re: [HACKERS] Optimizer bug??

2004-05-25 Thread Gaetano Mendola
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

Re: [HACKERS] Optimizer bug??

2004-05-25 Thread 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't changed

Re: [HACKERS] SELECT * FROM table LIMIT 1; is really slow

2004-05-26 Thread Gaetano Mendola
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

[HACKERS] -Wall and Wmissing-prototype

2004-05-28 Thread 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

[HACKERS] passing a whole record variable into a SQL command is not implemented

2004-05-28 Thread Gaetano Mendola
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

[HACKERS] false infinite recursion detected

2004-05-28 Thread Gaetano Mendola
=# 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

Re: [HACKERS] false infinite recursion detected

2004-05-29 Thread Gaetano Mendola
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

Re: [HACKERS] PageGetMaxOffsetNumber on uninitialized pages

2004-06-04 Thread Gaetano Mendola
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

Re: [HACKERS] PageGetMaxOffsetNumber on uninitialized pages

2004-06-04 Thread Gaetano Mendola
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

Re: [HACKERS] CREATE DATABASE on the heap with PostgreSQL?

2004-06-06 Thread 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

Re: [HACKERS] CREATE DATABASE on the heap with PostgreSQL?

2004-06-07 Thread Gaetano Mendola
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

Re: [HACKERS] Postres dilemma

2004-06-07 Thread Gaetano Mendola
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

Re: [HACKERS] Improving postgresql.conf

2004-06-10 Thread Gaetano Mendola
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

Re: [HACKERS] Improving postgresql.conf

2004-06-11 Thread 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 | documentation. We can change

Re: [HACKERS] File leak?

2004-06-14 Thread Gaetano Mendola
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

Re: [HACKERS] Improving postgresql.conf

2004-06-14 Thread Gaetano Mendola
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

Re: [HACKERS] Minor DROP TABLESPACE issue

2004-06-19 Thread Gaetano Mendola
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

[HACKERS] warning missing

2004-06-22 Thread Gaetano Mendola
) don't you think a warning shall to be raised here ? Regards Gaetano Mendola ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [HACKERS] warning missing

2004-06-22 Thread Gaetano Mendola
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

Re: [HACKERS] warning missing

2004-06-25 Thread Gaetano Mendola
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

Re: [HACKERS] warning missing

2004-06-28 Thread 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 for merging

Re: [HACKERS] [BUGS] [CHECKER] 4 memory leaks in Postgresql 7.4.2

2004-07-05 Thread Gaetano Mendola
) 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

Re: [HACKERS] SAN, clustering, MPI, Backplane Re: Postgresql on SAN

2004-07-12 Thread Gaetano Mendola
is managed without kernel intervention. Regards Gaetano Mendola ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [HACKERS] Release planning (was: Re: Status report)

2004-07-14 Thread Gaetano Mendola
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

Re: [HACKERS] Release planning

2004-07-15 Thread Gaetano Mendola
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

[HACKERS] NT + deadlock intended behaviour ?

2004-07-17 Thread Gaetano Mendola
; ~ 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

[HACKERS] NT and aborted transaction

2004-07-17 Thread Gaetano Mendola
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

[HACKERS] unused variable

2004-07-17 Thread Gaetano Mendola
-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

Re: [HACKERS] NT + deadlock intended behaviour ?

2004-07-18 Thread Gaetano Mendola
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

Re: [HACKERS] NT + deadlock intended behaviour ?

2004-07-18 Thread Gaetano Mendola
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

[HACKERS] NT tab complete patch

2004-07-19 Thread Gaetano Mendola
? 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

Re: [HACKERS] localhost redux

2004-07-20 Thread Gaetano Mendola
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

[HACKERS] check point segments leakage ?

2004-07-20 Thread Gaetano Mendola
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

Re: [HACKERS] check point segments leakage ?

2004-07-20 Thread Gaetano Mendola
--+--+-+---+-+- 16759 |1 | | 15910 | AccessShareLock | t | | 7714652 | 15910 | ExclusiveLock | t Regards Gaetano Mendola ---(end of broadcast)--- TIP 6: Have you searched our

[HACKERS] no instruction after install

2004-07-20 Thread Gaetano Mendola
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

[HACKERS] NT and aborted transaction

2004-07-20 Thread Gaetano Mendola
of open an already invalid transaction. Regards Gaetano Mendola ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[HACKERS] NT + deadlock intended behaviour ?

2004-07-20 Thread Gaetano Mendola
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

  1   2   3   4   5   >