[GENERAL] slow update but have an index

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.os

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

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 account

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

Hi, Is there a function like: select md5() 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-lounge/docs

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

ow is that Postgres can do our job too. > > Any help on this much 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 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[GENERAL] replica question

machine A is down What I would like to achieve is that the tables in both databases are kept consistent. How to do this with postgres ? Do a write a C-program for that that is started by a trigger ? Thanks, Feite Brekeveld

[GENERAL] dump of dictionary

? Thanks, Feite Brekeveld

[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] 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] please some help on trigger creation

ensive ! 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] embedded sql pointer to structure question

SERT 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] 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] problems with pgplsql looping through query results (FOR row IN)

FOR row 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

[GENERAL] how to do a select distinct within pgplsql

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

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

update table set statusflag = 'U' 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

Re: [GENERAL] IpcMemoryCreate

r command > (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) -- Feite Brekeveld [EMAIL PROTECTED] http://www.osiris-it.nl ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe

Re: [GENERAL] IpcMemoryCreate

- > TIP 2: you can get off all lists at once with the unregister command > (send "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]

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