Re: [GENERAL] pg_repack and Postgres versions > 9.4

I wonder why this is not a VACUUM option. On Fri, 16 Dec 2016 at 15:30 Kenneth Marshall wrote: > On Fri, Dec 16, 2016 at 09:15:51AM -0500, Bill Moran wrote: > > > > Does anyone have experience using pg_repack on Postgres versions > 9.4? > > Specifically 9.5, but probably 9.6 at

Re: [GENERAL] [HACKERS] RH9 postgresql 8.0.7 rpm

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Devrim GUNDUZ wrote: Hi, On Wed, 2006-04-12 at 13:07 +0200, Gaetano Mendola wrote: I was able to create it with: --nodeps --define 'buildrhel3 1' --define 'build9 1' I'll be hppy if you send the RPMs directly to me; so that I can upload

Re: [GENERAL] RH9 postgresql 8.0.7 rpm

Joshua D. Drake wrote: Gaetano Mendola wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, I'm trying to build the rpms for RH9, I downloaded the srpm for RH9 but I'm stuck on these errors: RH9 is not a supported platform by RedHat or PGDG. I thought given this link http

Re: [GENERAL] [HACKERS] RH9 postgresql 8.0.7 rpm

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Devrim GUNDUZ wrote: Hi Gaetano, On Tue, 2006-04-11 at 18:31 +0200, Gaetano Mendola wrote: I'm trying to build the rpms for RH9, I downloaded the srpm for RH9 but I'm stuck on these errors: Attempt a: # rpmbuild --rebuild postgresql-8.0.7

Re: [GENERAL] Indexen on 8.0.3

) from my_view; where fi is eligible for be marked as STABLE but is not. In 8.0 in that select are involved n+1 snapshots instead of one as it in 7.4. Could this be a performance issue ? Regards Gaetano Mendola ---(end of broadcast)--- TIP 1

[GENERAL] RSS date still broken

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, how I already wrote, the RSS feed report as date: 1 jan 1970 for all entries. Regards Gaetano Mendola -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.5 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

Re: [GENERAL] Postresql RFD version 2.0 Help Wanted.

in the archives. I think that NG is the best way to follow the discussion and shall be at least a complete container for them and a complete archive mirror too. Regards Gaetano Mendola ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go

Re: [GENERAL] Gborg down?

a script on my remote server that I was running in BG before to touch the network, that script was bringing up the network if was down for more then 2 minutes. My server is now hosted in my house and I do not need it anymore, I changed it with the no-ip script :-) Regards Gaetano Mendola

Re: [GENERAL] '1 year' = '360 days' ????

Guy Fraser wrote: Trivia: In approximately 620 million years a day will be twice as long as it is today. Do you think then that Postgres628M.0 will fix it ? :-) Regards Gaetano Mendola ---(end of broadcast)--- TIP 8: explain analyze is your

Re: [GENERAL] [SECURITY] New set of PostgreSQL RPMS are available for download

not distribute with next RPM the psycopg instead ? 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])

Re: [GENERAL] (S)RPMs for PostgreSQL 7.2.6, 7.3.8 and 7.4.6 are ready

: http://mendola.no-ip.com/rpm746.htm 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])

Re: [GENERAL] PgSQL MVCC vs MySQL InnoDB

) Create or delete and index or alter a table will recreate the entire table. 3) Our rollback is a O(1) operation not O(N) where N is the operations performed during the transaction Regards Gaetano Mendola ---(end of broadcast)--- TIP 7: don't

Re: [GENERAL] Problem with query plan

log_runs = ceil(LOG6(nruns)); double npageaccesses; Regards Gaetano Mendola ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] table size/record limit

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Dennis Gearon wrote: | Gaetano Mendola wrote: | | Dennis Gearon wrote: | | I am designing something that may be the size of yahoo, google, ebay, | etc. | | Just ONE many to many table could possibly have the following | characteristics

Re: [GENERAL] Slony-I 1.0.4 Released

