Re: [GENERAL] turn WAL off.

Slightly off topic for this thread... I figured I give it a whirl... I've often wondered what sort of performance increase one would get by placing the WAL on a solid-state drive like a 2 or 4GB TiGi. Has anyone tested this type of setup for a performance gain? For a 2GB drive it runs ~$3000. It

[GENERAL] Foreign Key ON DELETE CASCADE Performance

PostgreSQL 7.4.2 ... The tables in question have been vacuumed. ...stepping gingerly into the woods of foreign keys... I need some advice: Given a foriegn key structure: table1.p1 uniqueidentifier table2.p1 uniqueidentifier table3.p1 uniqueidentifier table4.p1 uniqueidentifier table4.q1 uniqueid

Re: [GENERAL] Copy and xml files

COPY works for whole tables, and can't append rows. You're going to have to escape your linebreaks and tabs to use COPY ... As I recall, you can specify your own custom column and row delimiters... You might consider creating some type of primary key for the table. A "serial" column would work fin

Re: [GENERAL] Creating GUID

You want http://gborg.postgresql.org/project/uniqueidentifier/projdisplay.php CG --- Ivar <[EMAIL PROTECTED]> wrote: > Hi, > > How to generate GUID("f741d0ce-351c-4c8d-9625-d23765ca7f45") values in > postgre ? > > > > > ---(end of broadcast)-

[GENERAL] TSearch2 ... ignore word repetition for rank

For my particular case, word repetition shouldn't be relevant in determining the rank of a document. If I strip() the vector, I loose what relevance proximity and weight add to the rank. It seems impossible, yet I ask anyway: Is it possible to eliminate the second (third, fourth, fifth, etc.) occur

[GENERAL] pg_dump dies on a renamed sequence... (7.2)

pg_dump: query to get data of sequence "profile_id_seq" returned name "profiles_id_seq" I renamed a sequence using PgAdmin II from profiles_id_seq to profile_id_seq. Any suggestions on getting everything synched to the proper names again? CG __ Do you Yahoo!? SB