« first day (356 days earlier)      last day (4247 days later) » 

6:11 PM
1
A: Is Acts 1:14 describing something like 24/7 prayer?

swasheckThe ambiguity actually comes in to play because προσκαρτεροῦντες is a present participle. The present tense has so many different categories, such as descriptive, iterative, durative, tendential, historical, futuristic that there is some ambiguity. These categories come from a perceived need to f...

@swasheck is 'pray continually' a single word? I think that is what you are saying.
Presumably you are not suggesting that Paul was definitely not speaking 'superlatively' - just that translation issues make it hard to be sure?
In other places it does seem Paul is happy to use superlatives, eg 1 Thess 3:10
perhaps even that is arguable - but cf 1 Thess 2:9
 
6:28 PM
@JackDouglas It doesn't look that way to me: classic.net.bible.org/…
 
 
2 hours later…
8:32 PM
oh my
i did a poor job of fleshing that out, eh?
 
8:46 PM
@JackDouglas Tremendous apologies
@JonEricson pray is not a verb in this context --- it's a dative noun
the verbs are "were" and "continuing" ... the present is confusing because you have a participle that claims to be present ... AND the word meaning is "continuing" so certainly there MUST be an ongoing/durative intent behind this
 
@swasheck Good point.
 
but the fact that it's a periphrasis sets it back to an imperfect "aspect" which describes simple past
they just did it
and they continued in it even though their leader left
thanks for calling me out on that ... my answer was misleading without that correction
 
9:47 PM
@swasheck heh, you already had +1 from me :p
 
@JackDouglas well thanks - but it was poor without the addendum
 
10:09 PM
@JackDouglas ... incoming postgresql question ... i may not be going about this the proper way (in any capacity - theory or otherwise) so feel free to correct me
i'm wanting to provide visual cues for words in a text (like all verbs of a particular tense are background red, etc.)
so i'm splitting a string on a space and then unnesting them
then i have a function that will get the specific details for that word
the following is the best set-based way i have found, so far
with words as
	(select unnest(string_to_array(analysis_text,' ')) as word from verse where version_id = 3 and searchref between 857 and 879 order by version_id, id)
select (worddetailsbyword(word)).*
	from words
it takes 85 seconds
this is a python parsing nightmare but takes 6 seconds
with words as
	(select unnest(string_to_array(analysis_text,' ')) as word from verse where version_id = 3 and searchref between 857 and 879 order by version_id, id)
select worddetailsbyword(word)
	from words
just doing this
select unnest(string_to_array(analysis_text,' ')) as words from verse where version_id = 3 and searchref between 857 and 879 order by version_id, id
and then iterating through and calling the function for each word in python is about 8 seconds
soooooooooooooo ... i'm assuming that there's not really a way to index on this function that joins a bunch of tables ...
ok ... done babbling
it may just be that i'm trying to do too much all at once
 
@swasheck what's driving this - performance?
 
yes
 
the 85s and 6s queries are basically the same
I'd want to explain them both and find out why one is so much slower
 
@swasheck if you can find a way of giving me access to your test environment I could do some active performance tuning for you ;)
 
@JackDouglas i'll look into that
dont worry too, too much about it
just thought that you might be able to identify a clear operator headspace error
 
@swasheck interesting - same plan
 
yep ...
 
could this be client-side?
try:
select count(*) from (
with words as
(select unnest(string_to_array(analysis_text,' ')) as word from verse where version_id = 3 and searchref between 857 and 879 order by version_id, id)
select (worddetailsbyword(word)).*
from words
) z
and analog
or better still:
select length(array_to_string(array_agg(output),'')) from (
with words as
(select unnest(string_to_array(analysis_text,' ')) as word from verse where version_id = 3 and searchref between 857 and 879 order by version_id, id)
select ((worddetailsbyword(word)).*)::text as output
from words
) z
that way you can get an idea of any size difference in the data being transferred
.
also, do you need all the fields in (worddetailsbyword(word)).* ?
 
10:34 PM
@JackDouglas i do --- i only return the fields that i needed in function
 
@swasheck that execution time incudes all the fetching and parsing in Python, right?
 
@JackDouglas actually those times are just on the postgres side ... this is the only execution time that interacts with python and it's ~8-11 seconds
 
@swasheck so are those "explain analyze" from psql?
 
pgadmin3
 
@swasheck can you try from psql?
there is something fishy here
 

« first day (356 days earlier)      last day (4247 days later) »