Christopher Browne wrote: Oops! Gaetano Mendola [EMAIL PROTECTED] was seen spray-painting on a wall: Chris Browne wrote: The Slony-I team is proud to present the 1.0.4 release of the most advanced replication solution for the most advanced Open Source Database in the world. The release

Re: [GENERAL] correct example of a functional index usage?

Tom Lane wrote: Since we don't yet have bitmap combining of indexes... ^^^ Are you trying to tell us something ? :-) Regards Gaetano Mendola ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] index not used?

col='1' AND row='10'; also, have you vacuumed / analyzed the table? I'm assuming yes. I assume not, seen that cost... Regards Gaetano Mendola ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] table size/record limit

you'll have nightmares with it... Regards Gaetano Mendola ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [GENERAL] Slony-I 1.0.4 Released

.tar.gz May I use it on a machine with a postgres 7.4.5 installed with RPM ? Regards Gaetano Mendola ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] delayed input

Hicham G. Elmongui wrote: I need this for a side project. Is there a way to do something like this: SELECT * FROM DelayedTable('tablename', 5); No, at my knowledge you'll obtain the first tuple only when the function exit. Regards Gaetano Mendola ---(end of broadcast

Re: [GENERAL] removing idle connections

not include the psycopg instead of the actual python driver ? 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: [GENERAL] Change query priority

Barry S wrote: Thats fine, but you do understand that nice (linux) will have *no* effect on I/O? I do. For any non-trivial table (that can't be held entirely in memory), re-nice will almost certainly have no effect. That's my feeling too, but at least is a try. Regards Gaetano Mendola

Re: [GENERAL] Recovering data from corrupted table. Urgent Help!!

. Regards Gaetano Mendola PS: I had the same error for the first time in my postgres usage life only after ( some weeks after ) having upgrade from a 7.4.2 - 7.4.5 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http

Re: [GENERAL] memory leak of PQmakeEmptyPGresult??

Ann wrote: I found the reason of this question and fixed the bug :)) Why then don't you share it ? Regards Gaetano Mendola ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] could not access status of transaction 4244329

( blocks of 8K ) till reach that offset reclaimed. 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

Re: [GENERAL] psql : how to make it more silent....

. Is there a way to get rid of these messages modify your log_error_verbosity to terse Regards Gaetano Mendola ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] Recovering data from corrupted table. Urgent Help!!

( blocks of 8K ) till reach that offset reclaimed. Regards Gaetano Mendola ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] Recovering data from corrupted table. Urgent Help!!

Gaetano Mendola wrote: [EMAIL PROTECTED] wrote: Hi: Is there any way to recover data from a corrupted table? I can only run SELECTs on certain WHERE conditions. I cannot vacuum, pg_dump, I've deleted the indexes and try to reindex, always get error: ERROR: could not access status

Re: [GENERAL] OS not good for database

Simon Windsor wrote: Hi Can you provide a link to the interview? Ops! I forget it :-( Here it is: http://www.alwayson-network.com/comments.php?id=6186_0_4_0_C Regards Gaetano Mendolaa ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [GENERAL] Change query priority

system. Regards Gaetano Mendola ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] Change query priority

Tom Lane wrote: Gaetano Mendola [EMAIL PROTECTED] writes: I feel that renice a backend will not kill your system. It won't kill the system, but it probably won't accomplish what you hoped for, either. That's true but right now renice a backend is the only way to procede in order to *try

Re: [GENERAL] deadlock with vacuum full on 7.4.5

Joseph Shraibman wrote: That is what I wanted to know, how to get the evidence for next time. select * from pg_locks Regards Gaetano Mendola ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe

Re: [GENERAL] 8.0 questions

his counterpart *nix 8.0 this because lot of code already mature in *nix environment is new in the win32 one. Regards Gaetano Mendola ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail

Re: [GENERAL] interfaces for python

