[PERFORM] SSD, Postgres and safe write cache

bout new drives that has similar functionality and are cheap. Do you recommend cheap SSD drives that are suitable for DB needs? Regards Michal Szymanski -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org

[PERFORM] Performance with sorting and LIMIT on partitioned table

ub/postgres/ononeprtition.jpg and query is superfast because there is no sorting. The question is how to speed up query when we use partitioning? So far I have not found solution. I'm wonder how do you solve problems when result from partition must be sorted and after we want to di

Re: [PERFORM] Partitioned Tables and ORDER BY

I've described our problem here http://groups.google.pl/group/pgsql.performance/browse_thread/thread/54a7419381bd1565?hl=pl# Michal Szymanski http://blog.szymanskich.net http://techblog.freeconet.pl/ -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make ch

Re: [PERFORM] Domain vs table

I think I've found answer to my question http://www.commandprompt.com/blogs/joshua_drake/2009/01/fk_check_enum_or_domain_that_is_the_question/ Michal Szymanski -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription:

[PERFORM] Domain vs table

rows are updated/inserted but I've never make real comparision to separate table. Havy you made such comparision? Regards Michal Szymanski http://blog.szymanskich.net http://techblog.szymanskich.net -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make chang

Re: [PERFORM] Partitioned Tables and ORDER BY

ost=726844.88..748207.02 rows=8544855 width=37739) (actual time=149864.868..149864.876 rows=50 loops=1) it means 8544855 rows should be sorted and it takes long minutes. We have simpler situation than you and I will try to find solution tommorow :) Michal Szymanski http://blog.szymanskich.net h

Re: [PERFORM] Big problem with sql update operation

Tom Lane wrote: Michal Szymanski <[EMAIL PROTECTED]> writes: CREATE OR REPLACE FUNCTION test() RETURNS void AS $BODY$ DECLARE BEGIN FOR v_i IN 1..4000 LOOP UPDATE group_fin_account_tst SET credit = v_i WHERE group_fin_account_tst_id = 1; -- fo

[PERFORM] Big problem with sql update operation

ow what is a problem? Is it possible to commit transaction inside pgsql procedure because I think that maybe transaction is too long? Regards Michal Szymanski http://blog.szymanskich.net ---(end of broadcast)--- TIP 6: explain analyze is your friend