[PERFORM] Sincere apology for my insults and hand-waving in these mails:the jokes for pg concurrency write performance

2010-02-01 Thread wyx6fox
 I want say to the developer of pg, Thanks very much , you make so great project。   I think i am not a rough guy , Please forgive me.

Re: [PERFORM] the jokes for pg concurrency write performance

2010-02-01 Thread Richard Broersma
On Feb 1, 2010, at 8:57 PM, wyx6...@sina.com wrote: i found a joke ,maybe this joke concurrency strategy is the designer's pround idea, but i think it is a joke , next let me describe the problems: I would suggest that the behavior that you dislike so much is really not idea of the postg

Re: [PERFORM] the jokes for pg concurrency write performance

2010-02-01 Thread david
On Tue, 2 Feb 2010, wyx6...@sina.com wrote: hi, first, thanks u for make so good opensource db . first you thank the developers, then you insult them. are you asking for help or just trying to cause problems. recently maybe half an years ago ,i begin to use pg in a big project for insuran

Re: [PERFORM] use pgsql in a big project, but i found pg has some big problem on concurrency write operation, maybe a joke for myself !

2010-02-01 Thread Kevin Grittner
wrote: > hi, first, thanks u for make so good opensource db . Not a bad start. > [insults and hand-waving] Not a good way to continue. If there's some particular performance problem you would like to try to solve, please read these pages, and try again: http://wiki.postgresql.org/wiki/Slo

[PERFORM] the jokes for pg concurrency write performance

2010-02-01 Thread wyx6fox
hi, first, thanks u for make so good opensource db . recently maybe half an years ago ,i begin to use pg in a big project for insurance project, belong as the project go on ,and i found some performance problem on concurrency write situation , then i do a research on concurrency write strategy

[PERFORM] use pgsql in a big project, but i found pg has some big problem on concurrency write operation, maybe a joke for myself !

2010-02-01 Thread wyx6fox
hi, first, thanks u for make so good opensource db .   recently maybe half an years ago ,i begin to use pg in a big project for insurance project, belong as the project go on ,and i found some performance problem on concurrency write situation , then i do a research on concurrency write strateg

Re: [PERFORM] Slow query: table iteration (8.3)

2010-02-01 Thread Glenn Maynard
On Mon, Feb 1, 2010 at 6:15 AM, Yeb Havinga wrote: > Glenn Maynard wrote: >> SELECT highscores_for_steps_and_card(s.id, 591, 1) FROM stomp_steps s; >> Seq Scan on stomp_steps s  (cost=0.00..793.52 rows=2902 width=4) >> (actual time=26509.919..26509.919 rows=0 loops=1) >> Total runtime: 26509.972 m

Re: [PERFORM] Slow query: table iteration (8.3)

2010-02-01 Thread Yeb Havinga
Glenn Maynard wrote: Hitting a performance issues that I'm not sure how to diagnose. SELECT highscores_for_steps_and_card(s.id, 591, 1) FROM stomp_steps s; Seq Scan on stomp_steps s (cost=0.00..793.52 rows=2902 width=4) (actual time=26509.919..26509.919 rows=0 loops=1) Total runtime: 26509.972

Re: [PERFORM] Constraint propagating for equal fields

2010-02-01 Thread Віталій Тимчишин
30 січня 2010 р. 04:30 Greg Stark написав: > 2010/1/28 Віталій Тимчишин > > > > I've always thought that PostgreSQL would propagate constraint from > field1 to field2 if condition says field1=field2, but this does not seem the > case: > > version? > > PostgreSQL 8.3.7 on amd64-portbld-freebsd7.2