JDBC interface version this interface delay the transaction open at the first statement. I think that the new postgres rpm shall insert this interface instead the PyGres one. Regards Gaetano Mendola ---(end of broadcast)--- TIP 7: don't forget

Re: [GENERAL] VACUUM FULL on 24/7 server

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Matthew T. O'Connor wrote: | Gaetano Mendola wrote: | | Matthew T. O'Connor wrote: | | Since you are running autovacuum I doubt the doing vacuumdb -a -z is 3 | times a day buying you much. It's not a bad idea to do once in a while. | | | | The reason

Re: [GENERAL] VACUUM FULL on 24/7 server

. Regards Gaetano Mendola PS: I do not have any idle in transaction connections around. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [GENERAL] VACUUM FULL on 24/7 server

Tom Lane wrote: Gaetano Mendola [EMAIL PROTECTED] writes: Christopher Browne wrote: Assuming that the tables in question aren't so large that they cause mass eviction of buffers, it should suffice to do a plain VACUUM (and NOT a VACUUM FULL) on the tables in question quite frequently

Re: [GENERAL] VACUUM FULL on 24/7 server

Matthew T. O'Connor wrote: On Sun, 2004-10-03 at 21:01, Gaetano Mendola wrote: Tom Lane wrote: Gaetano Mendola [EMAIL PROTECTED] writes: Christopher Browne wrote: pg_autovacuum -d 3 -v 300 -V 0.5 -S 0.8 -a 200 -A 0.8 I'm not very familiar at all with appropriate settings for autovacuum

Re: [GENERAL] ODBC for PostgreSQL 7.4

Astha Raj wrote: Hi All, I want to connect to PostgreSQL 7.4 from my Windows machine. What ODBC version is needed? Is there any other important settings required? I am very new to this database. Search on google: odbc postgresql and I'm feeling lucky. Regards Gaetano Mendola

Re: [GENERAL] Foreign key order evaluation

from acquiring a lock on the same row, so those transactions will block until the transaction holding the lock completes. There are some proposal to have another kind of lock in order to avoid the above. I hope soon. Regards Gaetano Mendola ---(end of broadcast

Re: [GENERAL] Getting an out of memory failure.... (long email)

] analyze_threshold: 4464024; vacuum_threshold: 2790190 for the point 2) I suggest you to cron analyze during the day. Regards Gaetano Mendola ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] Réf. : Re: R?f. : Re:

Lane modified the test in order to get rid this from that OS. It's not bad, however now are two platforms with that glitch. Regards Gaetano Mendola ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan

Re: [GENERAL] Comparing a varchar of length 32

a = '01234567890123456789012345678901234567890123'; length 44 (1 row) Just an idea, could you reindex your table ? Regards Gaetano Mendola ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] Number of Active Connections

MaRCeLO PeReiRA wrote: Hi guys, How can I know about the number of active connections?? (not the maximum allowed, but the number of open connections). If you have enough permission: select count(*) from pg_stat_activity; Regards Gaetano Mendola ---(end of broadcast

Re: [GENERAL] What is the postgres version of mysql's ON DUPLICATE KEY

With a rule you can do it easily ( never tried ). Regards Gaetano Mendola ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] Salt in encrypted password in pg_shadow

Greg Stark wrote: Gaetano Mendola [EMAIL PROTECTED] writes: Well, when SHA-0 was ready NSA suggested to apply some changes in order to correct some flaw discovered and SHA-1 comes out, interesting NSA never wrote which flaw was corrected! May be SHA-1 is trasparent water to NSA eyes

Re: [GENERAL] postgresql hanging (blocking) with smp kernel

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: [GENERAL] Gentoo for production DB server?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Jeremiah Elliott wrote: | Gaetano Mendola wrote: | | Barry S wrote: | | In article [EMAIL PROTECTED], Christine Desmuke wrote: | | Hello: | | At the risk of starting a flame-war, I'd like some more details on the | use of Gentoo Linux for a production

Re: [GENERAL] Gentoo for production DB server?

Barry S wrote: In article [EMAIL PROTECTED], Christine Desmuke wrote: Hello: At the risk of starting a flame-war, I'd like some more details on the use of Gentoo Linux for a production PostgreSQL server. There have been a couple of comments lately that it is not such a great idea; does anyone have

Re: [GENERAL] postgres on in the internet

to throw around data over the Internet without using SSL for all the various reasons: DNS hijacking, TCP replay, etc. If not you can tunnel it. Regards Gaetano Mendola ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose

Re: [GENERAL] Can we return a table from a function?

/interactive/plpgsql-control-structures.html#PLPGSQL-STATEMENTS-RETURNING I'm not finding the equivalent for 7.4 about the first link. Regards Gaetano Mendola ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan

Re: [GENERAL] Performance on 7.4 vs 7.2?

I don't know what changes from 7.2 - 7.4 but effective_cache_size is too little IMO, or at least incongruous with sort_mem. Try to rise that parameter to something more realistic. Regards Gaetano Mendola ---(end of broadcast)--- TIP 1: subscribe

Re: [GENERAL] Conditional foreign key?

' AND NEW.customer_id IN (SELECT customer.id FROM customer WHERE featurex=TRUE ) DO ... ? too many tries to count Any pointers, hints, or info on this kind of statement? This is a trigger job not a rule one. Regards Gaetano Mendola ---(end of broadcast

Re: [GENERAL] Forcing a stored procedure recompile

a bit ugly, though, and it'd make maintenance a bigger problem. Right now unfortunately this is the only one solution. See the post on performance (8/28/2004) with the title: ill-planned queries inside a stored procedure Regards Gaetano Mendola ---(end of broadcast

Re: [GENERAL] Connection to a PG 8.0 Beta 1 win32 server

all md5 # IPv4-style local connections host all all 127.0.0.1 255.255.255.255 md5 host all all 192.168.0.0 255.255.255.255 md5 # IPv6-style local connections: #host all all ::1/128 md5 If you want allow all the network 192.168.0.0 then your netmask have to be: 255.255.0.0 Regards Gaetano Mendola

Re: [GENERAL] Python and 8.0 beta

on my 8.0beta1 installation Regards Gaetano Mendola ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] No connection to a PG 8.0 Beta 1 win32 server

Secrétariat wrote: I don't have a telnet server on the Win XP Pro PC acting as PG server for Beta1 ! So ? If you do: telnet your server 5432 the command only open a TCP connection to the port 5432, this will test if you are able to reach your server. Regards Gaetano Mendola

Re: [GENERAL] Postgresql 8.0 beta 1 - strange cpu usage statistics and slow

where I did some tests. Regards Gaetano Mendola ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [GENERAL] Connection to a PG 8.0 Beta 1 win32 server

= true port = 5432 I can't connect from the LAN, NEITHER from the local machine ?! Where I've made a mistake ? Show us your pg_hba.conf, what is the exact error ? Regards Gaetano Mendola ---(end of broadcast)--- TIP 7: don't forget to increase your

Re: [GENERAL] pg_dump in stand alone backend

up and running. Regards Gaetano Mendola ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] Unsupported 3rd-party solutions (Was: Few questions

is following? Is the time mature enough ? 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])

Re: [GENERAL] Few questions on postgresql (dblink, 2pc, clustering)

and then with the help of SAN you can have two postmaster that are running on two different server that are belonging to a SAN and the common shared memory segment. /ScienceFiction Right now your only solution is buy a multiprocessor machine. Regards Gaetano Mendola -BEGIN PGP SIGNATURE- Version: GnuPG

Re: [GENERAL] Help with optimizing query

or you have to increase your default_statistics_target. 337 rows vs 3618 rows Regards Gaetano Mendola ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] Finally tsearch works ... somehow... remain a few

