|
|
|
@115
|
[115]
|
3 years |
joeh |
final lecture
|
|
|
|
@114
|
[114]
|
3 years |
joeh |
Second lecture on search
|
|
|
|
@113
|
[113]
|
3 years |
cs186 |
Section Notes on Concurrency Control and Recovery
|
|
|
|
@112
|
[112]
|
3 years |
cs186 |
|
|
|
|
@111
|
[111]
|
3 years |
cs186 |
|
|
|
|
@110
|
[110]
|
3 years |
joeh |
practice final
|
|
|
|
@109
|
[109]
|
3 years |
cs186 |
original geocoding lib
|
|
|
|
@108
|
[108]
|
3 years |
cs186 |
new memory lookup added
|
|
|
|
@107
|
[107]
|
3 years |
joeh |
ARIES
|
|
|
|
@106
|
[106]
|
3 years |
joeh |
lecture 22
|
|
|
|
@105
|
[105]
|
3 years |
joeh |
Lecture 21
|
|
|
|
@104
|
[104]
|
3 years |
cs186 |
small change to public index
|
|
|
|
@103
|
[103]
|
3 years |
cs186 |
small change to header file
|
|
|
|
@102
|
[102]
|
3 years |
cs186 |
Normalization Lecture Notes
|
|
|
|
@101
|
[101]
|
3 years |
joeh |
Getting on toward the end…
|
|
|
|
@100
|
[100]
|
3 years |
cs186 |
Move Kim to Seoul
|
|
|
|
@99
|
[99]
|
3 years |
cs186 |
Section Notes on Query Operators
|
|
|
|
@98
|
[98]
|
3 years |
cs186 |
Code coverage complete for librarymaps_controller
|
|
|
|
@97
|
[97]
|
3 years |
cs186 |
Only show top 10 closest authors.
|
|
|
|
@96
|
[96]
|
3 years |
cs186 |
fakenames
|
|
|
|
@95
|
[95]
|
3 years |
cs186 |
fakenames
|
|
|
|
@94
|
[94]
|
3 years |
cs186 |
remove M character
|
|
|
|
@93
|
[93]
|
3 years |
cs186 |
remove spurious colons
|
|
|
|
@92
|
[92]
|
3 years |
cs186 |
column names on fixtures
|
|
|
|
@91
|
[91]
|
3 years |
cs186 |
Fixture fixing.
|
|
|
|
@90
|
[90]
|
3 years |
joeh |
lecture 19
|
|
|
|
@89
|
[89]
|
3 years |
cs186 |
Solutions to midterm, with scores.
|
|
|
|
@88
|
[88]
|
3 years |
cs186 |
Check in functional test file.
|
|
|
|
@87
|
[87]
|
3 years |
cs186 |
Clean up
|
|
|
|
@86
|
[86]
|
3 years |
joeh |
More on normalization
|
|
|
|
@85
|
[85]
|
3 years |
joeh |
Fix typo in name
|
|
|
|
@84
|
[84]
|
3 years |
joeh |
Olston guest lecture
|
|
|
|
@83
|
[83]
|
3 years |
cs186 |
Make sure memtest outputs show up
|
|
|
|
@82
|
[82]
|
3 years |
cs186 |
Make sure mmgr failure make it to the output
|
|
|
|
@81
|
[81]
|
3 years |
cs186 |
Fix parsing of memtest output
|
|
|
|
@80
|
[80]
|
3 years |
joeh |
End of SQL and normalization lectures
|
|
|
|
@79
|
[79]
|
3 years |
cs186 |
Query Optimization Notes
|
|
|
|
@78
|
[78]
|
3 years |
cs186 |
db config
|
|
|
|
@77
|
[77]
|
3 years |
cs186 |
renaming
|
|
|
|
@76
|
[76]
|
3 years |
cs186 |
initial checkin of hw4
|
|
|
|
@75
|
[75]
|
3 years |
cs186 |
fix path on last call to pg_ctl
|
|
|
|
@74
|
[74]
|
3 years |
cs186 |
Note that rectangle test worth 0 points
|
|
|
|
@73
|
[73]
|
3 years |
cs186 |
Self test scripts and data for HW2
|
|
|
|
@72
|
[72]
|
3 years |
cs186 |
Library controller corrected
|
|
|
|
@71
|
[71]
|
3 years |
cs186 |
Hw3: initial version
|
|
|
|
@70
|
[70]
|
3 years |
cs186 |
The full list of California places sorted by distance from Berkeley.
|
|
|
|
@69
|
[69]
|
3 years |
cs186 |
|
|
|
|
@68
|
[68]
|
3 years |
cs186 |
Buffer Management details added
|
|
|
|
@67
|
[67]
|
3 years |
joeh |
practice tests from previous years
|
|
|
|
@66
|
[66]
|
3 years |
joeh |
query optimization
|
|
|
|
@65
|
[65]
|
3 years |
cs186 |
checksplit should return value of resetoffset
|
|
|
|
@64
|
[64]
|
3 years |
cs186 |
make sure to turn off bitmap scans too!
|
|
|
|
@63
|
[63]
|
3 years |
cs186 |
Clean up tests, makes them faster too.
|
|
|
|
@62
|
[62]
|
3 years |
cs186 |
Tests now start postgres right
|
|
|
|
@61
|
[61]
|
3 years |
cs186 |
Tests!
|
|
|
|
@60
|
[60]
|
3 years |
cs186 |
SQL Section
|
|
|
|
@59
|
[59]
|
3 years |
joeh |
Query Processing II slides
|
|
|
|
@58
|
[58]
|
3 years |
joeh |
Fix notation to distinguish |R| and [R]
|
|
|
|
@57
|
[57]
|
3 years |
joeh |
Query Processing Part 1 lectures
|
|
|
|
@56
|
[56]
|
3 years |
cs186 |
Section notes (Formal Query Languages) + SQL lecture notes
|
|
|
|
@55
|
[55]
|
3 years |
cs186 |
add comments
|
|
|
|
@54
|
[54]
|
3 years |
joeh |
Better comments!
|
|
|
|
@53
|
[53]
|
3 years |
joeh |
Provide the implementation of index_keydistance
|
|
|
|
@52
|
[52]
|
3 years |
joeh |
Fix the order of the cross-product expression on slide 14, as pointed out …
|
|
|
|
@51
|
[51]
|
3 years |
joeh |
Relational Algebra lecture
|
|
|
|
@50
|
[50]
|
3 years |
cs186 |
Relational Calculus lecture, last week's section notes and "big picture" …
|
|
|
|
@49
|
[49]
|
3 years |
cs186 |
never call box_distance for mindist calculations, it uses box centers not …
|
|
|
|
@48
|
[48]
|
3 years |
cs186 |
Ensure that randomboxes are properly formatted
|
|
|
|
@47
|
[47]
|
3 years |
cs186 |
Make MyStuff? consistent with the source tree!
|
|
|
|
@46
|
[46]
|
3 years |
cs186 |
California data set, add to README and setup.sql
|
|
|
|
@45
|
[45]
|
3 years |
cs186 |
Better comments in gistnext_checksplit
|
|
|
|
@44
|
[44]
|
3 years |
cs186 |
Small test file
|
|
|
|
@43
|
[43]
|
3 years |
cs186 |
skeleton for HW2
|
|
|
|
@42
|
[42]
|
3 years |
cs186 |
Check in a vanilla version of PostgreSQL 8.2.4
|
|
|
|
@41
|
[41]
|
3 years |
anonymous |
This is an empty revision for padding.
|
|
|
|
@40
|
[40]
|
3 years |
cs186 |
Ensure that the optimizer chooses index scan for the operator.
|
|
|
|
@39
|
[39]
|
3 years |
cs186 |
Make sure to use box_distance at the leaves.
|
|
|
|
@38
|
[38]
|
3 years |
cs186 |
install gist_private.h
|
|
|
|
@37
|
[37]
|
3 years |
cs186 |
Add gist_private.h to MyStuff?
|
|
|
|
@36
|
[36]
|
3 years |
cs186 |
install script
|
|
|
|
@35
|
[35]
|
3 years |
cs186 |
Clean up a failed assertion
|
|
|
|
@34
|
[34]
|
3 years |
cs186 |
Set up near-neighbor operator
|
|
|
|
@33
|
[33]
|
3 years |
cs186 |
SQL tests
|
|
|
|
@32
|
[32]
|
3 years |
cs186 |
Bare-bones skeleton of code to be changed.
|
|
|
|
@31
|
[31]
|
3 years |
joeh |
6-up version of GiST
|
|
|
|
@30
|
[30]
|
3 years |
joeh |
GiST and R-tree lecture
|
|
|
|
@29
|
[29]
|
3 years |
cs186 |
|
|
|
|
@28
|
[28]
|
3 years |
cs186 |
Add CS186 to comment
|
|
|
|
@27
|
[27]
|
3 years |
cs186 |
fix citation of Kornacker, et al.
|
|
|
|
@26
|
[26]
|
3 years |
cs186 |
cleanup gistget.c
|
|
|
|
@25
|
[25]
|
3 years |
cs186 |
cleaned up gistget.c
|
|
|
|
@24
|
[24]
|
3 years |
cs186 |
clean up gistget.c
|
|
|
|
@23
|
[23]
|
3 years |
cs186 |
Changes to PostgreSQL to provide a skeleton for HW2.
|
|
|
|
@22
|
[22]
|
3 years |
cs186 |
Check in a vanilla version of PostgreSQL 8.2.4
|
|
|
|
@21
|
[21]
|
3 years |
joeh |
some old, some new
|
|
|
|
@20
|
[20]
|
3 years |
joeh |
cleanups to 05, and addition of 07
|
|
|
|
@19
|
[19]
|
3 years |
cs186 |
Guest Lecture 01: Brian Cooper
|
|
|
|
@18
|
[18]
|
3 years |
cs186 |
week3 handouts posted
|
|
|
|
@17
|
[17]
|
3 years |
joeh |
more lecs
|
|
|
|
@16
|
[16]
|
3 years |
joeh |
PDF directly from Office 2007
|
|
|
|