Re: [GENERAL] Lines of code in PG 8.0 & 8.1?

; 684533 > > > > and for 8.0.X I get: > > > > 648130 -- Nicolas Barbier http://www.gnu.org/philosophy/no-word-attachments.html ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] transaction limits?

thers will keep ignoring its rows. There is nothing to rollback here, thanks to MVCC. Of course, those rows will still be physically present until the next VACUUM. -- Nicolas Barbier http://www.gnu.org/philosophy/no-word-attachments.html ---(end of broadcast)--

Re: [GENERAL] sequences, moving from 8.0.4 to 8.1 ?

he expressions are actually not using ::text anymore? Normally they will keep the ::text, and only to change to the new system should you use the script. Most people *do* want the new behavior though, so run it :-). greetings, Nicolas -- Nicolas Barbier http://www.gnu.org/philosop

Re: [GENERAL] CUBE, ROLLUP, GROUPING SETS?

ulating all aggregations in one run for ROLLUP (instead of doing multiple scans). greetings, Nicolas -- Nicolas Barbier http://www.gnu.org/philosophy/no-word-attachments.html ---(end of broadcast)--- TIP 4: Have you searched our list archives?

Re: [GENERAL] More grist for the PostgreSQL vs MySQL mill

, Nicolas -- Nicolas Barbier http://www.gnu.org/philosophy/no-word-attachments.html ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [GENERAL] Installing Postegres side-by-side with M$ SQL server

2007/1/19, Paul Lambert <[EMAIL PROTECTED]>: A number of months ago I was pointed towards Postgre as a reliable database server Please don't use the word Postgre: http://stoned.homeunix.org/~itsme/postgre/>. greetings, Nicolas -- Nicolas Barbier http://www.gnu.org/phil

Re: [GENERAL] primary key index

u are supposed to see those indexes. Try "\d tablename" in psql. It should give you a bunch of information, including something like: Indexes: "tablename_pkey" PRIMARY KEY, btree (keyfieldname) Where tablename is your table's name, and keyfieldname the name of the column th

Re: [GENERAL] Indices for select count(*)?

quot; but SELECT > count("ID") from "XYZ" still takes 35 seconds*. (ID is the primary key > basing on a sequence, select count(*) isn't faster.) I would like to redirect you to the zillions of mailing list posts about this subject :-). > So - what kind of inde

Re: [GENERAL] to know

.postgresql.org/docs/whatsnew> > who is the leading person on postgre? http://www.postgresql.org/developer/bios> Greetings, Nicolas -- Nicolas Barbier http://www.gnu.org/philosophy/no-word-attachments.html ---(end of broadcast)--- T

Re: [GENERAL] Postgreql 8.0.3 temporary Table Strange behaviour

2006/4/24, Dany De Bontridder <[EMAIL PROTECTED]>: > and the "select count(*)" will be able to use index scan (faster) (in version > 8.1 ?) No, it won't. -- Nicolas Barbier http://www.gnu.org/philosophy/no-word-attachments.html -

Re: [GENERAL] Importance of re-index

nd for "binary". In the latter: It won't, because the splitting mechanism will never result in an almost-empty leaf. That can only be caused by deletions. greetings, Nicolas -- Nicolas Barbier http://www.gnu.org/philosophy/no-word-attachments.html ---