Oleg Bartunov wrote: Marcel, On Thu, 19 Aug 2004, Marcel Boscher wrote: For now i am almost statisfied with my tsearch2 installation war over night somehow it seems to work, finally... What does have tsearch2 that htdig doesn't have ( for index document I mean ) ? Regards Gaetano Mendola

Re: [GENERAL] Postgresql 8.0 beta 1 - strange cpu usage statistics and slow

620 seconds. In both case the cpu usage was near zero. I'm using a 2.2GHZ 1GB di RAM and I'm using 64MB to workmem. Regards Gaetano Mendola ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] Thousands of parallel connections

... Peter for 1 connections need then 61 GB that is quite amazing :-) Regards Gaetano Mendola ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [GENERAL] Does a 'stable' deferred trigger execution order exist?

) or 'A-B-Z' (on alfabet per event per transaction)?? For what I want to accomplish, I don't care about the order of A/B, but together they depend on the work that is done by the earlier triggered Z. The best way is to raise notice inside the trigger function and observe the results Regards Gaetano

Re: [GENERAL] Thousands of parallel connections

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Tom Lane wrote: | Gaetano Mendola [EMAIL PROTECTED] writes: | |I did last week an Ariadne+Postgresql valutation for the company where I work |and I learned that |with 250 MB you can open up to 80 concurrent query |with 500 MB you can open up to 120

Re: [GENERAL] BIGINT indexes still with problems

it again but executing before: set enable_seqscan = off; Depending on the results that you get may be you need to lower the index scan cost tuning the cpu related GUC variables. Regards Gaetano Mendola -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (MingW32) Comment: Using GnuPG

Re: [GENERAL] PostgreSQL 8.0.0 Officially Goes Beta

or directory. This might be caused by an FTP URL with an absolute path (which does not comply with RFC 1738). If this is the cause, then the file can be found at ftp://ftp3.us.postgresql.org/%2f/pub/postgresql/beta. Regards Gaetano Mendola -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (MingW32

Re: [GENERAL] PostgreSQL 8.0.0 Officially Goes Beta

Gaetano Mendola ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [GENERAL] PostgreSQL 8.0.0 Officially Goes Beta

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Rajesh Kumar Mallah wrote: | | The beta link under ftp://ftp3.us.postgresql.org/pub/postgresql/ | and possible all mirrors leads to nowhere. I guess many people | would click there. It works for me. Regards Gaetano Mendola -BEGIN PGP SIGNATURE

Re: [GENERAL] Create Table with Foreign Key Error

Type. Regards Gaetano Mendola -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFBGVHq7UpzwH2SGd4RAriNAKDRKJCpgGen8VVsxg//rmjqU+O6vgCg4u/9 9zcAUYNCfaeU2i9WVTXdh3k= =5YeH -END PGP SIGNATURE

Re: [GENERAL] getting dead locks with 2 functions

not thread safe? how do i make it so it is? | | thanx, amir | | On Fri, 06 Aug 2004 10:54:07 +0200, Gaetano Mendola [EMAIL PROTECTED] wrote: | | Amir Zicherman wrote: | | | I have the following 2 functions and I'm getting deadlocks when I call | | | | them from multiple threads. The first, I'm

Re: [GENERAL] PG over NFS tips

be more sensitive than Oracle? Anyone ever done this before in a production environment? thanks! Do you trust your data to a udp connection ? We had problem in copying big files ( 1.9GB ) in a mounted NFS partition and now we prefer to not use it anymore for our data. Regards Gaetano Mendola

Re: [GENERAL] constraitnt on case sensetive and case insensetive columns

varchar, c varchar ); CREATE TABLE regression=# create unique index test_idx on test ( upper(a), upper(b), c); CREATE INDEX Regards Gaetano Mendola -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

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

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 4: Don't 'kill -9

Re: [GENERAL] Insert speed question

? 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])

Re: [GENERAL] PostgreSQL Tablespaces

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: [GENERAL] Poatgresql database on more than one disk

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

Re: [GENERAL] Slow network retrieves

