Re: [PERFORM] Query optimization help

2011/8/30 Ondrej Ivanič : > Could you please re-post your explain using this web site: > http://explain.depesz.com/ and post links to Stackoverflow question? Here it is: http://explain.depesz.com/s/Iaa > - try to disable nested loop join (set enable_nestloop=off) Even worse performance (http://e

[PERFORM] Query optimization help

Hello, I asked that question on StackOverflow, but didn't get any valuable response, so I'll ask it here. :) I have such query: SELECT "spoleczniak_tablica"."id", "spoleczniak_tablica"."postac_id", "spoleczniak_tablica"."hash", "spoleczniak_tablica"."typ", "spoleczniak_tablica"."ikona", "spolecz

[PERFORM] Query optimization help

Hello, I asked that question on StackOverflow, but didn't get any valuable response, so I'll ask it here. :) I have such query: SELECT "spoleczniak_tablica"."id", "spoleczniak_tablica"."postac_id", "spoleczniak_tablica"."hash", "spoleczniak_tablica"."typ", "spoleczniak_tablica"."ikona", "spolecz

Re: [PERFORM] ~400 TPS - good or bad?

2010/6/12 Szymon Kosok : > PS. pgbench scale is set to "1". I've found in mailing list archive that scale = 1 is not good idea. So we have ran pgbench -s 200 (our database is ~3 GB) -c 10 -t 3000 and get about ~600 TPS. Good or bad? -- Greetings, Szymon -- Sent via pgsql-p

[PERFORM] ~400 TPS - good or bad?

Hello, We are trying to optimize our box for Postgresql. We have i7, 8GB of ram, 2xSATA RAID1 (software) running on XFS filesystem. We are running Postgresql and memcached on that box. Without any optimizations (just edited PG config) we got 50 TPS with pg_bench default run (1 client / 10 transact