191 reputation
39
bio website
location B.C., Canada
age 24
visits member for 2 years, 1 month
seen 2 days ago

Nov
4
awarded  Notable Question
Jul
2
awarded  Curious
Jan
29
awarded  Popular Question
Jul
17
awarded  Notable Question
Jun
27
awarded  Notable Question
Mar
18
awarded  Popular Question
Mar
7
awarded  Popular Question
Dec
10
accepted Determining which isolation level is appropriate
Dec
9
comment Determining which isolation level is appropriate
I'm a little bit confused because non-repeatable reads seem to be a good thing but would slow down the database, but dirty reads and phantoms are generally considered a bad thing? I say non-repeatable reads are good because they get the most current data.
Dec
9
revised Determining which isolation level is appropriate
now it would be read commited, not read uncommited
Dec
9
revised Determining which isolation level is appropriate
PostgreSQL is used
Dec
9
revised Determining which isolation level is appropriate
added schema
Dec
9
asked Determining which isolation level is appropriate
Dec
9
accepted Usefulness of a multi-attribute index
Dec
8
comment Usefulness of a multi-attribute index
But if you only had first_second_idx and ran select * from test where first = 'whatever'; would first_second_idx be used?
Dec
8
asked Usefulness of a multi-attribute index
Dec
5
comment Permission denied in file trying to import
Got it thanks. How did you know to use single and not double quotes? Is that a general rule for postgres or what's the difference?
Dec
5
accepted Permission denied in file trying to import
Dec
4
comment Permission denied in file trying to import
@dezso that worked! Is that the "proper" way of doing it?
Dec
4
asked Permission denied in file trying to import