end sitting there days and days in that state ? Regards Gaetano Mendola ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [GENERAL] Before ship 7.4.2

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Lamar Owen wrote: | On Monday 02 February 2004 10:54 pm, Tom Lane wrote: | |Gaetano Mendola [EMAIL PROTECTED] writes: | |Is someone taking care about the fact that the pgdb.py shipped with |7.4.1 is the wrong version? | | |There is no pgdb.py

[GENERAL] Before ship 7.4.2

://archives.postgresql.org/pgsql-bugs/2002-12/msg00082.php 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])

Re: [GENERAL] PostgreSQL 7.4.1 and pgdb.py

. I'm not able to look at CVS to see where the modification was lost. 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: [GENERAL] PostgreSQL 7.4.1 and pgdb.py

-1PGDG.i386.rpm this problem was solved already on 7.3 look this: http://archives.postgresql.org/pgsql-bugs/2002-12/msg00082.php something did wrong during the SRPM file building for the 7.4.1 Is a good idea look how this happen. Regards Gaetano Mendola ---(end of broadcast

Re: [GENERAL] PostgreSQL 7.4.1 and pgdb.py

of that value. Regards Gaetano Mendola ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] Date column that defaults to 'now'

() you'll have the timestamp of transaction 2) DEFAULT timeofday() you'll have the timestamp of insertion Regards Gaetano Mendola ---(end of broadcast)--- TIP 6: Have you searched our list archives? http

Re: [GENERAL] why the need for is null?

length string is NULL! Isn't that funny ? Regards Gaetano Mendola ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [GENERAL] add column sillyness

[EMAIL PROTECTED] wrote: Please, read this carefully: http://sql-info.de/mysql/ I can not believe it! Regards Gaetano Mendola ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] add column sillyness

. And the funny here is that FK are not yet supported ! No regards. Gaetano Mendola ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [GENERAL] RPM RH9.0 conflict with unixODBC

. Is this also related to the fact that gdb on libraries of RH9.0 don't complain about the debugging info ? Regards Gaetano Mendola ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's

Re: [GENERAL] [off-topic] Bugtracker using PostgreSQL

tracking tool that have is not too much evolved, try it. 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: [GENERAL] VACUUM degrades performance significantly. Database

# elvtune /dev/sda7 /dev/sda7 elevator ID 5 read_latency: 64 write_latency: 8192 max_bomb_segments: 6 I'll try on my laptop. Reagards Gaetano Mendola ---(end of broadcast)--- TIP 7

Re: [GENERAL] VACUUM degrades performance significantly. Database

these values on your machine! 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: [GENERAL] Damaged table

Dagoberto wrote: can somebody tell me how can I get old data from a recently damaged table? What does mean damaged? Regards Gaetano Mendola ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] Question

and NULL are two different thinks. 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

Re: [GENERAL] insert duplicated unique/PK with no errors

Mirek Rusin wrote: ...what is the best way to force duplicated unique or primary key'ed row inserts not to raise errors? Doesn't make sense, am I missing the point ? Regards Gaetano Mendola ---(end of broadcast)--- TIP 4: Don't 'kill -9

Re: [GENERAL] How to find LIMIT in SQL standard

are created without OID. Regards Gaetano Mendola ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] Rockets (was Re: PostgreSQL versus MySQL)

/news-new.php/1?c=6531 ) this mean more users and more stress for our Postgres installation :-) http://www.arianespace.com/site/news/news_sub_missionupdate_index.html some pictures here: http://66.33.199.225/image_library/images_sub_index.html Regards Gaetano Mendola

Re: [GENERAL] High-volume shop uses PostgreSQL

Ron Johnson wrote: On Thu, 2003-09-18 at 03:23, Gaetano Mendola wrote: Ron Johnson wrote: PostgreSQL does not do horizontal scaling at all, since the postmaster can only run on 1 CPU, but it's good at vertical scaling, since it can make use of all of the CPUs in a box. (Well, there's sure

  1   2   >