table level locking different in 7.0?
От | Jim Mercer |
---|---|
Тема | table level locking different in 7.0? |
Дата | |
Msg-id | 20000517194525.A6047@reptiles.org обсуждение исходный текст |
Ответы |
Re: table level locking different in 7.0?
|
Список | pgsql-hackers |
i used to have a database on freebsd using 6.5.3. i had several concurrent processes which would do inserts via COPY and queries. on that system, i don't recall the COPY processes as being blocked by the query processes. now i'm running that app on solaris 7 with pgsql 7.0. i'm finding that a big long select is blocking other processes which are doing COPY's. i'm also finding that other queries are blocking. the only real difference between what was running before and what is running now is the use of an ORDER BY clause in the big long select, since 7.0 seems to need this to return records in the same order as 6.5.3 (i know, i shouldhave been using the ORDER BY in 6.5.3, but, such is the way it is). is the blocking i'm seeing supposed to be happening? or did i miss some flag or something when installing on solaris? -- [ Jim Mercer jim@reptiles.org +1 416 410-5633 ] [ Reptilian Research -- Longer Life through Colder Blood ] [ Don't be fooled by cheap Finnish imitations; BSD is the One True Code. ]
В списке pgsql-hackers по дате отправления: