Re: [PERFORM] Postgres Performance on CPU limited Platforms

omething seems seriously wrong. Should I be expecting more performance from this hardware than what I'm getting in these tests? Regards, George McCollister -- H. Hall ReedyRiver Group LLC http://www.reedyriver.com -- Sent via pgsql-performance mailing list (pgsql-performance

Re: [PERFORM] indexing for distinct search in timestamp based table

;2008-07-01 00:00:00'::timestamp without time zone) AND (start_time <= '2008-07-29'::date)) Total runtime: 75460.361 ms It seems to me there should be some way to create an index to speed this up, but the various ones I've tried so far haven't helped. Any suggestions would be greatly appreciated. -- H. Hall ReedyRiver Group LLC http://www.reedyriver.com -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance

Re: [PERFORM] Large number of tables slow insert

dx ON measures_0 USING btree (value); --- Regards Loïc Petit -------- -- H. Hall ReedyRiver Group LLC http://www.reedyriver.com -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your s

Re: [PERFORM] Using PK value as a String

e to inspect every row and decode it and then compare it or add it or whatever. Then I did misunderstand. -- H. Hall ReedyRiver Group LLC http://www.reedyriver.com -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http

Re: [PERFORM] SSD Performance Article

d SATA. HH -- H. Hall ReedyRiver Group LLC http://www.reedyriver.com -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance

Re: [PERFORM] "Big O" notation for postgres?

PFC wrote: On Wed, 21 May 2008 16:10:53 +0200, H. Hall wrote: Does anyone know if there is a source that provides "Big O" notation for postgres's aggregate functions and operations? For example is count(*) = O(1) or O(n)? Do the developers for postgres use Big O when selec

[PERFORM] "Big O" notation for postgres?

Does anyone know if there is a source that provides "Big O" notation for postgres's aggregate functions and operations? For example is count(*) = O(1) or O(n)? Do the developers for postgres use Big O when selecting algorithms? If so, is the info easily available? Thanks, HH

Re: [PERFORM] update 600000 rows

Note: I am resending this because the first never appeared after 40hrs. HH [EMAIL PROTECTED] wrote: Hello i have a python script to update 60 rows to one table from a csv file in my postgres database and it takes me 5 hours to do the transaction... I'm on debian etch with 8.1 postgres serv

Re: [PERFORM] update 600000 rows

[EMAIL PROTECTED] wrote: Hello i have a python script to update 60 rows to one table from a csv file in my postgres database and it takes me 5 hours to do the transaction... I'm on debian etch with 8.1 postgres server on a 64 bits quad bi opteron. I have desactived all index except the pr