Re: [GENERAL] Performance problem with 50,000,000 rows

obliged. (Yes I ran vacuum analyze). David Link White Plains, NY ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org -- Feite Brekeveld [EMAIL PROTECTED] http://www.osiris-it.nl

[GENERAL] how to get the md5 result of a string ?

Hi, Is there a function like: select md5(attribute_name) from Thanks, -- Feite Brekeveld [EMAIL PROTECTED] http://www.osiris-it.nl ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users

[GENERAL] slow update but have an index

into SQL statements like: update accounting set status = 'C' where seqno = 1566385; and the other 74,000 This is awfully slow. How come ? The index on the seqno should give speedy access to the record. Thanks, -- Feite Brekeveld [EMAIL PROTECTED] http://www.osiris-it.nl

Re: [GENERAL] slow update but have an index

Martijn van Oosterhout wrote: On Fri, Aug 17, 2001 at 01:08:29PM +0200, Feite Brekeveld wrote: Now this table has about 80,000 records. I need to update 74,000 status fields. So I made a dump, and hacked the dump into SQL statements like: update accounting set status = 'C' where seqno

Re: [GENERAL] slow update but have an index

Martijn van Oosterhout wrote: On Fri, Aug 17, 2001 at 01:40:32PM +0200, Feite Brekeveld wrote: Well, an index speeds it up, but that times 80,000 will still take a while. Is there any trickery or will this work? update accounting set status = 'C'; If so, that will be much

Re: [GENERAL] Database Size

jackie wrote: Hello EveryBody How could I get the size(MB) of the Database du on the datadirectory where the database are located. Feite

Re: [GENERAL] IpcMemoryCreate

, Feite -- Joakim Bomelin Gröna Verket AB 040-691 91 36 ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED]) -- Feite Brekeveld [EMAIL

Re: [GENERAL] IpcMemoryCreate

unregister YourEmailAddressHere to [EMAIL PROTECTED]) -- Feite Brekeveld [EMAIL PROTECTED] http://www.osiris-it.nl ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[GENERAL] update ... from where id in (..) question

' where id = 'id10'; statements, which were executed in a fraction of a second. Has someone an explanation for this ? -- Feite Brekeveld [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[GENERAL] problems with pgplsql looping through query results (FOR row IN)

IN SELECT * FROM cdr_accounting WHERE connection_id = _conn_id LOOP ts := ts + row.time_stamp END LOOP; return ts; END;' LANGUAGE 'plpgsql'; How to get this one to work ? Thanks, -- Feite Brekeveld [EMAIL PROTECTED] http://www.osiris-it.nl

[GENERAL] how to do a select distinct within pgplsql

too. Thanks, -- Feite Brekeveld [EMAIL PROTECTED]

[GENERAL] to_timestamp question

Hi, I need to convert thisone into an integer timestamp value: 14:57:55.540 UTC Sun Mar 4 2001 How to deal with the milliseconds part (.540) and the timezone UTC ? Thanks, -- Feite Brekeveld [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5

[GENERAL] embedded sql pointer to structure question

INTO testVALUES(:pmr-id, :pmr-value); ... } I get the message :ERROR: The variable id is not declared -- Feite Brekeveld [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[GENERAL] please some help on trigger creation

e ! Am I overlooking some posibilities here ? Thanks, Feite Brekeveld ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

[GENERAL] calling a fuction within a function

-based trigger to store the new record ? Thanks, Feite Brekeveld ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

[GENERAL] PHP 3.0.16 and pg_cmdtuples

: -- This compilation does not support pg_cmdtuples() in db_pgsql.inc on line 122 which is crapp because I built it with exactly the same config options. What could pissibly be wrong here ? Thanks, Feite Brekeveld

[GENERAL] dump of dictionary

? Thanks, Feite Brekeveld